[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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
# 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 

Reply to: