Re: dump restore help

On Thursday 12 July 2007 12:48, "Brian P Ford Sr" <fordbp@gmail.com> wrote:
> I am in the computer forensic business and need to restore a dump file
> and stand up the data base. I've never worked nor seen PostgreSQL before.
> Will the restored database need a user name and password also?   Thanks

If the dump is from pg_dumpall it will include global information such as
users and passwords.

If it's a single DB dump you will need to create the users and database
first manually before restoring. The dump should just be a text file, you
can look at the beginning of it to see if it's creating databases and users
and such.

--
We're Microsoft. Everything else is just patent infringement.