≡ Menu

Postgres

15 Practical PostgreSQL Database Administration Commands

Earlier we discussed about how to install PostgreSQL database on Linux from source. In this article, let us review top 15 practical postgreSQL DBA command examples. If you are a mySQL administrator, check-out our 15 examples of mysqladmin command article that we discussed a while back. $ /usr/local/pgsql/bin/psql postgres postgres Password: (oldpassword) # ALTER USER [...]

{ 21 comments }

This is a guest post written by SathiyaMoorthy pg_dump is an effective tool to backup postgres database. It creates a *.sql file with CREATE TABLE, ALTER TABLE, and COPY SQL statements of source database. To restore these dumps psql command is enough. Using pg_dump, you can backup a local database and restore it on a [...]

{ 25 comments }