Thread: setting port number? making 7.4.1 cygwin and 8.0.1 msi work

setting port number? making 7.4.1 cygwin and 8.0.1 msi work

From
Daniel Convissor
Date:
Hi:

I'm presently running 7.4.1 cygwin as a service on a Windows 2000 machine.
That was installed using the instructions in
c:/cygwin/usr/share/doc/Cygwin/postgresql-7.4.1.README. I'd also like to
install PostgreSQL 8.0.1 on the same machine via the postgresql-8.0.msi
and hope some folks here can provide some insights.

To install multiple versions of MySQL, one must have each version
responding on different ports.  I'm assuming the same thing would need to
be done with postmaster.  Is this true?

If so, how do I initialize/install the service for 7.4.1/cygwin to be on a
different port?

Any other helpful pointers about setting up a dual postmaster system?

Thanks,

--Dan

--
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409

Re: setting port number? making 7.4.1 cygwin and 8.0.1 msi

From
George Weaver
Date:
Hi Dan;

There might be others with more pertinent advice than I can give.

I installed 8 Beta 5 and then 8.0 on a Win XP machine having 7.3.2 installed
under Cygwin.

When installing 8 a message advises removing cygwin/bin from the System
Path.  I did that for the installation, and then added it back to the path
after the installation of 8 was complete.  I haven't experienced any
problems but the caution must be there for a reason :-).

When using the msi installer, you have the option of setting the Port for 8.
I installed 8 beta 5 using 5433 and 8.0 using 5434.  I will be uninstalling
the beta 5 version shortly and the 7.3 version later on, and will adjust the
ports accordingly.

Under such a scenario, you may run into conflicts starting psql (there will
be more than one version on the machine) and to get to the right database
you will have to specify the port when initiating psql or setting up pgAdmin
3.

Other than that I have haven't experienced any problems (or maybe I've just
been lucky...)

Regards,
George

----- Original Message -----
From: "Daniel Convissor" <danielc@analysisandsolutions.com>
To: "PostgreSQL Cygwin" <pgsql-cygwin@postgresql.org>
Sent: Thursday, February 03, 2005 12:53 PM
Subject: [CYGWIN] setting port number? making 7.4.1 cygwin and 8.0.1 msi
work


> Hi:
>
> I'm presently running 7.4.1 cygwin as a service on a Windows 2000 machine.
> That was installed using the instructions in
> c:/cygwin/usr/share/doc/Cygwin/postgresql-7.4.1.README. I'd also like to
> install PostgreSQL 8.0.1 on the same machine via the postgresql-8.0.msi
> and hope some folks here can provide some insights.
>
> To install multiple versions of MySQL, one must have each version
> responding on different ports.  I'm assuming the same thing would need to
> be done with postmaster.  Is this true?
>
> If so, how do I initialize/install the service for 7.4.1/cygwin to be on a
> different port?
>
> Any other helpful pointers about setting up a dual postmaster system?
>
> Thanks,
>
> --Dan
>
> --
> T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
>            data intensive web and database programming
>                http://www.AnalysisAndSolutions.com/
> 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>



Re: setting port number? making 7.4.1 cygwin and 8.0.1 msi

From
Reini Urban
Date:
Daniel Convissor schrieb:
> I'm presently running 7.4.1 cygwin as a service on a Windows 2000 machine.
> That was installed using the instructions in
> c:/cygwin/usr/share/doc/Cygwin/postgresql-7.4.1.README. I'd also like to
> install PostgreSQL 8.0.1 on the same machine via the postgresql-8.0.msi
> and hope some folks here can provide some insights.
>
> To install multiple versions of MySQL, one must have each version
> responding on different ports.  I'm assuming the same thing would need to
> be done with postmaster.  Is this true?
>
> If so, how do I initialize/install the service for 7.4.1/cygwin to be on a
> different port?
>
> Any other helpful pointers about setting up a dual postmaster system?

I haven't tried that yet, but using sockets for the cygwin system would
be better: easier to maintain (no conflicting ports) and faster.

--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/