Re: advice

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