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:
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:
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.
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%]
1ostgresql-libs ########################################### [ 9%]
2ostgresql ########################################### [ 18%]
3:compat-postgresql-libs ########################################### [ 27%]
4ostgresql-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
5ostgresql-contrib ########################################### [ 45%]
6ostgresql-devel ########################################### [ 55%]
7ostgresql-docs ########################################### [ 64%]
8ostgresql-jdbc ########################################### [ 73%]
9ostgresql-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
10ostgresql-python ########################################### [ 91%]
11ostgresql-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.