RE: postgresql on win2000

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'Baron'" <baron(at)jeecom-t(dot)com>, "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
Cc: "'pgsql-cygwin(at)postgresql(dot)org'" <pgsql-cygwin(at)postgresql(dot)org>
Subject: RE: postgresql on win2000
Date: 2001-07-27 11:39:33
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F74649@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

I think I see what is up. I guess you installed postgresql as a specific
user and have now logged out and logged backin as the administrator for
which no user exists in any of the databases. You can give user
administrator privs by doing the following:
psql -U user_name template1
where user_name is the user_name you installed under.
then at the psql prompt:
CREATE USER Administrator CREATEDB CREATEUSER;
this should then create a user administrtor with full privs in for that data
set of postgresql.
- Stuart

> -----Original Message-----
> From: Baron [SMTP:baron(at)jeecom-t(dot)com]
> Sent: Friday, July 27, 2001 12:33 PM
> To: Henshall, Stuart - WCP
> Subject: RE: [CYGWIN] postgresql on win2000
>
> I have created a new user on win2000 and login again.
> I am not sure if it is working fine. There have below messages.
>
> bash-2.05$ export PGDATA=/usr/local/pgsql/data
> bash-2.05$ postmaster &
> [1] 2040
> bash-2.05$ ps ax
> PID PPID PGID WINPID TTY UID STIME COMMAND
> 2308 1 2308 2308 con 500 19:00:53 /usr/bin/bash
> 2040 2308 2040 1808 con 500 19:02:40 /usr/bin/postgres
> 1924 2308 1924 1868 con 500 19:02:42 /usr/bin/ps
> bash-2.05$ DEBUG: database system was interrupted at 2001-07-27 17:23:03
> DEBUG: CheckPoint record at (0, 2272592)
> DEBUG: Redo record at (0, 2272592); Undo record at (0, 0); Shutdown TRUE
> DEBUG: NextTransactionId: 943; NextOid: 27229
> DEBUG: database system was not properly shut down; automatic recovery in
> progre
> ss...
> DEBUG: ReadRecord: record with zero len at (0, 2272656)
> DEBUG: redo is not required
> DEBUG: database system is in production state
> bash-2.05$ psql mct
> FATAL 1: user "Administrator" does not exist
> psql: FATAL 1: user "Administrator" does not exist
>
> Baron
>
>
> -----Original Message-----
> From: Henshall, Stuart - WCP
> [mailto:SHenshall(at)westcountrypublications(dot)co(dot)uk]
> Sent: Friday, July 27, 2001 6:27 PM
> To: 'Baron'
> Cc: 'pgsql-cygwin(at)postgresql(dot)org'
> Subject: RE: [CYGWIN] postgresql on win2000
>
>
> cat should be in /bin (/usr/bin as one is linked to the other via a
> mount).
> Make sure your path points to here. (eg: In Win 9x make a line if I
> remember
> correctly PATH=c:\cygwin\bin;%PATH% ) Have a look at the cygwin site to
> see
> what advice about paths they give (as well as the postgresql README).
> - Stuart
>
> > -----Original Message-----
> > From: Baron [SMTP:baron(at)jeecom-t(dot)com]
> > Sent: Friday, July 27, 2001 9:45 AM
> > To: Henshall, Stuart - WCP
> > Subject: RE: [CYGWIN] postgresql on win2000
> >
> > Thanks.
> > It seems have some progress.
> > But it cannot recognize 'cat' command at the cygwin bash command line.
> > How can I do?
> >
> > Baron
> >
> > -----Original Message-----
> > From: Henshall, Stuart - WCP
> > [mailto:SHenshall(at)westcountrypublications(dot)co(dot)uk]
> > Sent: Thursday, July 26, 2001 11:00 PM
> > To: 'Baron'
> > Cc: 'pgsql-cygwin(at)postgresql(dot)org'
> > Subject: RE: [CYGWIN] postgresql on win2000
> >
> >
> > Sounds like you don't have your path correctly set up (or you've missed
> > installing sed). Have a look at the FAQ for the paths needed (can't
> > remember
> > of hand, but c:\cygwin\bin or similar will probably be needed).
> > Unless you have a strong need to do other wise I think trying to get the
> > pre-built binaries working would probably be the easiest route. You may
> > have
> > to set a path to where ever the executable is and then do something
> like:
> > ipc-daemon &; initdb -D <data-dir>; postmaster -i -D <data-dir> &
> > I think there's a postgresql-README in the postgresql-7.1.2-3 packages
> > used
> > by the cygwin setup. (puts it to
> /usr/doc/Cygwin/postgresql-7.1.2.README)
> > - Stuart
> > P.S. mail the list as well so that all may share
> >
> > > -----Original Message-----
> > > From: Baron [SMTP:baron(at)jeecom-t(dot)com]
> > > Sent: Thursday, July 26, 2001 12:16 PM
> > > To: Henshall, Stuart - WCP
> > > Subject: RE: [CYGWIN] postgresql on win2000
> > >
> > > There have below errors when I run ./config
> > >
> > > sed: not found
> > > configure: error: can not find sources in or ...
> > >
> > > Baron
> > >
> > > -----Original Message-----
> > > From: Henshall, Stuart - WCP
> > > [mailto:SHenshall(at)westcountrypublications(dot)co(dot)uk]
> > > Sent: Thursday, July 26, 2001 6:39 PM
> > > To: 'Baron'
> > > Cc: 'pgsql-cygwin(at)postgresql(dot)org'
> > > Subject: RE: [CYGWIN] postgresql on win2000
> > >
> > >
> > > Just click on the cygwin Icon that appears after install (or
> > > start->menu->cygnus solutions->Cygwin BASH shell). This brings up a
> > > command
> > > prompt running the BASH shell
> > > - Stuart
> > >
> > > > -----Original Message-----
> > > > From: Baron [SMTP:baron(at)jeecom-t(dot)com]
> > > > Sent: Thursday, July 26, 2001 11:21 AM
> > > > To: Henshall, Stuart - WCP
> > > > Subject: RE: [CYGWIN] postgresql on win2000
> > > >
> > > > Sorry for my many questions.
> > > > How can I start 'cygwin bash command line' ?
> > > >
> > > > Baron
> > > >
> > > > -----Original Message-----
> > > > From: Henshall, Stuart - WCP
> > > > [mailto:SHenshall(at)westcountrypublications(dot)co(dot)uk]
> > > > Sent: Thursday, July 26, 2001 5:31 PM
> > > > To: 'Baron'
> > > > Cc: 'pgsql-cygwin(at)postgresql(dot)org'
> > > > Subject: RE: [CYGWIN] postgresql on win2000
> > > >
> > > >
> > > > Hello,
> > > > You need to be in the directory you expanded the postgresql
> source
> > > > into (and at the cygwin bash command line). I tend to go to /usr/src
> > and
> > > > tar-zxvf postgresql-7.1.2.tar.gz then go into postgresql-7.1.2 and
> > type
> > > > ./configure. However if you can use the pre-compiled postgresql you
> > may
> > > as
> > > > well (you'll probably need to do initdb before you can start the
> > > > postmaster,
> > > > and for both you need ipc-daemon to be running).
> > > > As to the packages you need to compile postgresql I tend to
> just
> > > > select the latest of all of them bar readline, of which I pick the
> > prev
> > > > 4.1
> > > > version (4.2 is missing a declaration postgresql uses, although
> > there's
> > > a
> > > > postgresql patch floating around somewhere to handle this).
> > > > - Stuart
> > > >
> > > > > -----Original Message-----
> > > > > From: Baron [SMTP:baron(at)jeecom-t(dot)com]
> > > > > Sent: Thursday, July 26, 2001 10:28 AM
> > > > > To: Henshall, Stuart - WCP
> > > > > Subject: RE: [CYGWIN] postgresql on win2000
> > > > >
> > > > > Thanks.
> > > > > The cygwin ipc daemon service is running now.
> > > > > But I cannot run ./configure because win2000 seems cannot
> recognize
> > > this
> > > > > command.
> > > > > Can you give me any ideas?
> > > > >
> > > > > By the way. What packages I need to select when I am installing
> > > cygwin?
> > > > >
> > > > > Baron
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: Henshall, Stuart - WCP
> > > > > [mailto:SHenshall(at)westcountrypublications(dot)co(dot)uk]
> > > > > Sent: Thursday, July 26, 2001 4:30 PM
> > > > > To: 'Baron'; pgsql-cygwin(at)postgresql(dot)org
> > > > > Subject: RE: [CYGWIN] postgresql on win2000
> > > > >
> > > > >
> > > > > ./configure
> > > > > make
> > > > > make install
> > > > > initdb -D <data-dir>
> > > > >
> > > > > Make sure the cygipc stuff is up and running (ipc-daemon &) before
> > > > > anything
> > > > > else. Also you may not realise it but the latest versions of
> cygwin
> > > come
> > > > > with postgresql precompiled. You still need to get cygipc however,
> > its
> > > > at:
> > > > >
> http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/cygipc/
> > > > > For more info there is a FAQ at:
> > > > > http://postgresql.bteg.net/docs/faq-mswin
> > > > > For more info look to www.postgresql.org which also has searchable
> > > > mailing
> > > > > list for pgsql-cygwin and also techdocs.postgresql.org
> > > > > hope this help
> > > > > - Stuart
> > > > >
> > > > >
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Baron [SMTP:baron(at)jeecom-t(dot)com]
> > > > > > Sent: Thursday, July 26, 2001 9:21 AM
> > > > > > To: pgsql-cygwin(at)postgresql(dot)org
> > > > > > Subject: [CYGWIN] postgresql on win2000
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Could you please tell me how to run 'configure' command on
> win2000
> > > > > > after I unzip postgresql-7.1.2.tar.gz? Thanks.
> > > > > >
> > > > > > Baron
> > > > > >
> > > > > > ---------------------------(end of
> > > > broadcast)---------------------------
> > > > > > TIP 3: if posting/reading through Usenet, please send an
> > appropriate
> > > > > > subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> your
> > > > > > message can get through to the mailing list cleanly

Browse pgsql-cygwin by date

  From Date Subject
Next Message Jason Tishler 2001-07-27 16:39:05 Re: Cygwin PostgreSQL shutdown handling (was Re: Make Cygwin damons easier to use on Win9x.)
Previous Message Henshall, Stuart - WCP 2001-07-27 10:26:40 RE: postgresql on win2000