Обсуждение: 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