Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?

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

In response to

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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)