## RE: postgresql on win2000

From: "Henshall, Stuart - WCP" "'Baron'" "'pgsql-cygwin(at)postgresql(dot)org'" RE: postgresql on win2000 2001-07-31 08:15:13 E2870D8CE1CCD311BAF50008C71EDE8E01F74651@MAIL_EXCHANGE (view raw or flat) 2001-07-31 08:15:13 from "Henshall, Stuart - WCP" pgsql-cygwin
It seems that the backend is working.
(FYI: cygwin uses INET sockets anyway, but remeber on Unix/Linux/BSD
to use postmaster -i & to enable TCP/IP connections).
1) I've never used ipgsql so can not really help. (Have you tried
pgadmin?). It could be that you have to edit the pg_hba.conf file in your
data directory. Also if its connecting via ODBC you'll need to make sure
thats set up (see http://odbc.postgresql.org ).
2) That looks fine to me (IIRC first number is the OID of the
inserted row, second number is the number of rows inserted).
3) I'm guessing there is still a missing path, or a missing program.
There should be a program called less.exe in /bin that should have been
installed in the cygwin setup. If this is missing rerun setup and include
it. If it is there then that probably means that your path isn't pointing
towarsds it. psql just uses less to display result sets and it won't stop
the backend functioning.
- Stuart

> -----Original Message-----
> From:	Baron [SMTP:baron(at)jeecom-t(dot)com]
> Sent:	Tuesday, July 31, 2001 5:01 AM
> To:	Henshall, Stuart - WCP
> Subject:	RE: [CYGWIN] postgresql on win2000
>
> Thanks.
> Now, I can open database, create tables and users in cygwin. Does it mean
> I have posted
> postgresql to win2000 successfully? I am not sure.
> 1.I cannot connect postgresql by ipgsql (client for postgresql). How
> should I do?
> 2.When I insert a record into a table, it response 'INSERT 35438 1'. Is it
> ok?
> 3.When I select * from table, it response 'less: not found'. Is it a
> problem?
>
> Baron
>
> -----Original Message-----
> From: Henshall, Stuart - WCP
> [mailto:SHenshall(at)westcountrypublications(dot)co(dot)uk]
> Sent: Friday, July 27, 2001 7:40 PM
> To: 'Baron'; Henshall, Stuart - WCP
> Cc: 'pgsql-cygwin(at)postgresql(dot)org'
> Subject: RE: [CYGWIN] postgresql on win2000
>
>
> 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
> > - 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
> > > - 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
> > > >
> > > > 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

### pgsql-cygwin by date

 Next: From: Jason Tishler Date: 2001-07-31 18:29:41 Subject: Re: PostgreSQL Previous: From: Markus Hoenicka Date: 2001-07-31 00:04:44 Subject: client connection problem