Can I separate my Databases as in FireBird? Working with DataBases...

From: Durumdara <durumdara(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can I separate my Databases as in FireBird? Working with DataBases...
Date: 2009-01-20 08:29:14
Message-ID: 9e384ef60901200029j63a76e33x70b238a208671ee9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I came from SQLite, FireBird and DBISAM world.
These database systems have a speciality that they stores one database in
one file, or in one directory.

Each of databases have separated file (or dir with files), and when I want
to copy a database, I have MORE possibility to do this.
First solution is the file-system based copy.
Next is the embedded dump (FireBird).
And the last is some SQL dump.

Sometimes the customers have problems with the programs we wrote.
In this case sometimes we ask them that send me the DB fully.
They are using filesystem based copy. We open the DB, or the tables here
simply, without special doing. Only we register the DB with the name "test",
and we can test the applications simply.

But PGSQL have only one directory named data. All of the databases placed
here.
I cannot separate them.
If the user send me a DB, I cannot copy it simply to anywhere, and register
it. Because it have only SQL dump.

Ok, I saw that PGSQL have tablespace.

But: the databases need to be unique named. Previously I thought that
tablespace higher object than database, and I can create more database with
same name without collision if I use another tablespace for them.
But when I tried to do this, I got error.

So: we want to search for a simplified way to place and separate our 200
databases, and 200*8 applications without problems (to our development
machine). And we wanna use them easier. If some of the customers want to
resend a "real db" to us (for testing), we want to register easier this new
db without rewrite our test context.

Have anybody an experience with PGSQL and many similar, but not same DB
usage?
What is the easiest way to handle the question of the data transporting in
the PGSQL?

Thanks for your help:
dd

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Wenk 2009-01-20 08:30:51 Re: pg_restore: [archiver] entry ID -825110830 out of range -- perhaps a corrupt TOC
Previous Message Albe Laurenz 2009-01-20 08:27:47 Re: How to find how much postgresql use the memory?