Re: storage

On 12/13/06, Antonios Katsikadamos <antonioskatsikadamos(at)yahoo(dot)com> wrote:
> Hi all,
>
> Sorry to bother. I would like to know where postgres stores the created
> database and the tables.Can anyone help,

which OS or distribution is it?

look into the startup script that starts postgresql service.
The path is configurable depends on the package mantainer.
in redhat it used to be /var/lib/data.

if you can connect to the database as superuser you can give the command

psql# SHOW data_directory;

in recent versions of postgresql.

>
>
> thnx for any help,
>
> Antonios
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>