We're getting the error as part of an automated test suite and it is seems to occur every time the suite is run. The platform is Win XP 64 bit. When running the same unit test suite from a remote machine, the error does not occur. The error also does not occur when manually running the create database command using pgadmin. We are logging into PostgreSQL as the same user. Patrick On 1/11/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
"Patrick Earl" <patearl@xxxxxxxxxxx> writes: > 2007-01-11 09:56:17 ERROR: could not open relation 1663/16403/16426: > Permission denied > 2007-01-11 09:56:17 ERROR: checkpoint request failed > 2007-01-11 09:56:17 HINT: Consult recent messages in the server log > for details. > 2007-01-11 09:56:17 STATEMENT: CREATE DATABASE "TestDatabase" Well, like the HINT says, consult recent messages for details. In this case the reason the checkpoint failed was evidently a file permissions problem. Is this repeatable? What platform is it on? regards, tom lane