Failure to recognise new database
I did a CVS checkout today, and the following database creation fails.
In psql:-
You are now connected to database template1 as user postgres.
template1=# select version();
version
------------------------------------------------------------------------
PostgreSQL 7.1devel on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)
template1=# create database test;
CREATE DATABASE
template1=# \c test
FATAL 1: Database "test" does not exist in the system catalog.
Previous connection kept
Now restart the postmaster
template1=# \c test
You are now connected to database test.
Is it just me?
Regards,
Grant
--
Poorly planned software requires a genius to write it
and a hero to use it.
Grant Finnemore BSc(Eng) (mailto:gaf@ucs.co.za)
Software Engineer Universal Computer Services
Tel (+27)(11)712-1366 PO Box 31266 Braamfontein 2017, South Africa
Cell (+27)(82)604-5536 20th Floor, 209 Smit St., Braamfontein
Fax (+27)(11)339-3421 Johannesburg, South Africa
Is it just me?
I'm pretty sure I saw something similar on a newly initialized database.
The sequence was:
initdb
postmaster -i -o -F
createdb
psql
(database "thomas" not found)
psql template1
\d
(see "thomas")
psql
(database "thomas" found just fine)
- Thomas
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
Is it just me?
I'm pretty sure I saw something similar on a newly initialized database.
Are you guys running with WAL enabled? If so, this is probably the
BufferSync issue that Hiroshi thought I broke a couple days ago.
Let me know...
regards, tom lane
Tom Lane wrote:
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
Is it just me?
I'm pretty sure I saw something similar on a newly initialized database.
Are you guys running with WAL enabled? If so, this is probably the
BufferSync issue that Hiroshi thought I broke a couple days ago.
Let me know...
Yes, I am running WAL enabled.
regards, tom lane
Regards,
Grant
--
Poorly planned software requires a genius to write it
and a hero to use it.
Grant Finnemore BSc(Eng) (mailto:gaf@ucs.co.za)
Software Engineer Universal Computer Services
Tel (+27)(11)712-1366 PO Box 31266 Braamfontein 2017, South Africa
Cell (+27)(82)604-5536 20th Floor, 209 Smit St., Braamfontein
Fax (+27)(11)339-3421 Johannesburg, South Africa
Are you guys running with WAL enabled? If so, this is probably the
BufferSync issue that Hiroshi thought I broke a couple days ago.
Let me know...
Yes, I too am running with WAL enabled.
- Thomas
Grant Finnemore <gaf@ucs.co.za> writes:
Tom Lane wrote:
Are you guys running with WAL enabled? If so, this is probably the
BufferSync issue that Hiroshi thought I broke a couple days ago.
Let me know...
Yes, I am running WAL enabled.
OK, I put back the BufferSync call. Sorry 'bout that, chief...
regards, tom lane