• The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Issues PostGres 8.1 Update. Please help.

A

acidbox

Guest
I found the RHEL 3.0 RPMS on the PGSQL site:

http://www.postgresql.org/ftp/binary/v8.1.0/linux/rpms/redhat/rhel-es-3.0/

I installed them and got this:
warning: compat-postgresql-libs-3-2PGDG.i686.rpm: V3 DSA signature: NOKEY, key ID 748f7d0e
Preparing... ########################################### [100%]
1:postgresql-libs ########################################### [ 9%]
2:postgresql ########################################### [ 18%]
3:compat-postgresql-libs ########################################### [ 27%]
4:postgresql-server ########################################### [ 36%]
/sbin/ldconfig: /usr/lib/libpgtypes.so.1 is not a symbolic link

/sbin/ldconfig: /usr/lib/libecpg_compat.so.1 is not a symbolic link

/sbin/ldconfig: /usr/lib/libecpg.so.4 is not a symbolic link

/sbin/ldconfig: /usr/lib/libpq.so.3 is not a symbolic link

5:postgresql-contrib ########################################### [ 45%]
6:postgresql-devel ########################################### [ 55%]
7:postgresql-docs ########################################### [ 64%]
8:postgresql-jdbc ########################################### [ 73%]
9:postgresql-pl ########################################### [ 82%]
/sbin/ldconfig: /usr/lib/libpgtypes.so.1 is not a symbolic link

/sbin/ldconfig: /usr/lib/libecpg_compat.so.1 is not a symbolic link

/sbin/ldconfig: /usr/lib/libecpg.so.4 is not a symbolic link

/sbin/ldconfig: /usr/lib/libpq.so.3 is not a symbolic link

10:postgresql-python ########################################### [ 91%]
11:postgresql-test ########################################### [100%]
/sbin/ldconfig: /usr/lib/libpgtypes.so.1 is not a symbolic link

/sbin/ldconfig: /usr/lib/libecpg_compat.so.1 is not a symbolic link

/sbin/ldconfig: /usr/lib/libecpg.so.4 is not a symbolic link

/sbin/ldconfig: /usr/lib/libpq.so.3 is not a symbolic link

/sbin/ldconfig: /usr/lib/libpgtypes.so.1 is not a symbolic link

/sbin/ldconfig: /usr/lib/libecpg_compat.so.1 is not a symbolic link

/sbin/ldconfig: /usr/lib/libecpg.so.4 is not a symbolic link

/sbin/ldconfig: /usr/lib/libpq.so.3 is not a symbolic link

Now, inside Plesk, it says that PGSQL is not installed and has removed the ability to create PGSQL databases from my control panel.

From root, when i type postgres --version, it returns:

postgres (PostgreSQL) 8.1.0

When I try to run it from the command line I get:

# postgres --version
postgres (PostgreSQL) 8.1.0

#postgres
postgres does not know where to find the server configuration file.
You must specify the --config-file or -D invocation option or set the PGDATA environment variable.

So basically, I'm not sure if the server is running correctly and just not connected to the plesk interface anymore, or if the install is broken altogether.

One thought. From the control panel, i can run the Plesk updater and it gives me the option to install "PosgreSQL server support". Is this just the interface from Plesk into PGSQL? If so, do you think if I re-install this from the control panel it will plug itself back in?

If anyone can help me on this issue, i'd appreciate it. pgsql is out of commision.
 
Back
Top