Christopher Browne wrote:
> In the last exciting episode, [EMAIL PROTECTED] ("Kumar") wrote:
> > I was looking for a structure like oracle or ms Sql?server in Postgres. What I
> > have expected is individual
> > datafiles for individual databases. But i cant fine such items in the
> > /usr/local/
In the last exciting episode, [EMAIL PROTECTED] ("Kumar") wrote:
> I was looking for a structure like oracle or ms Sql server in Postgres. What I have
> expected is individual
> datafiles for individual databases. But i cant fine such items in the
> /usr/local/pgsql/data directory.
>
> Will the p
> 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
---
Dear Friends,
I was looking for a structure like oracle or ms
Sql server in Postgres. What I have expected is individual datafiles for
individual databases. But i cant fine such items in the /usr/local/pgsql/data
directory.
Will the postgres create individual data file for
databases?
H
