[ADMIN] migrating/backup script

log 2>&1 check_err $? $DB.schema # data cat $BACKUP/pass | pg_dump -u -a -D -f ./$DB.data $DB > $DB.log 2>&1 check_err $? $DB.data # oids cat $BACKUP/pass | pg_dump -u -o -f ./$DB.oids $DB > $DB.log 2>&1 check_err $? $DB.oids echo "done." cd .. don

Re: [ADMIN] migrating/backup script

ately? Justin Georgeson wrote: Hello all. I recently came into the position of maintaining several SQL database servers. Having no prior experience other then FileMaker, I'm a little daunted. :) So one of things I'm doing is moving them to new servers. In the process I thought it would be

[ADMIN] pg_dumpall doesn't work

psql -V psql (PostgreSQL) 7.0.3 contains readline, history, multibyte support Portions Copyright (c) 1996-2000, PostgreSQL, Inc Portions Copyright (c) 1996 Regents of the University of California Read the file COPYRIGHT or use the command \copyright to see the usage and distribution terms. [postgr

Re: [ADMIN] pg_dumpall doesn't work

Tom Lane wrote: Justin Georgeson <[EMAIL PROTECTED]> writes: This is what I get when I do a pg_dumpall. I have *no* idea what to do here. It's a lot easier to do pg_dumpall if you are not using password authentication. Consider downgrading your pg_hba setting to "

Re: [ADMIN] pg_dumpall doesn't work

Justin Georgeson wrote: Tom Lane wrote: Justin Georgeson <[EMAIL PROTECTED]> writes: This is what I get when I do a pg_dumpall. I have *no* idea what to do here. It's a lot easier to do pg_dumpall if you are not using password authentication. Consider downgrading your pg_

Re: [ADMIN] StreamServer Port : bind() failed : How to solve this

raju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph : 4475111 Email : [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Justin Georgeson UnBound Technologies, Inc. http://www.

Re: [ADMIN] pg_hba

dressHere" to [EMAIL PROTECTED]) -- Justin Georgeson UnBound Technologies, Inc. http://www.unboundtech.com Main 713.329.9330 Fax713.460.4051 Mobile 512.789.1962 5295 Hollister Road Houston, TX 77040 Real Applications using Real Wireless Intelligence(tm) ---

[ADMIN] problem with authentication

a plain text file, and I thought pg_restore was only for tar and compressed tar dump files. Help. -- Justin Georgeson UnBound Technologies, Inc. http://www.unboundtech.com Main 713.329.9330 Fax713.460.4051 Mobile 512.789.1962 5295 Hollister Road Houston, TX 77040 Real Applications us