Re: [GENERAL] cygwin and postgresql

2009-06-15 Thread James B. Byrne
On Mon, June 15, 2009 13:02, Scott Marlowe wrote: > > So, for sure something like: > > alter user dbuser with createdb; > > didn't fix the problem? > I have removed the windows installation and can no longer check this. I maintained the pg roles via pgadmin3 and, to the best of my ability to re

Re: [GENERAL] cygwin and postgresql

2009-06-15 Thread Scott Marlowe
On Mon, Jun 15, 2009 at 8:22 AM, James B. Byrne wrote: > On: 15 Jun 2009 12:08:22 GMT, Jasen Betts >> >> On Sun, June 14, 2009 15:45, Scott Marlowe wrote: >>> >>> Is there a reason you're not using the native windows postgresql >>> packages? >>> >> >> Because for some reason, processes running in

Re: [GENERAL] cygwin and postgresql

2009-06-15 Thread James B. Byrne
On: 15 Jun 2009 12:08:22 GMT, Jasen Betts > > On Sun, June 14, 2009 15:45, Scott Marlowe wrote: >> >> Is there a reason you're not using the native windows postgresql >> packages? >> > > Because for some reason, processes running in the cygwin environment > could not create databases in the postgr

Re: [GENERAL] cygwin and postgresql

2009-06-15 Thread Jasen Betts
On 2009-06-14, James B. Byrne wrote: > > On Sun, June 14, 2009 15:45, Scott Marlowe wrote: > why it would not form part of the cygwin >>> installation? >> >> Is there a reason you're not using the native windows postgresql >> packages? >> > > Because for some reason, processes running in the cygwi

Re: [GENERAL] cygwin and postgresql

2009-06-14 Thread James B. Byrne
Found it. The cygwin executables for postgres are installed under /usr/sbin, which is NOT in the PATH thus the problem, and the obvious solution. -- *** E-Mail is NOT a SECURE channel *** James B. Byrnemailto:byrn...@harte-lyne.ca Harte & Lyne Limited h

Re: [GENERAL] cygwin and postgresql

2009-06-14 Thread James B. Byrne
On Sun, June 14, 2009 15:45, Scott Marlowe wrote: why it would not form part of the cygwin >> installation? > > Is there a reason you're not using the native windows postgresql > packages? > Because for some reason, processes running in the cygwin environment could not create databases in the pos

Re: [GENERAL] cygwin and postgresql

2009-06-14 Thread Scott Marlowe
On Sun, Jun 14, 2009 at 11:30 AM, James B. Byrne wrote: > This may not be the right place for this question but I am going to > start here anyway. > > I have installed postgresql in cygwin on a MS-WinXPpro system.  I > wish to initialise  a database instance.  However, I cannot find any > program f

Re: [GENERAL] cygwin and postgresql

2009-06-14 Thread Tom Lane
"James B. Byrne" writes: > The packages that cygwin says I have installed are: > 8.2.11-1 postgresql: PostgreSQL Data Base Management System 3,707k > 8.2.11-1 postgresql-client: Front-end programs for PostgreSQL 8.x 972k > 8.2.11-1 postgresql-contrib ... 373k > 8.2.11-1 postgresql-devel: ... serv

Re: [GENERAL] cygwin and postgresql

2009-06-14 Thread James B. Byrne
On Sun, June 14, 2009 13:34, Tom Lane wrote: > > That sounds suspiciously like a client-only installation. What > package did you install exactly? Was there a -server package > beside it? The packages that cygwin says I have installed are: 8.2.11-1 postgresql: PostgreSQL Data Base Management

Re: [GENERAL] cygwin and postgresql

2009-06-14 Thread Tom Lane
"James B. Byrne" writes: > I have installed postgresql in cygwin on a MS-WinXPpro system. I > wish to initialise a database instance. However, I cannot find any > program file called initdb. In /usr/bin I can see files like: > pg_config.exe, pg_dump.exe and pg_dumpall.exe but no initdb.exe > a