pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Multiple databases
4+ messages / 3 participants
[nested] [flat]
* Re: Multiple databases
@ 2003-01-13 22:32 Josh Berkus <josh@agliodbs.com>
parent: Noah Silverman <noah@allresearch.com>
0 siblings, 0 replies; 4+ messages in thread
From: Josh Berkus @ 2003-01-13 22:32 UTC (permalink / raw)
To: Noah Silverman <noah@allresearch.com>; Rod Taylor <rbt@rbt.ca>; +Cc: pgsql-performance
Noah,
> Can someone give me a good description of what the various directories
> and files actually are. I have RTFMed, but the descriptions there
> don't seem to match what I have on my machine.
Within $PGDATA:
/base is all database files unless you use WITH LOCATION
/pg_clog is the Clog, which keeps a permanent count of transactions
/pg_xlog is the transaction log (WAL)
/global are a small number of relations, like pg_database or pg_user, which
are available in all databases.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 4+ messages in thread
* Multiple databases
@ 2003-01-14 20:51 Noah Silverman <noah@allresearch.com>
0 siblings, 1 reply; 4+ messages in thread
From: Noah Silverman @ 2003-01-14 20:51 UTC (permalink / raw)
To: pgsql-performance
Hi,
A quick configuration question for everybody...
When we create more than one database with psql, it appears as if
everything is thrown into the same directory.
I can understand having all the tables and indexes for a given database
in the same directory, but multiple databases?
Do we need to configure something differently, or is this just how
postgres works?
Thanks,
-Noah
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Multiple databases
@ 2003-01-14 20:54 Rod Taylor <rbt@rbt.ca>
parent: Noah Silverman <noah@allresearch.com>
0 siblings, 1 reply; 4+ messages in thread
From: Rod Taylor @ 2003-01-14 20:54 UTC (permalink / raw)
To: Noah Silverman <noah@allresearch.com>; +Cc: pgsql-performance
> Do we need to configure something differently, or is this just how
> postgres works?
Thats just how it works. Under 'base' there are a number of numbered
directories which represent various databases.
If you really want, take a look at the "WITH LOCATION" option for create
database.
Command: CREATE DATABASE
Description: create a new database
Syntax:
CREATE DATABASE name
[ [ WITH ] [ OWNER [=] dbowner ]
[ LOCATION [=] 'dbpath' ]
[ TEMPLATE [=] template ]
[ ENCODING [=] encoding ] ]
> Thanks,
>
> -Noah
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
Attachments:
signature.asc (application/pgp-signature, 186B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Multiple databases
@ 2003-01-14 20:58 Noah Silverman <noah@allresearch.com>
parent: Rod Taylor <rbt@rbt.ca>
0 siblings, 1 reply; 4+ messages in thread
From: Noah Silverman @ 2003-01-14 20:58 UTC (permalink / raw)
To: Rod Taylor <rbt@rbt.ca>; +Cc: pgsql-performance
Thanks,
Can someone give me a good description of what the various directories
and files actually are. I have RTFMed, but the descriptions there
don't seem to match what I have on my machine.
Thanks.
On Tuesday, January 14, 2003, at 03:54 PM, Rod Taylor wrote:
>> Do we need to configure something differently, or is this just how
>> postgres works?
>
> Thats just how it works. Under 'base' there are a number of numbered
> directories which represent various databases.
>
> If you really want, take a look at the "WITH LOCATION" option for
> create
> database.
>
>
> Command: CREATE DATABASE
> Description: create a new database
> Syntax:
> CREATE DATABASE name
> [ [ WITH ] [ OWNER [=] dbowner ]
> [ LOCATION [=] 'dbpath' ]
> [ TEMPLATE [=] template ]
> [ ENCODING [=] encoding ] ]
>
>> Thanks,
>>
>> -Noah
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo@postgresql.org so that your
>> message can get through to the mailing list cleanly
> --
> Rod Taylor <rbt@rbt.ca>
>
> PGP Key: http://www.rbt.ca/rbtpub.asc
> <signature.asc>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-01-14 20:58 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-14 20:51 Multiple databases Noah Silverman <noah@allresearch.com>
2003-01-14 20:54 ` Rod Taylor <rbt@rbt.ca>
2003-01-14 20:58 ` Noah Silverman <noah@allresearch.com>
2003-01-13 22:32 ` Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox