Kelvin's tech-box

Topic

postgres

A collection of 3 issues

Postgres raise `remaining connection slots are reserved for non-replication superuser connections` error

The Reporting service raised the following error today: FATAL: remaining connection slots are reserved for non-replication superuser connections I check the database activity and relevant configurations via the following commands: check current using connection number: select count(1) from pg_stat_activity; check all the connections(not include current client

Postgres DB dump and restore

Export a database pg_dump -U username dbname > dbexport.pgsql pg_dump -U db_user -W -F t db_name > /path/to/your/file/dump_name.tar -F is used to specify the format of the output file, which can be one of the following: p – plain-text SQL

Setup Postgres on Ubuntu

Here is the brief step to setup the postgresql database on Ubuntu. Install sudo apt install postgresql postgresql-contrib sudo systemctl start postgresql.service Using postgres Roles and Database A default user account postgres is associated with role. sudo -i -u postgres psql postgres=# \q Create new role createuser --interactive or