Help!

ElayaRaja S wrote:

Hi,
While configuring OpenCRX by using Postgresql i am facing probmelm.
The problem while creating db using the command ( createdb -h
localhost -E utf8 -U system crx-CRX ) .
Erro:
createdb: could not connect to database template1: could not connect
to server:
Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

This isn't really the right list - I'll repost onto the General list for
you now. Please join me there, and don't reply to this message.

--
Richard Huxton
Archonet Ltd

ElayaRaja S wrote:

Hi,
While configuring OpenCRX by using Postgresql i am facing probmelm.
The problem while creating db using the command ( createdb -h
localhost -E utf8 -U system crx-CRX ) .
Erro:
createdb: could not connect to database template1: could not connect
to server:
Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

OK - it's saying it can't connect and asks you whether the server is
running and accepting connections on localhost:5432.
Is it?
What does "service postgresql status" say?
Have you checked your pg_hba.conf settings?

Details of Platfor that i am using:
1) Linux 9

No such thing. Do you mean RedHat 9?

2) Postgre SQL 7.4.5
Note: I have doubt whether the error is due to my existing Postgresql
7.3. Means while installing linux there is built in postgresql 7.3.
But i am installed postgresql 7.4.5. Plz let me know its very urgent.

How did you install 7.4.5? How was 7.3 Installed? What errors did you see?

There are RPMs available for RedHat 9 (if that's what you're running) -
look in the "binary" folder on the download page. They should install
without problem, just remove 7.3 before.

--
Richard Huxton
Archonet Ltd

ElayaRaja S wrote:

Hi,
Thanks for your reply. Sorry to contact again to this mail. I am
unable to find the link for general list. Please let me know.

That's fine - I'm cc-ing you to the general list so others can help too.
You can find all the lists at http://www.postgresql.org/lists.html - you
can subscribe with a web-form too if you would like.

And i
have answered for your question as follows.
How did you install 7.4.5? How was 7.3 Installed? What errors did you see?
Actually 7.3 is builtin with Red hot Linux 9. But i have installed
with my folder usr/local/pgsql/

OK - download the RPM distribution for PostgreSQL version 7.4.6. You can
get this from the download page on the main website. Choose a local
mirror, then check in the binary folder for Red Hat rpms. There are some
for Red Hat 9 (in the UK mirror definitely, I just checked).

As root, backup any existing databases using pg_dump. Backup the .conf
files in /var/lib/pgsql/data/.
Stop postgresql 7.3 with "service postgresql stop".
Upgrade your postgresql installation with "rpm -Uvh postgres*rpm" in the
same directory as your new rpm files.
Edit your configuration files.
If all works, start postgresql 7.4 with "service postgresql start"
Check with "service postgresql status"

--
Richard Huxton
Archonet Ltd