Re: [ADMIN] Windows Version

2001-08-31 Thread Colin 't Hart
It is much easier to go to http://www.cygwin.com choose Download Cygwin Now and install everything. This way you have a complete Unix compatibility environment for Windows and a working installation of Postgres. Cheers, Colin Arne Weiner wrote: > PostgreSQL is a multiplatform DMBS. You can do

Re: [ADMIN] DATAWAREHOUSING

2001-08-31 Thread Egon Reetz
Derek, just for understanding, what does OLAP engine mean? Egon "Derek A. Neighbors" wrote: > Its inability to do OLAP (On-Line Analytical Processing) makes it a weak > tool to do so. It would be nice to see great bridge or some other > vendor create an OLAP engine that works well with Postg

Re: [ADMIN] Windows Version

2001-08-31 Thread Henshall, Stuart - WCP
There is now a pre-built binary that comes cygwin, available at www.cygwin.com. There is also pgsql-cygwin mailing list. - Stuart > -Original Message- > From: Arne Weiner [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, August 30, 2001 6:28 PM > To: [EMAIL PROTECTED] > Subject: Re: Windo

[ADMIN] postgresql and samba

2001-08-31 Thread Dong B . Calmada
Hi. I am currently installing samba server. My organization has just decided postgresql as our official database server. Have you any experience in this chemistry, I mean, postgresql working under samba environment? Can they work together, that is? Thanks. -- DONG B. CALMADA Database Adminis

[ADMIN] Starting postmaster with the option -i

2001-08-31 Thread Raquel Vieira
I'm using Postgres 7.1.2 and I need to use TCP/IP connections, so I want to start Postmaster with the option -i. The Postmaster is starting allone at the startup of the computer, but it initiates by itself, I can't start it with that option. I have to stop it and start it again with the option by

[ADMIN] automatical start of postmaster for Windows2000

2001-08-31 Thread Jouji Miwa
Dear PostgreSQL Adminstrators, Now I operate manually to run postmaster. If the postmaster is automatically run, it is easy for a guest to use. Please tell me how to run automatically postmaster program for Windows2000. OS: Windows2000 DB: PostgreSQL 7.1.2 SH: Cygwin B20 Now command : postmaste

Re: [ADMIN] Starting postmaster with the option -i

2001-08-31 Thread Gary Stainburn
Hi Raquel, The postmaster is probably being started using pg_ctl in /etc/init.d/postgresql. Add -o -i to the line, which tells pg_ctl to send the '-i' switch to the back-end. Gary On Friday 31 August 2001 9:38 am, Raquel Vieira wrote: > I'm using Postgres 7.1.2 and I need to use TCP/IP con

Re: [ADMIN] Starting postmaster with the option -i

2001-08-31 Thread speedboy
[root@b] : cat /etc/rc.d/init.d/postgresql #!/bin/sh #[ -x /tmp/.s.PGSQL.* ] && rm -f /tmp/.s.PGSQL.* case "$1" in 'start') su - postgres -c 'exec /usr/local/pgsql/bin/pg_ctl -o -i -D /home/postgres/data start >> /usr/local/pgsql/errlog 2>&1 &' ;; 'stop') su - postgres -c 'exec /usr/loc

Re: [ADMIN] Starting postmaster with the option -i

2001-08-31 Thread Lamar Owen
On Friday 31 August 2001 04:38, Raquel Vieira wrote: > Does anyone know how can I start postmaster (at the startup of the > computer) with the option -i? If this is an RPM installation (which is what it sounds like), edit the file /var/lib/pgsql/data/postgresql.conf and set the 'tcpip_socket' co

Re: [ADMIN] postgresql and samba

2001-08-31 Thread Hans Spaans
On Friday 31 August 2001 10:13, you wrote: > Hi. > > I am currently installing samba server. My organization has just > decided postgresql as our official database server. Have you any > experience in this chemistry, I mean, postgresql working under samba > environment? Can they work together, tha

Re: [ADMIN] Starting postmaster with the option -i

2001-08-31 Thread Nick Fankhauser
Raquel- I believe that by v7.1, this could be placed in the postgresql.conf file. (Found in /etc/postgresql on our Debian Linux box.) the line to add is: tcpip_socket = 1 check out this page for details: http://www.postgresql.org/idocs/index.php?runtime-config.html It's probably not starting

Re: [ADMIN] Starting postmaster with the option -i

2001-08-31 Thread Stephan Szabo
On 31 Aug 2001, Raquel Vieira wrote: > I'm using Postgres 7.1.2 and I need to use TCP/IP connections, so I > want to start Postmaster with the option -i. > The Postmaster is starting allone at the startup of the computer, but > it initiates by itself, I can't start it with that option. I have to

Re: [ADMIN] Starting postmaster with the option -i

2001-08-31 Thread Shaun Thomas
On 31 Aug 2001, Raquel Vieira wrote: > Does anyone know how can I start postmaster (at the startup of the > computer) with the option -i? The file that is starting postgres is one of these: /etc/rc.d/init.d/postgresql /etc/rc.d/init.d/postgres /etc/rc.d/init.d/postgresd The last one is the mos

Re: [ADMIN] Starting postmaster with the option -i

2001-08-31 Thread Lamar Owen
On Friday 31 August 2001 09:50, Gary Stainburn wrote: > The postmaster is probably being started using pg_ctl in > /etc/init.d/postgresql. > Add -o -i to the line, which tells pg_ctl to send the '-i' switch to the > back-end. PLEASE don't edit /etc/rc.d/init.d/postgresql. Edit /var/llib/pgsql/

Re: [ADMIN] Starting postmaster with the option -i

2001-08-31 Thread Lamar Owen
On Friday 31 August 2001 09:55, speedboy wrote: > [root@b] : cat /etc/rc.d/init.d/postgresql > su - postgres -c 'exec /usr/local/pgsql/bin/pg_ctl -o -i -D > That help? :) While this _does_ work, why not use postgresql.conf for its proper purpose? The RPM initscript, for security reasons, does

Re: [ADMIN] postgresql and samba

2001-08-31 Thread ecaillava
Tengo a mi cargo una red local compuesta de un dominio con alrededor de 50 máquinas Win98, mas unos 70 usuarios mas distribuídos en 6 sub-redes. Todos son clientes de dos servidores corriendo ambos SuSE 7 y Samba 2.2.1a, en ambos casos como PDC, pero además, uno de ellos corre PostgreSQL 7.1 c