# 1. Create the user (if it doesn't exist)
sudo -u postgres createuser toxlab
# 2. Create the database with the correct owner
sudo -u postgres createdb -O toxlab toxrefdb_3_0
# 3. Import the data (try this one first)
pg_restore -U toxlab -d toxrefdb_3_0 -v toxrefdb_3_0.dump
# If connecting over LAN:
# -h <server_ip>: Specifies the hostname or IP address of the server to connect to.
# -W: Forces a password prompt. This is good practice.
pg_restore -h 192.168.1.100 -U toxlab -d toxrefdb_3_0 -v -W toxrefdb_3_0.dump
# 4. If pg_restore fails, use this one instead
psql -U toxlab -d toxrefdb_3_0 < toxrefdb_3_0.dump
# 5 Import the dump file
psql -U toxlab -d toxrefdb_3_0 < toxrefdb_3_0.dump
# .. or over LAN
psql -h 192.168.1.100 -U toxlab -d toxrefdb_3_0 -W < toxrefdb_3_0.dump
After the import is complete, you can connect to your new database and verify the data is there
# Connect to the database
psql -U toxlab -d toxrefdb_3_0
# Once inside psql, list the tables to verify
\dt