[ADMIN] problems installing postgresql 7.4.2-1

Hi all, I am trying to upgrade from version 7.1.3-2 to 7.4.2-1. I have uninstalled the previous version. I am using RedHat Linux 8.0 when i run the command $rpm -ivh postgresql-libs-7.4.2-1.i386.rpm warining: postgresql-libs-7.4.2-1.i386.rmp: V3 DSA signature: NOKEY, key ID 30c9ecf8 error: Fai

Re: [ADMIN] problems installing postgresql 7.4.2-1

On Sat, 2004-07-10 at 01:01, Pradeepkumar, Pyatalo (IE10) wrote: > Hi all, > > I am trying to upgrade from version 7.1.3-2 to 7.4.2-1. > I have uninstalled the previous version. I am using RedHat Linux 8.0 > > when i run the command > > $rpm -ivh postgresql-libs-7.4.2-1.i386.rpm > warining: pos

Re: [ADMIN] problems installing postgresql 7.4.2-1

"Scott Marlowe" <[EMAIL PROTECTED]> writes: > On Sat, 2004-07-10 at 01:01, Pradeepkumar, Pyatalo (IE10) wrote: >> $rpm -ivh postgresql-libs-7.4.2-1.i386.rpm >> warining: postgresql-libs-7.4.2-1.i386.rmp: V3 DSA signature: NOKEY, key ID >> 30c9ecf8 >> error: Failed dependencies: >> libcrypto.so.4 i

Re: Asunto: Re: [ADMIN] Problems restoring a DB with oids

Was there ever a resolution to this? --- Tom Lane wrote: > [EMAIL PROTECTED] writes: > > Here is the solution to the problem: > > First: We have to restore (only) the structure (schema) of the database > > pg_restore -Ft -v