pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Multiple databases
4+ messages / 3 participants
[nested] [flat]

* Multiple databases
@ 2003-01-14 20:51 Noah Silverman <noah@allresearch.com>
  2003-01-14 20:54 ` Re: Multiple databases Rod Taylor <rbt@rbt.ca>
  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:51 Multiple databases Noah Silverman <noah@allresearch.com>
@ 2003-01-14 20:54 ` Rod Taylor <rbt@rbt.ca>
  2003-01-14 20:58   ` Re: Multiple databases 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:51 Multiple databases Noah Silverman <noah@allresearch.com>
  2003-01-14 20:54 ` Re: Multiple databases Rod Taylor <rbt@rbt.ca>
@ 2003-01-14 20:58   ` Noah Silverman <noah@allresearch.com>
  2003-01-13 22:32     ` Re: Multiple databases Josh Berkus <josh@agliodbs.com>
  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

* Re: Multiple databases
  2003-01-14 20:51 Multiple databases Noah Silverman <noah@allresearch.com>
  2003-01-14 20:54 ` Re: Multiple databases Rod Taylor <rbt@rbt.ca>
  2003-01-14 20:58   ` Re: Multiple databases Noah Silverman <noah@allresearch.com>
@ 2003-01-13 22:32     ` Josh Berkus <josh@agliodbs.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


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