Thread: Backup Fails

Backup Fails

From

Adarsh Sharma

Date:

23 February 2011, 03:17:19

Dear all,

I performed backup of databases in Database Servers but Today when I'm
going to backup of one of databases , the following error occurs :

[root@s8-mysd-2 8.4SS]# bin/pg_dump -Upostgres -i -o pdc_uima_olap |
gzip -c > /hdd4-1/pdc_uima_olap108feb18.sql.gz
Password:
pg_dump: [archiver (db)] connection to database "pdc_uima_olap" failed:
FATAL:  could not write init file
[root@s8-mysd-2 8.4SS]#


Don't know the actual reason of this as remainning databases are backed
up correctly.

Please guide with some suggestion to overcome it.


Thanks & best  Regards,
Adarsh Sharma

Re: Backup Fails

From

Tom Lane

Date:

23 February 2011, 03:37:15

Adarsh Sharma <adarsh.sharma@orkash.com> writes:
> Dear all,
> I performed backup of databases in Database Servers but Today when I'm
> going to backup of one of databases , the following error occurs :

> [root@s8-mysd-2 8.4SS]# bin/pg_dump -Upostgres -i -o pdc_uima_olap |
> gzip -c > /hdd4-1/pdc_uima_olap108feb18.sql.gz
> Password:
> pg_dump: [archiver (db)] connection to database "pdc_uima_olap" failed:
> FATAL:  could not write init file
> [root@s8-mysd-2 8.4SS]#

Server out of disk space or the data directory somehow became
write-protected, I'd guess.

            regards, tom lane