Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannot assign requested address

Hi Tom, Thanx for the reply and suggestion. Actually , I did wait for more than 5 hrs before posting this issue in this alias. It will be really great if you can advise on how to proceed from here. Does the below information points to any issue with my Linux Box configuration is it an issue with

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign requested address

Hi Mike, Thanx for the response. The ps -A don't have POSTMASTER and I did check it earlier too. Do you foresee any issue with Linux configuration or is it the POSTGRES issue? Please let me know how to proceed from here. Thanx in advance. Regards Sidd -Original Message- From: mike g [

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannot

mike g <[EMAIL PROTECTED]> writes: > It sounds like your application is either not responding to or > confirming the shutdown request from the db. I think not. If the old postmaster were still alive, he'd be getting a different error message --- the data directory lockfile is checked before tryin

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannot

Hi, I believe a fast shutdown prevents new connections to the db, sends termination signals to any applications with current connections, and then after it receives confirmation that those applications have aborted their transactions and closed their connections the db stops. It sounds like your

Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannot assign requested address

"Siddharth Rath (sirath)" <[EMAIL PROTECTED]> writes: > When I tried to restart the DB/Postmaster it says : > StreamServerPort: bind() failed: Cannot assign requested address > Is another postmaster already running on port 5432? > If not, wait a few seconds and retry. > cannot cre

[ADMIN] URGENT : StreamServerPort: bind() failed: Cannot assign requested address

Hi, I've an application running on RedHat Linux and we are using Postgres as our DB. Initially the DB was running perfectly but due to some requirement we stopped the DB with " pg_ctl stop -m 'fast' " command. When I tried to restart the DB/Postmaster it says : StreamServerPort: bind() failed: C

[ADMIN] unsubscribe

-- Kent L. Nasveschuk <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] remote synchronisation

Hi, new to the list, and relatively new to Postgres admin too but here's my situation. I have a website running on PHP/Postgres and I'd like to set up a secondary box which can be used to fall back on should the primary die for some reason. How would I go about ensuring the databases are kept

Re: [ADMIN] SSH connection timing out

do you mean the "seconds between keepalive" ? and thanks i will try it. Quoting Jeremy Smith <[EMAIL PROTECTED]>: > I looked at putty's help documentation and found a keep-alive setting that > will send empty packets every so often to keep the session active. It's > pretty much the same thing th

Re: [ADMIN] no ftp

There seemed to be some type of dns issue yesterday as we recieved a couple of reports like this. In the future you can send trouble reports to [EMAIL PROTECTED] if you'd like. Bruno's suggestions do hold up though... try http://www.postgresql.org/ftpsite/ or try the sourceforge project page at htt

[ADMIN] Setting PostgreSQL Log Configuration Parameters

Hi, I am new to PostgreSQL and can anyone suggest what are the best suggested values for the following log parameters in the PostgreSQL conf file. I would need to set these for the Production environment and my database version is 7.4 -- #client_min_messa

Re: [ADMIN] Mac OS 10.3 Panther make questions

Jeremy Buchmann <[EMAIL PROTECTED]> writes: > ... Readline is available, and this may be the way to go if you > can't get readline to compile on its own. There isn't anything difficult about installing readline from source on Panther. Untar, configure, make, sudo make install. Alternatively yo

Re: [ADMIN] Mac OS 10.3 Panther make questions

You can compile without it (--without-readline). If you don't plan on using psql much it won't make any difference. On Feb 16, 2004, at 7:05 PM, Kevin Barnard wrote: I am trying to get PostgreSQL 7.4.1 to make with Mac OS 10.3 I run configure which complains about readline. I'm not sure how Ap

Re: [ADMIN] replication/mirror

darshan patel wrote: I had install postgresql server on two different port : default(5432) and other(5545), now I have to setup replication/mirror between them So what are the steps/setup procedure. Hello Darshan! I'm not sure you realise this, but it's common sense (not to mention polite) to u

[ADMIN] replication/mirror

I had install postgresql server on two different port : default(5432) and other(5545), now I have to setup replication/mirror between them So what are the steps/setup procedure. _ The new MSN toolbar! As convenient as it gets! http:

Re: [ADMIN] pgsql initial superuser

Dear Pedro , Hello. this is my "first" time using pgsql, and I seem to be running to a bit of a corner here :-) I've understood how to add a superuser/database-user/user but I have no user to begin with. ~# createuser superuser Shall the new user be allowed to create databases? (y/n) y Shall th

Re: [ADMIN] PQgetSSL relocation errror

On Thu, 2004-06-03 at 12:01, lise chhay wrote: > - I've a problem when I launched the command psql testdb. I get a error message : > psql:relocation error: psql : undefined symbol : PQgetSSL When you build PostgreSQL, you need to add --with-openssl to the configure command. Oliver Elphick ---

[ADMIN]

I have tried to install webauth on Mandrake 2.4.22. For this, I have installed : apache server, Tcl/Tk, PostgreSQL, mod_auth_pgsql et pwgen. - server apache work - Tcl/Tk work - mod_auth_pgsql work - pwgen work - At the installation of PostgreSQL, the command to start the server work : n