• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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