Thread: storage

Hi all,

Sorry to bother. I would like to know where postgres stores the created database and the tables.Can anyone help,


thnx for any help,

Antonios

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

They are physically stored in the PGDATA folder, for example on a default windoze installation you can find it at:

C:\Program Files\PostgreSQL\8.2\data

--------------------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

To be more precise they are in PGDATA\base...

--------------------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 12/13/06, Antonios Katsikadamos <antonioskatsikadamos@yahoo.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
>