To connect to a specific database as a specific user:
psql -h myserver.mydomain.com -U music musicdb or psql -h 127.0.0.1 -U music musicdb
Or, when already connected to database in psql.
Here, I first connect to the default database (postgres) as the software owner (also postgres) but then change the database connection to a database called "mydb" logged in as user "jim":
[postgres@myserver.mydomain.com ~]$ psql psql (11.7) Type "help" for help. postgres=# \conninfo You are connected to database "postgres" as user "postgres" via socket in "/var/run/postgresql" at port "5432". postgres=# \c mydb jim myserver.mydomain.com 5432 Password for user jim: You are now connected to database "mydb" as user "jim" on host "myserver.mydomain.com" at port "5432".
No comments:
Post a Comment