Thread: How to test my new install

I have just installed 8.4 on an XP.  My intent is to use it with Trac
and Apache.

I would like to validate the installation of pgsql.  What would be a
good method to make sure that pgsql is in there right?

Ray

On 01/02/2010 01:15, ray wrote:
> I have just installed 8.4 on an XP.  My intent is to use it with Trac
> and Apache.
>
> I would like to validate the installation of pgsql.  What would be a
> good method to make sure that pgsql is in there right?

Not sure what you mean..... I'd imagine the thing to do is to run your
application against it in a test setup and check tat everything works as
you expect.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Raymond,

Thank you for responding to my question.  I am sorry that I wasn't clear.

My concern is that when I start up my tool stack and it doesn't work, that I
will have an entire chain to troubleshoot.  If I could isolate each tool as
I install it, and validate that it is working, it will be easier to assess
any other difficulties.

Ray

----- Original Message -----
From: "Raymond O'Donnell" <rod@iol.ie>
To: "ray" <ray@aarden.us>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, February 01, 2010 3:33 AM
Subject: Re: [GENERAL] How to test my new install


> On 01/02/2010 01:15, ray wrote:
> > I have just installed 8.4 on an XP.  My intent is to use it with Trac
> > and Apache.
> >
> > I would like to validate the installation of pgsql.  What would be a
> > good method to make sure that pgsql is in there right?
>
> Not sure what you mean..... I'd imagine the thing to do is to run your
> application against it in a test setup and check tat everything works as
> you expect.
>
> Ray.
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod@iol.ie
>

On 01/02/2010 10:48, ray joseph wrote:
> Raymond,
>
> Thank you for responding to my question.  I am sorry that I wasn't clear.
>
> My concern is that when I start up my tool stack and it doesn't work, that I
> will have an entire chain to troubleshoot.  If I could isolate each tool as
> I install it, and validate that it is working, it will be easier to assess
> any other difficulties.

Well, to see if PostgreSQL is working, the simplest thing is to try
connecting with psql and see if it responds.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Raymond,

Thank you.  Yes, that sounds like a great step.  I am new to this so I could
use a little help:  What do you mean to connect to it and how would I do it?

Ray

----- Original Message -----
From: "Raymond O'Donnell" <rod@iol.ie>
To: "ray joseph" <ray@aarden.us>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, February 01, 2010 6:17 AM
Subject: Re: [GENERAL] How to test my new install


> On 01/02/2010 10:48, ray joseph wrote:
> > Raymond,
> >
> > Thank you for responding to my question.  I am sorry that I wasn't
clear.
> >
> > My concern is that when I start up my tool stack and it doesn't work,
that I
> > will have an entire chain to troubleshoot.  If I could isolate each tool
as
> > I install it, and validate that it is working, it will be easier to
assess
> > any other difficulties.
>
> Well, to see if PostgreSQL is working, the simplest thing is to try
> connecting with psql and see if it responds.
>
> Ray.
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod@iol.ie
>

On Mon, Feb 01, 2010 at 06:21:55AM -0600, ray joseph wrote:
> I am new to this so I could
> use a little help:  What do you mean to connect to it and how would I do it?

I'd have a flick through the manual if I were you; the following is a
reasonable place to start:

  http://www.postgresql.org/docs/8.4/static/tutorial-start.html

--
  Sam  http://samason.me.uk/

On 01/02/2010 12:21, ray joseph wrote:
> Raymond,
>
> Thank you.  Yes, that sounds like a great step.  I am new to this so I could
> use a little help:  What do you mean to connect to it and how would I do it?

psql is the command-line client for Postgres, which lets you connect to
databases and run SQL commands directly against them. You can read about
it here:

  http://www.postgresql.org/docs/8.4/interactive/app-psql.html

On the XP machine, open a command prompt and type....

[path to PG install dir]\bin\pgsql -U [username] [databasename]

...and see if you can connect to the database. If you can connect and
run queries, then the DB server is running.

If your app stack is connecting from a different machine, I'd then try
connecting from that machine to see if there are any network issues that
would prevent the connection.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Raymond,

Thank you very much.  This is exactly what I was looking for.  I'll jump
right into it.

Ray
----- Original Message -----
From: "Raymond O'Donnell" <rod@iol.ie>
To: "ray joseph" <ray@aarden.us>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, February 01, 2010 7:08 AM
Subject: Re: [GENERAL] How to test my new install


> On 01/02/2010 12:21, ray joseph wrote:
> > Raymond,
> >
> > Thank you.  Yes, that sounds like a great step.  I am new to this so I
could
> > use a little help:  What do you mean to connect to it and how would I do
it?
>
> psql is the command-line client for Postgres, which lets you connect to
> databases and run SQL commands directly against them. You can read about
> it here:
>
>   http://www.postgresql.org/docs/8.4/interactive/app-psql.html
>
> On the XP machine, open a command prompt and type....
>
> [path to PG install dir]\bin\pgsql -U [username] [databasename]
>
> ...and see if you can connect to the database. If you can connect and
> run queries, then the DB server is running.
>
> If your app stack is connecting from a different machine, I'd then try
> connecting from that machine to see if there are any network issues that
> would prevent the connection.
>
> Ray.
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod@iol.ie
>

Señores,
 
Saquen me de la lista ya no deceo resibir mas correos.
 
atte.
 
Jose Paredes Odar


 



 
> From: ray@aarden.us
> To: rod@iol.ie
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] How to test my new install
> Date: Mon, 1 Feb 2010 04:48:08 -0600
>
> Raymond,
>
> Thank you for responding to my question. I am sorry that I wasn't clear.
>
> My concern is that when I start up my tool stack and it doesn't work, that I
> will have an entire chain to troubleshoot. If I could isolate each tool as
> I install it, and validate that it is working, it will be easier to assess
> any other difficulties.
>
> Ray
>
> ----- Original Message -----
> From: "Raymond O'Donnell" <rod@iol.ie>
> To: "ray" <ray@aarden.us>
> Cc: <pgsql-general@postgresql.org>
> Sent: Monday, February 01, 2010 3:33 AM
> Subject: Re: [GENERAL] How to test my new install
>
>
> > On 01/02/2010 01:15, ray wrote:
> > > I have just installed 8.4 on an XP. My intent is to use it with Trac
> > > and Apache.
> > >
> > > I would like to validate the installation of pgsql. What would be a
> > > good method to make sure that pgsql is in there right?
> >
> > Not sure what you mean..... I'd imagine the thing to do is to run your
> > application against it in a test setup and check tat everything works as
> > you expect.
> >
> > Ray.
> >
> > --
> > Raymond O'Donnell :: Galway :: Ireland
> > rod@iol.ie
> >
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

---

Elige un juego de Messenger. Reta a un amigo. ¡Pruébalo ya!