Re: [ADMIN] migrating/backup script

2002-12-16 Thread mark carew
Hi Justin, I have this scrawled inside the back cover of my copy of PostgreSQL "a developer's handbook'. It must have worked or I wouldn't have written it. create a file for backup e.g. G:\HCCISA.SQL (obviously a samba mapped drive and file) as ROOT on linux red hat 7

Re: [ADMIN] migrating/backup script

2002-12-12 Thread Justin Georgeson
Anyone? Bueller? What's the usefulness of dumping data (-d/D) and oids (-o) separately? Should I scrap the extra step for oids? If not what order should I restore them in? Other than asking people who were around when the stuff was created, how would I know if I need to dump oids separately? J

[ADMIN] migrating/backup script

2002-12-11 Thread Justin Georgeson
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 a good idea to come up with a backup