Re: dump restore help - Mailing list pgsql-novice

From Alan Hodgson
Subject Re: dump restore help
Date
Msg-id 200707121256.29472@hal.medialogik.com
Whole thread Raw
In response to dump restore help  ("Brian P Ford Sr" <fordbp@gmail.com>)
List pgsql-novice
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.


pgsql-novice by date:

Previous
From: "Kasia Tuszynska"
Date:
Subject: Re: postgres config
Next
From: Shreya Bhargava
Date:
Subject: Re: postgres config