• Debian 11 is approaching its end-of-life (vendor EOL date - August 31, 2026). Plesk Obsidian 18.0.80 will be the last release to support it.
    If you are running Plesk Obsidian on Debian 11, we recommend you upgrade those servers to Debian 12 using our dist-upgrade tool.
  • We plan to deprecate and remove the support for XML RPC protocol versions earlier than 1.6.9.1 in Plesk Obsidian 18.0.82. We strongly recommend that you update all existing integrations using earlier versions of the XML RPC protocol to comply with the version 1.6.9.1 specification.

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