Posts Tagged ‘backup’

pg_restore: [archiver] input file appears to be a text format dump. Please use psql.

pg_restore: [archiver] input file appears to be a text format dump. Please use psql. Reason: pg_dump by default creates the sql commands necessary to recreate the data. To recover it, you just need to invoke psql (not pg_restore ) with the file as input . pg_restore is only to be used for the binary format […]

pg_dump: [archiver] could not open output file: Permission denied

Following error occurs when try to take backup of database to the file system. But, the user(superuser) does not have permission to backup location. pg_dump: [archiver] could not open output file “bank_20170531.sql”: Permission denied. Backup Command tried to run: pg_dump -U postgres bank -f /home/vijay/dumps/bank_20170531.sql Resolution: Change permission of directory /home/vijay/dumps/ to user postgres. chown […]

Backup and Restore Database in PostgreSQL

There are different ways to take backup and restore database in PostrgeSQL. With PostgreSQL, backups can be full, incremental or continuous, and they can be at logical or filesystem level. Point-in-time recovery is also possible from incremental backups. Tools Used for Backup and Restore Database in PostgreSQL: pg_dump: 1. This utility is used backing up […]

Stop Sybase backup server

If we want to stop only Sybase backup server or it is best practice to stop backup server first then, ASE server. We can stop backup server using following ‘shutdown SYB_BACKUP’ 1> shutdown SYB_BACKUP 2> go Backup Server 3.48.1.1: The Backup Server go down immediatley. Terminating sessions.

Database refresh in Sybase

Database refresh is routine task for database administrators. Following are the steps needs to be performed in database refresh activity. Scenario: Assume that, We have two instances one is on production server and another is development server. When we are loading data from production to development server, development server database size should be greater than […]

Powered by k2schools