> ps shows postgresql running:
> /usr/bin/pg_ctl -D /var/lib/pgsql/data -p /usr/bin/postmaster start
> /usr/bin/postmaster -i
> I can poke a hole in my firewall and let you connect to the database if you
> would like troubleshoot my sytem. But I'll need some help setting up
> permissions to allow external connections. Let me know and I'll send my IP
> address to your private email.
I won't have time to do this in the next few weeks, since I'll be
traveling most of the time. You might find another volunteer from this
list, but if not I would suggest the following steps:
1) send us your default rpm compiler and build options. Use
rpm --showrc > tempfiletomail.txt gcc --version >>&! tempfiletomail.txt
2) try building postgresql from sources. See if the problem persists (it
won't).
3) try building the postgresql rpm from sources. The steps are
a) rpm -ivv postgresql-xxx.src.rpmb) cd /usr/src/RPM/SPEC (for Mandrake, RedHat uses /usr/src/RedHat...)c) rpm -ba
postgresql.spec(verify the spec file name)d) cd /usr/src/RPM/RPMS/ixxxe) rpm -Uvh --force postgresql*.ixxx.rpm
I'm doing these steps from memory, and you had better save your database
contents somewhere just in case it gets trashed ;)
> Also, let me know what particular build problems might cause this, and I'll
> post to Trustix mail list.
Not sure, since I've never seen this before for this data type :(
- Thomas