Re: pgsql data file location

From: "Ismaila Kane" <ikane(at)ciscolabs(dot)net>
To: <mallah(at)trade-india(dot)com>
Cc: <mallah(at)trade-india(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgsql data file location
Date: 2003-04-11 20:35:03
Message-ID: 34CAF5F88702A84E8352999083BD219A4083@policeforum.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you.

-----Original Message-----
From: mallah(at)trade-india(dot)com [mailto:mallah(at)trade-india(dot)com]
Sent: Fri 4/11/2003 3:53 PM
To: Ismaila Kane
Cc: mallah(at)trade-india(dot)com; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] pgsql data file location

> Hello Mallah,
>
> Tried the PG_dump command and it works great. Any idea about the location of the backup
> file?

pg_dump is supposed to outout to stdout. you can redirect to a file using >

$ pg_dump dbname > /path/to/dumpfile.sql


Also is the database backup or are the tables and schemas backed up too.

it backs up everything in the database except large objects(lo)
(ignore it if u dont know understand lo)

what else do u expect it to backup if not tables and schemas?

Any restore
> command to be used .

$ psql -f dumpfile.sql


>
> Thank you
>
> Ismaila Kane
> ----- Original Message -----
> From: <mallah(at)trade-india(dot)com>
> To: <ikane(at)ciscolabs(dot)net>
> Cc: <pgsql-general(at)postgresql(dot)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(at)trade-india(dot)com>
>> > To: <ikane(at)ciscolabs(dot)net>
>> > Cc: <pgsql-general(at)postgresql(dot)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/



-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/


Browse pgsql-general by date

  From Date Subject
Next Message Sean Chittenden 2003-04-11 20:36:03 Re: [GENERAL] medical image on postgreSQL?
Previous Message Tom Lane 2003-04-11 20:31:52 Re: pg_dump: NOTICE: ShmemAlloc: out of memory