From: | Maarten Boekhold <boekhold(at)emirates(dot)net(dot)ae> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL? |
Date: | 2004-06-07 15:04:03 |
Message-ID: | 40C483E3.7090607@emirates.net.ae |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi,
The original poster seemed not to care too much about whether the data
in this database is persistent. Under that assumption, I wonder if it's
possible to do the following:
1- start postmaster
2 - create database on RAM disk (will be easy once tablespaces are there)
3 - work with this database
4 - postmaster shuts down / reboot server
5 - start postmaster
6 - create database ...
The question is whether 5/6 will work, as the database will have entries
in the system catalogs, and since the data of the database has
disappeared. I.e. postmaster will probably complain mightly on startup.
Perhaps it's possible to first start postmaster in single user mode to
clean up the system catalogs?
Maarten
From | Date | Subject | |
---|---|---|---|
Next Message | Kari Lavikka | 2004-06-07 15:10:43 | contents of pg_database vanished.. |
Previous Message | Jernej Kos | 2004-06-07 14:39:23 | Index question |
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2004-06-07 15:13:38 | Re: [pgsql-hackers-win32] Failures with windows port |
Previous Message | Tom Lane | 2004-06-07 15:00:12 | Re: serverlog function (log_destination file) |