ERROR: could not access file "$libdir/xxid": No such file or directory

I installed PostgreSQL 8.4 using one-click-installer then installed SlonyI using stack builder. All went fine, no errors in the installation.

The problem is whenever I create a new cluster in pgAdminIII, I will get the ff. error:
"ERROR: could not access file "$libdir/xxid": No such file or directory"

What can be cause of it? Tried everything I could but nothing helps.
I'm using Windows Vista.

Thanks!
cyberjorge

Hello,

It is strange to have this error as xxid has became osbolete in Slony-I. As you mentioned you installed 8.4 and installed Slony though Stackbuilder. So your slony version should be 2.0.2.
If you have the above said versions. Then the error should not be the one you have mentioned.

Kindly see in your pg_home/share/postgresql/ directory do you have any xxid.sql files are there? In a new clean installation they should not be there.

Nonetheless, you wont be able to create cluster as pgAdmin hasnt been upgraded to incorporate slony changes (removal of xxid scripts).

Sachin_S,

Thanks for your response.
Yes, I did a clean installed of PostgreSQL and Slony from stackbuilder though I have previous installation of 8.3 with working Slony that I uninstalled prior to installing 8.4 then deleted all remaining files.

As per checking the directory there is xxid.sql files inside /share/Slony folder. v74, v80 and v81

In this case what is the best I can do to make sure I'm using the latest Slony version given that I've installed it already using Stack Builder?

Thanks a lot!
cyberjorge

Since you have xxid files in the share/postgresql directory which means you dont have the latest slony.
You can uninstall the slony using the uninstaller. and then install again through stackbuilder. (The Slony version should be 2.0.2-1 ). In case your Stackbuilder reports any other version. Please reply back with your platform name. and the installer name (one-click installer name) and from where you have downloaded the installer.

We are working to make pgAdmin to work with latest Slony-I.

There's no Slony-I uninstaller entry in my Add/Remove nor an uninstaller script in the installation directory so what I did is uninstall entire Postgres 8.4, restart, delete remaining files and folders (mostly Slony-I files) then reinstall Postgres 8.4

After installation I launched Stack Builder and it says Slony-I is "(installed)" and yes the installer reports version 2.0.2-1 and I continued with the installation. Now when I went back to the installation directory under... C:\Program Files\PostgreSQL\8.4\share\Slony\ there are xxid.sql files there again and I encounter the same "$libdir/xxid" error when I create a new cluster. What else I can I do to fix this? How do I uninstall Slony-I completely?

Windows Vista Ultimate SP1
postgresql-8.4.0-1-windows.exe (one-click installer)
Slony-I 2.0.2-1
http://www.enterprisedb.com/products/pgdownload.do#windows

Thank you for supporting, extending and improving PostgreSQL.

Hello,

Ok So removing Slony files dint removed any registry entries. Kindly delete this registry entry:

HKEY_LOCAL_MACHINE\SOFTWARE\EnterpriseDB\Slony_I_PG83 or HKEY_LOCAL_MACHINE\SOFTWARE\EnterpriseDB\Slony_I_PG84

If possible, and make sure you have a clean PG Installation also. (i,e it dont have xxid files in share\postgresql directory).

This message was edited 1 time. Last update was at 3 Sep 2009 05:10:07

Thanks again for your response!

I did your suggestion, even uninstalled PostgreSQL and made a clean installation and no longer encounter the error. Instead I get a new one that shows below the New Replication dialog box that says:

"Slony-I creation script no available; only join possible"

I tried reinstalling again but didn't help, I checked File --> Options.. in pgAdmin and set the Slony I-path to: C:\Program Files\PostgreSQL\8.4\share.
I even setup an Ubuntu 8.10 fresh VM install to test it, but the still says creation scripts not available.

Hello,

That is something i expect as pgAdmin is not updated to the latest slony versions. I am in a process of doing that will update you shortly on it once done.

Sachin_S,

Thanks for letting me know, looking forward to that!

Also please note that in my recent installation, Slony-I installer from Stack Builder no longer creates xxid files inside share folder in windows but still create those xxid files in Ubuntu under:

/opt/PostgreSQL/8.4/share/Slony/

Best Regards!
cyberjorge

Hi Sachin_S,

Any progress with the Slony I for pgAdmin so far?

Thanks!
cyberjorge

Hello,

I have already submitted a patch to the community, It's in the reviewing process. If committed, you probably will get to see that in the next pgAdmin release.

If you want my working copy, please let me know.

Thanks for working on this!

Will be glad to have a copy, please send to my email posted as my nickname (w/c i can't change).

Thanks in advance!