[ADMIN] move dbs from 8.1 to 8.4

2013-10-10 Thread Marc Fromm
I built a new server running centos 6.4 and postgresql 8.4. I backed up all the databases from the old server running fedora and postgresql 8.1 using this script. #!/bin/bash # Backup all Postgresql databases # Location of the backup logfile. logfile="/var/lib/pgsql/backups/logs/pg_back.log" #

Re: [ADMIN] move dbs from 8.1 to 8.4

2013-10-10 Thread Payal Singh
Can you use '-v' with pg_dumpall and output to the log file? That might help. Likely something is not right with the individual pg_dump processes that work inside the pg_dumpall. Payal Singh, OmniTi Computer Consulting Inc. Junior Database Architect, Phone: 240.646.0770 x 253 On Thu, Oct 10, 201

Re: [ADMIN] move dbs from 8.1 to 8.4

2013-10-10 Thread Marc Fromm
: [ADMIN] move dbs from 8.1 to 8.4 I built a new server running centos 6.4 and postgresql 8.4. I backed up all the databases from the old server running fedora and postgresql 8.1 using this script. #!/bin/bash # Backup all Postgresql databases # Location of the backup logfile. logfile="/var/lib/

Re: [ADMIN] move dbs from 8.1 to 8.4

2013-10-10 Thread Steve Crawford
On 10/10/2013 01:17 PM, Marc Fromm wrote: I built a new server running centos 6.4 and postgresql 8.4. I backed up all the databases from the old server running fedora and postgresql 8.1 using this script. *#!/bin/bash* *# Backup all Postgresql databases* ** *# Location of the backup logfi

Re: [ADMIN] move dbs from 8.1 to 8.4

2013-10-10 Thread Marc Fromm
anks I am using 8.4 just because it's what gets installed with CentOS6.4. From: Steve Crawford [mailto:scrawf...@pinpointresearch.com] Sent: Thursday, October 10, 2013 1:55 PM To: Marc Fromm; pgsql-admin@postgresql.org Subject: Re: [ADMIN] move dbs from 8.1 to 8.4 On 10/10/2013 01:17 PM, Marc

Re: [ADMIN] move dbs from 8.1 to 8.4

2013-10-10 Thread Marc Fromm
Thursday, October 10, 2013 1:55 PM To: Marc Fromm; pgsql-admin@postgresql.org Subject: Re: [ADMIN] move dbs from 8.1 to 8.4 On 10/10/2013 01:17 PM, Marc Fromm wrote: I built a new server running centos 6.4 and postgresql 8.4. I backed up all the databases from the old server running fedora and