Re: pgsql data file location - Mailing list pgsql-general

Hello Mallah,

Tried the PG_dump command and it works great. Any idea about the location of
the backup file?Also is the database backup  or are the tables and schemas
backed up too.Any restore command to be used .

Thank you

Ismaila Kane
----- Original Message -----
From: <mallah@trade-india.com>
To: <ikane@ciscolabs.net>
Cc: <pgsql-general@postgresql.com>
Sent: Friday, April 11, 2003 2:17 PM
Subject: Re: [GENERAL] pgsql data file location


>
> Dear Kane,
>
> you are rite it does not say explicitly the location of data file .
>
> But if you are wanting to know it for backup purposes reasons you are
> in the wrong direction.
>
> The only way to make safe/consistent backups in postgresql is to use
> pg_dump or pg_dumpall.
>
> If you are just curious about the location, it is either passed to
postmaster
> by -D option or by environment PGDATA. for typical tar ball installs it is
> /usr/local/pgsql/data/ in RPM based it is /var/lib/pgsql/data
>
> under data folder there exists a folder "base" , under "base" one  folder
per database.
> these folders have names correspoding to internal ids in system catalogs.
> under these numeric folder there are files for individual tables and
indexes.
>
> but do not copy these files and folder thinking that you are "backing up"
> it will be futile , as said pg_dump/all is the only way of backing up.
>
> Regds
> Mallah.
>
>
>
>
>
> > Yes I read the manual but does not say where the location of the data
file is?
> > ----- Original Message -----
> > From: <mallah@trade-india.com>
> > To: <ikane@ciscolabs.net>
> > Cc: <pgsql-general@postgresql.org>
> > Sent: Friday, April 11, 2003 4:14 AM
> > Subject: Re: [GENERAL] pgsql data file location
> >
> >
> >>
> >> All that is possible.
> >> I you have not read the Admin Docs yet.
> >>
> >> Regds
> >> mallah.
> >>
> >>
> >> > I am trying to find where psql reads the data from when a table is
> > created. Also is it possible
> >> > to copy that data and transfer it onto another system running psql.
If
> > not does anyone know a
> >> > good psql backup solution.
> >> >
> >> > Thanks
> >> >
> >> > ismaila Kane
> >>
> >>
> >>
> >> -----------------------------------------
> >> Get your free web based email at trade-india.com.
> >>    "India's Leading B2B eMarketplace.!"
> >> http://www.trade-india.com/
>
>
>
> -----------------------------------------
> Get your free web based email at trade-india.com.
>    "India's Leading B2B eMarketplace.!"
> http://www.trade-india.com/
>
>