Thread: pg_dump and pg_restore
I have a 7.3.4 db that is now around 7 gig in size. Are there any issues with backups and restores on SunOS 5.9? My dumps never seem to be quite right. I'm using 'pg_dump -v -Fc dvm > dvm.bak'. It just seems to die at some point.(disk space is not an issue)
Thanks,
-Stephen
"Stephen Clancy" <stephen@vmdirect.com> writes:
> I have a 7.3.4 db that is now around 7 gig in size. Are there any issues wi=
> th backups and restores on SunOS 5.9?
You need to be sure that pg_dump and pg_restore are built with
large-file support if you want them to deal with dump files exceeding
4 gig. I'm not clear on whether that is default on Solaris.
(I believe you can work around lack of large-file support by fooling
with pipes, but it'd be better to fix the problem.)
regards, tom lane