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

Поиск
Список
Период
Сортировка
От Maarten Boekhold
Тема Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?
Дата
Msg-id 40C483E3.7090607@emirates.net.ae
обсуждение исходный текст
Ответ на Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?  (Gaetano Mendola <mendola@bigfoot.com>)
Ответы Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Jernej Kos
Дата:
Сообщение: Index question
Следующее
От: Kari Lavikka
Дата:
Сообщение: contents of pg_database vanished..