postgresql

You have to use following command to take backup : You can use below command to take backup of postgresql database. pg_dump mydb > db.out You can use this command to restore database psql -d database -f db.out

You can install ‘tablefunc' extension and for that you have to follow below steps: To install 'tablefunc' extension you have to install 'postgresql-contrib' package: yum install postgresql-contrib First you have to login into PostgreSQL with commands. psql -U postgres After login connect to...