On Friday 10 November 2006 08:37, "Alex Turner" <[EMAIL PROTECTED]> wrote: > Sure thing, I hope it's as simple as user error! > > #!/bin/sh > export DATE=`date +%Y%m%d` > > /usr/local/pgsql/bin/pg_dump -Upostgres -hlocalhost trend > > /backup/trend.dump.$DATE > > Thats pretty much it repeated for each database. I just upgraded to > 8.1.5to see if that would fix the problem, but it didn't >
If you're going to backup each database separately, you also need to run a pg_dumpall -g to get global objects (roles, etc.), and restore that first. -- They laughed at Columbus, they laughed at Fulton, they laughed at the Wright brothers. But they also laughed at Bozo the Clown." -- Carl Sagan ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
