Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: gerald001 on May 16, 2005, 05:52:42 PM

Title: [Announce] Postgresql-8.0.3-xyz.rpm
Post by: gerald001 on May 16, 2005, 05:52:42 PM

to the community,
just finished the build of Postgresql version 8.0.3 rpms. I would appreciate for comments as I suppose there will be some minor typos to be able to correct them. Tested on SME Server 6.5RC1 suppposing it will work on SME 6.0.1 as well.

There is a a small howto available for PostgresQL Version 8.0.3 at
 http://schwarzecker.homelinux.net/index.php in the FAQ section with regards to the contributions of Van hees Michel available at http://www.vanhees.cc
 
and the files reside in the download section category postgresql of http://schwarzecker.homelinux.net/index.php
enjoy every day of life and have fun
Gerald

PS: be aware when upgrading from previous version of postgres you should dump the content of the postgres database first and then load into the newly installed version !

Title: [Announce] Postgresql-8.0.3-xyz.rpm
Post by: dlalleme on May 19, 2005, 05:19:17 PM

Hello,

  It is not possible to download the files via your web site !!!
  How to do that or where is the problem ?

regards
Denis

Title: [Announce] Postgresql-8.0.3-xyz.rpm
Post by: gerald001 on May 19, 2005, 08:57:15 PM

Quote from: "dlalleme"

Hello,

  It is not possible to download the files via your web site !!!
  How to do that or where is the problem ?

regards
Denis

High Denis.
 thanks a lot for your remark, I did not notcie my mistake and it should work right now.
regards Gerald

Title: [Announce] Postgresql-8.0.3-xyz.rpm
Post by: albatroz on June 09, 2005, 05:30:52 PM

Has anybody tried this?
I plan to test it during weekend, I will let you know, my results....

Title: [Announce] Postgresql-8.0.3-xyz.rpm
Post by: irian on February 06, 2006, 09:21:57 AM

I just tried this.
I get an error trying to connect to the database when I enter:

Code: [Select]

psql postgrestest -h 192.168.7.8 -U pgtest
The reply is:

Code: [Select]

psql: could not connect to server: Connection refused
Is the server running on host 192.168.7.8 and accepting TCP/IP connetions on port 5432?

I checked the ports:

Code: [Select]

netstat -atpn
it tells me:

Code: [Select]

tcp  127.0.0.1:5432 LISTEN 3713/postmaster
Which means that it is running.

Can someone tell me what I should do to get this working?
Also when I reboot the server it telles me it FAILED starting Postgresql.