PostgreSQL Problems

PostgreSQL Problems

[Peter Atkins]

All,

I have been trying to get postgresql to work for the last 2 days. It tells
me that it needs the database system data and to use -D to specify. 
I do so and it then tells me that the PG_VERSION file is missing.

Need Help!

Thanks,
-pete

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: PostgreSQL problems

[Markus Hoenicka]

Hi Jason,

Jason Tishler writes:
 > As soon as zlib and readline have been rebuilt against 1.5.x, I will
 > take that fateful step... :,)
 > 

I'm hanging on the edge of my seat... Meanwhile I've figured out a
short-term fix (er, kludge): switch off statistics collection by
setting:

STATS_START_COLLECTOR = false

in postgresql.conf. Then PostgreSQL seems to work just fine.

regards,
Markus

-- 
Markus Hoenicka
markus.hoenicka@cats.de
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: PostgreSQL problems

[Jason Tishler]

Markus,

On Fri, Jul 11, 2003 at 08:02:27PM +0200, Markus Hoenicka wrote:
> Jason Tishler writes:
>  > You can debug it yourself or wait until I cross the 1.5.x line...
> 
> Well, I'm not the most proficient debugger on the face of the earth,
> and I'm not familiar with the PostgreSQL sources. Even if try, I bet
> you'll have crossed the 1.5.x line before I've got an idea where to
> look.

As soon as zlib and readline have been rebuilt against 1.5.x, I will
take that fateful step... :,)

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

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: PostgreSQL problems

[Markus Hoenicka]

Jason Tishler writes:
 > You can debug it yourself or wait until I cross the 1.5.x line...
 > 

Well, I'm not the most proficient debugger on the face of the earth,
and I'm not familiar with the PostgreSQL sources. Even if try, I
bet you'll have crossed the 1.5.x line before I've got an idea where
to look.

Thanks anyway for your help.

regards,
Markus

-- 
Markus Hoenicka
markus.hoenicka@cats.de
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: PostgreSQL problems

[Jason Tishler]

Markus,

On Fri, Jul 11, 2003 at 07:23:02PM +0200, Markus Hoenicka wrote:
> Jason Tishler writes:
>  > Are you using Cygwin 1.3.22-1?  If so, then try 1.5.0-1:
> 
> After upgrading to 1.5.0-1, things improved slightly. PostgreSQL now
> starts up like this:
> 
> [snip]
> 
> Now I can connect with psql, but the console that I've started
> postmaster from gets flooded with a continuous stream of the following
> message, slowing down the database server to a creep:
> 
> LOG:  statistics collector process (pid 174) exited with exit code 1
> LOG:  PGSTATBUFF: recvfrom() failed: Transport endpoint is already connected
> 
> (the pid changes with every incarnation of the message).
> 
> Is there anything I can do about this?

You can debug it yourself or wait until I cross the 1.5.x line...

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

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: PostgreSQL problems

[Markus Hoenicka]

Jason Tishler writes:
 > Are you using Cygwin 1.3.22-1?  If so, then try 1.5.0-1:
 > 

After upgrading to 1.5.0-1, things improved slightly. PostgreSQL now
starts up like this:

Administrator@ocean ~
$ ipc-daemon &
[1] 193

Administrator@ocean ~
$ postmaster -D /usr/share/postgresql/data &
[2] 174

Administrator@ocean ~
$ LOG:  database system was interrupted at 2003-07-11 19:09:54
LOG:  checkpoint record is at 0/83B2F8
LOG:  redo record is at 0/83B2F8; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 480; next oid: 16976
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  ReadRecord: record with zero length at 0/83B338
LOG:  redo is not required
LOG:  database system is ready


Now I can connect with psql, but the console that I've started
postmaster from gets flooded with a continuous stream of the following
message, slowing down the database server to a creep:

LOG:  statistics collector process (pid 174) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Transport endpoint is already connected

(the pid changes with every incarnation of the message).

Is there anything I can do about this?

Thanks
Markus

-- 
Markus Hoenicka
markus.hoenicka@cats.de
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: PostgreSQL problems

[Jason Tishler]

Markus,

On Fri, Jul 11, 2003 at 01:09:56AM +0200, Markus Hoenicka wrote:
> LOG:  StreamConnection: accept() failed: Socket operation on non-socket
                                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

> [snip]
> I've tried PostgreSQL 7.3.2-2 and 7.3.3-1 together with cygipc 1.13-2
> and 1.14-1. No luck in either combination.
> 
> The system is a freshly installed WinNT4 with a fresh Cygwin
> installation.

Are you using Cygwin 1.3.22-1?  If so, then try 1.5.0-1:

    On Thu, Jul 10, 2003 at 12:13:50AM -0400, Christopher Faylor wrote:
    > Changes since 1.3.22-1 (not a bad release as releases go):
    > [snip]
    > - Fix "not a socket" errors.  (Corinna Vinschen)

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

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

PostgreSQL problems

[Markus Hoenicka]

Hi all,

I've got problems setting up PostgreSQL on Cygwin. I've been following
the excellent description in the PostgreSQL readme file and got the
following result:

Administrator@ocean ~
$ ipc-daemon &
[1] 157

Administrator@ocean ~
$ initdb -D /usr/share/postgresql/data
The files belonging to this database system will be owned by user "Administrator".
This user must also own the server process.

The database cluster will be initialized with locale C.

<... everything went ok here...>

Success. You can now start the database server using:

    /usr/bin/postmaster -D /usr/share/postgresql/data
or
    /usr/bin/pg_ctl -D /usr/share/postgresql/data -l logfile start


Administrator@ocean ~
$ postmaster -D /usr/share/postgresql/data &
[2] 176

Administrator@ocean ~
$ LOG:  database system was shut down at 2003-07-11 00:17:52
LOG:  checkpoint record is at 0/83B238
LOG:  redo record is at 0/83B238; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 480; next oid: 16976
LOG:  database system is ready
LOG:  StreamConnection: accept() failed: Socket operation on non-socket

Administrator@ocean ~
$ psql template1
psql: could not receive data from server: Cannot send after transport
endpoint shutdown

I've tried PostgreSQL 7.3.2-2 and 7.3.3-1 together with cygipc 1.13-2
and 1.14-1. No luck in either combination.

The system is a freshly installed WinNT4 with a fresh Cygwin
installation.

What am I doing wrong?

regards,
Markus

-- 
Markus Hoenicka
markus.hoenicka@cats.de
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/