Postgres Pro
Downloads
Home   >   mailing lists

Thread: Help required

Help required

From
"Ravindran Vijaykumar R-AVR025"
Date:
 
Hi Friends,
 
I am using postgres 7.4.2 in Ubuntu linux...
 
when I run psql -l command, it says the following error....
 
postgres@host:~$ psql -l
psqll: could not connect to server: Connection refused
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
 
I have the backup database in the home folder, please update me, how should i make the database up...
 
rgds
vijay

Re: Help required

From
"Shoaib Mir"
Date:
Run the following

pg_ctl -D <data folder path> status

to see if you have the db server running or not?

As these seems to me you dont have the database server running on port 5432.

Thanks,
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 10/3/06, Ravindran Vijaykumar R-AVR025 < vijay.ravindran@motorola.com> wrote:
 
Hi Friends,
 
I am using postgres 7.4.2 in Ubuntu linux...
 
when I run psql -l command, it says the following error....
 
postgres@host:~$ psql -l
psqll: could not connect to server: Connection refused
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
 
I have the backup database in the home folder, please update me, how should i make the database up...
 
rgds
vijay

Re: Help required

From
Matthias.Pitzl@izb.de
Date:
Hello Vijay!
 
Not 100% sure but Ubuntu should have the database set up similar to Debian on which it's based. This means, you can start the database via:
/etc/init.d/postgresql start
This should use the distribution specific startup scripts.
 
Greetings,
Matthias
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Ravindran Vijaykumar R-AVR025
Sent: Tuesday, October 03, 2006 12:00 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Help required

 
Hi Friends,
 
I am using postgres 7.4.2 in Ubuntu linux...
 
when I run psql -l command, it says the following error....
 
postgres@host:~$ psql -l
psqll: could not connect to server: Connection refused
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
 
I have the backup database in the home folder, please update me, how should i make the database up...
 
rgds
vijay

Re: Help required

From
"Jim C. Nasby"
Date:
And run, do not walk, to the latest version of 7.4.x. Better yet,
upgrade to 8.1.4.

On Thu, Oct 05, 2006 at 01:04:05AM +0500, Shoaib Mir wrote:
> Run the following
>
> pg_ctl -D <data folder path> status
>
> to see if you have the db server running or not?
>
> As these seems to me you dont have the database server running on port 5432.
>
> Thanks,
> ---
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 10/3/06, Ravindran Vijaykumar R-AVR025 <vijay.ravindran@motorola.com>
> wrote:
> >
> >
> >Hi Friends,
> >
> >I am using postgres 7.4.2 in Ubuntu linux...
> >
> >when I run psql -l command, it says the following error....
> >
> >postgres@host:~$ <postgres@host:%7E$> psql -l
> >psqll: could not connect to server: Connection refused
> >        Is the server running locally and accepting
> >        connections on Unix domain socket
> >"/var/run/postgresql/.s.PGSQL.5432"?
> >
> >I have the backup database in the home folder, please update me, how
> >should i make the database up...
> >
> >rgds
> >vijay
> >

--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)