Thread: 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