PostgreSQL Import and Export

Import command

psql-d game-u postgres-f/root/plubic.sql

The following error occurred:

Psql:FATAL:Peer authentication failed for user "Postgres" The workaround for this subcommand

Run the following command to edit the pg_hba.conf file because pg_hba.conf cannot be found

Find/-name pg_hba.conf

Vi/var/lib/pgsql/9.5/data/pg_hba.conf

2. The

# Database Administrative Login by Unix domain socketlocal   all             postgres                                peer

Switch

# Database Administrative Login by Unix domain socketlocal   all             postgres                                Trust



3. After saving, execute the following command to reload the configuration file:

/etc/init.d/postgresql-9.5 Reload

4. Log in to Postgres
Sudo-u Postgres Psql
\l   Viewing a database
\c GAME   
\d   Viewing the game's table

PostgreSQL Import and Export