Thread: storage

storage

From
Antonios Katsikadamos
Date:
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

Re: storage

From
"Shoaib Mir"
Date:
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)


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,


thnx for any help,

Antonios

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


Re: storage

From
"Shoaib Mir"
Date:
To be more precise they are in PGDATA\base...

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

On 12/13/06, Shoaib Mir <shoaibmir@gmail.com> wrote:
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)


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,


thnx for any help,

Antonios

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



Re: storage

From
"Rajesh Kumar Mallah"
Date:
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
>