How to connect with postgres CLI
su postgres
psql -U postgres -W Password
su postgres
psql -U postgres -W PasswordPostgress keywords in comparison to MySQL
database=# \l //show databases
database=# \c database // use database
database=# \dt // show tables;
database=# \d table // describe table
database=# \x on //syntax enabled
database=# \l //show databases
database=# \c database // use database
database=# \dt // show tables;
database=# \d table // describe table
database=# \x on //syntax enabledPG_VERSION is the necessary data directory of that table pg_filenode.map is necessary
how to take backup in psql
export PGPASSWORD=`cat /etc/heplify-server.toml | grep DBPass | awk '{print $3}' | tr -d '"'`
pg_dump -U homer_user -h localhost -d homer_config -t users > /root/backup.sql
export PGPASSWORD=`cat /etc/heplify-server.toml | grep DBPass | awk '{print $3}' | tr -d '"'`
pg_dump -U homer_user -h localhost -d homer_config -t users > /root/backup.sqlHow to configure SSL
Go to this Link
Enjoy 😉
No comments:
Post a Comment