> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Ana Paula > Sent: 07 November 2001 19:51 > To: Freevsd-Support > Subject: How can I start PostgreSQL ??? > > > > Hi all! > > How can I do for start PostgreSQL in a Virtual Server ? > Fubra FAQ says that: > > ........................................... fubra > ......................................... > > Add the following to > /usr/share/freevsd/skel-repo/etc/rc.conf: > > # Set to YES to enable PostgreSQL > postgresql_enable="NO" > postgresql_port=NONE > > Finally, rebuild your skel, and re-create your virtual servers. > Each VS that wants a PostgreSQL database must be given a unique port > number, by editing /etc/rc.conf in the VS *after* it has been created. > Postgres generates shared memory mappings based on it's port number. Two > Postgres databases cannot run on the same server on the same port > because their shared memory key ids will clash. > > ........................................... fubra > ......................................... > > But, I don't understand very well what number port I have can put in: > " postgresql_port=??? " > > In what port PostgreSQL daemon listen by default ? Put whatever you want as long as it's not a port in use by another service it's not going to be a problem is it. That is what 'unique' means. > Another part that I'm not understanding is: > > " Two Postgres databases cannot run on the same server on the same port > because their shared memory key ids will clash. " > > What is mean exactly ? It means that each postgres database running on a server has to use a unique port. You cannot run two copies of postgres on the same server and have them using the same port, it will not work. I suggest you do some reading around the subject of shared memory mapping if you want to know why you have to use different ports, otherwise just follow the instructions to assign each instance of postgres a different port. > For each database running in a PostgreSQL "server", I need a different > port ? > > Really, it's very obscure for me ...... > > I will thanks for any help ...... You can't get much clearer that saying "each postgres database must be given a unique port number" and "Two Postgres databases cannot run on the same server on the same port"! This simply means these 2 things: 1> Each copy of Postgres running on a server must be given a unique port number. 2> If you try to run two copies of postgres on the same port number on the same server it will not work (each copy should be allocated its own unique port to make it work). If you want to know about 'why' it doesn't work you need to go and read up on shared memory mapping. cheers, Alex. ------------------------- The freeVSD Support List -------------------------- Subscribe: mailto:[EMAIL PROTECTED]?body=subscribe%20freevsd-support Unsubscribe: mailto:[EMAIL PROTECTED]?body=unsubscribe%20freevsd-support Archives: http://freevsd.org/support/mail-archives/freevsd-support -----------------------------------------------------------------------------
