[ADMIN] Connect to a server with SSL encrypted connection?

Hello! I'm writting to get some clues about PostgreSQL administration, and more precisely SSL connection from one server to another with certificate identification. I must underline than I'm new to postgreSQL and server administration. Here is the story: My main server has an IP

Re: [ADMIN] Data problem - error invalid attribute number # for tablename

Some poking through the source code finds only one match for that error message, which is in relcache.c. It looks like you have a row in pg_attribute that claims to belong to that relation, but has attnum 32533. It would be interesting to see the results for select * from pg_attribute

[ADMIN] Data problem - error invalid attribute number # for tablename

We've received a client's database which was giving errors and refusing to be backed up; at this point we do not know what's happened to the database to corrupt it (likely a hardware or power failure, etc.) The error that is being given when trying to do selects on the affected table or doing

[ADMIN] language plpgsql does not exist

Hi everybody. I'm a new born in the PostGreSQL domain (usually deal with Oracle or SQL Server) and I got the following error when trying to create a function using the default language plpgsql: language plpgsql does not exist I was not able to find clues on the net to help me to solve this

Re: [ADMIN] language plpgsql does not exist

Hum, I feel sorry to have disturbed you with such beginner's question. I just found out the solution: should create the language entry myself. Next time I hope to have a more interesting question :-) Seb. -- Sébastien BAUDRY - DBA Oracle/MS-SQL Project Manager BAUDRY ENGINEERING BT. H-1025