Re: dump restore help - Mailing list pgsql-novice

From Andrej Ricnik-Bay
Subject Re: dump restore help
Date
Msg-id b35603930707131450m256c443fp378c0a3ab605f715@mail.gmail.com
Whole thread Raw
In response to dump restore help  ("Brian P Ford Sr" <fordbp@gmail.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Peter Elmers
Date:
Subject: Windows user needs home-dir?
Next
From: John DeSoi
Date:
Subject: Re: Windows user needs home-dir?