Re: Datafiles for Databases - Mailing list pgsql-sql

From A.Bhuvaneswaran
Subject Re: Datafiles for Databases
Date
Msg-id Pine.LNX.4.44.0309191317380.2565-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Datafiles for Databases  ("Kumar" <sgnerd@yahoo.com.sg>)
List pgsql-sql
> Will the postgres create individual data file for databases?

Yes.

> How to get the datafile path of a database?

/var/lib/pgsql/data/base/, database directory name = pg_database.oid. You
can also use oid2name contrib module for finer detail.

regards,
bhuvaneswaran



pgsql-sql by date:

Previous
From: "A.Bhuvaneswaran"
Date:
Subject: Re: Automated Backup
Next
From:
Date:
Subject: Re: is this explain good or bad???