Skip site navigation (1) Skip section navigation (2)

Re: advice

From: Jason Tishler <jason(at)tishler(dot)net>
To: garyhot(at)hotmail(dot)com
Cc: Pgsql-Cygwin <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: advice
Date: 2004-01-04 13:43:10
Message-ID: 20040104134310.GA1404@tishler.net (view raw or flat)
Thread:
Lists: pgsql-cygwin
Gary,

Please post instead of sending private email.

On Sat, Jan 03, 2004 at 11:18:29PM +0800, garyhot wrote:
> Want to thank you for creating the Cygwin-postgresql help readme.
> Everything work fine when I use your readme to install the lastest
> postgresql 7.4.1.

You are welcome.

> However I could not exec CREATE DATABASE dbname TEMPLATE template1 if
> I run postmaster as a window service. But when I run the daemon from
> the command line, it work perfectly.

WFM:

    template1=# CREATE DATABASE foo TEMPLATE template1;
    CREATE DATABASE

> Here is the debug dump from the postmaster.log file.
> 
> DEBUG:  StartTransactionCommand
> 
> LOG:  statement: CREATE DATABASE dummy TEMPLATE template1;
> 
> DEBUG:  parse tree:
> 
> DETAIL:  {QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
> 
>             :resultRelation 0 :into <> :hasAggs false :hasSubLinks false
> :rtable <>
> 
>             :jointree <> :rowMarks () :targetList <> :groupClause <>
> :havingQual <>
> 
>             :distinctClause <> :sortClause <> :limitOffset <> :limitCount <>
> 
>             :setOperations <> :resultRelations ()}
> 
>            
> 
> DEBUG:  rewritten parse tree:
> 
> DETAIL:  ({QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
> 
>             :resultRelation 0 :into <> :hasAggs false :hasSubLinks false
> :rtable <>
> 
>             :jointree <> :rowMarks () :targetList <> :groupClause <>
> :havingQual <>
> 
>             :distinctClause <> :sortClause <> :limitOffset <> :limitCount <>
> 
>             :setOperations <> :resultRelations ()})
> 
>            
> 
> DEBUG:  ProcessUtility
> 
> cp: /dev/fs/C/var/postgresql/data/base/1: No such file or directory

The above path looks suspicious.

> ERROR:  could not initialize database directory
> 
> DETAIL:  Failing system command was: cp -r '/var/postgresql/data/base/1' '/var/
> postgresql/data/base/17226'
> 
> HINT:  Look in the postmaster's stderr log for more information.
> 
> DEBUG:  AbortCurrentTransaction
> 
> I believe the error is in the red line.


What red line?  I read my email with a "color blind" mail reader.

> Thanks for your help.

Sorry, I can't be more helpful.

> There is no such path on my cygwin path.

Are you referring to "/dev/fs/C?"  If so, then I believe this
(misconfiguration) is your problem.

> Where is the postmaster stderr log store btw?

The same place as stdout -- /var/log/postmaster.log.

Jason

-- 
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

pgsql-cygwin by date

Next:From: Peter EisentrautDate: 2004-01-04 18:25:39
Subject: Re: Cygwin PostgreSQL 7.4.1 Regression Test Issue
Previous:From: dcarreraDate: 2004-01-03 10:34:24
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group