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

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 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

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?

Señores,

Saquen me de la lista ya no deceo resibir mas correos.

atte.

Jose Paredes Odar

Jòse

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

_________________________________________________________________
¿Aún no sabes qué móvil eres? ¡Descúbrelo aquí!
http://www.quemovileres.com/