Re: postgres update database problem
On Thu, 2002-03-21 at 04:54, Lance Hoffmeyer wrote:
> I tried to upgrade php4-pgsql and ended up having to upgrade the database.
> I ended the postgresql-dump early and all I have is a saved.data directory
> and a db.out file. How do I recreate my database from one of these?
If the db.out is right up to date:
# su - postgres
$ psql -d template1 < db.out
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"Thy word have I hid in mine heart, that I might not
sin against thee." Psalms 119:11