Thread: dump restore help
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 for any help.
Brian Ford.
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.
On 7/14/07, Brian P Ford Sr <fordbp@gmail.com> wrote: > On 7/12/07, Andrej Ricnik-Bay <andrej.groups@gmail.com> wrote: > > Assuming that you're not concerned about the authentication > > but rather about whether or not you'll be able to get to the data: > > That will be taken care of with the entry for the admin user in > > pg_hba.conf ... if you set the line for local access for the postgres > > user to trust you should have no problem accessing any of the > > data within the database (unless of course the application took > > care of encrypting information - in which case it all depends on > > the quality of the algorithm in use and the weakness/strength of > > the passwords (or other authentication mechanisms used); but > > I guess now I'm preaching to the teacher ;}) > > > > Something like > > local all postgres trust > > as the first line of pg_hba.conf should take care of your needs. > Thanks for the reply. Is it a stretch to consider importing the dump file > into Mysql or MSSql as a txt file? Sorry, no idea. I avoid MySQL. > Also what extension, if any, do the Postgresql tales have? None. > What direrectory would I find the tables in? That depends on the distribution you're using to run postgres. Under debian (and it's derivatives) it's something like /var/lib/postgresql/<version-number>/main/base And please don't top post. Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm