Обсуждение: 8.03 postgres install error

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Wed, 15 Jun 2005, Prasad Duggineni wrote:

> I am getting the following error when i try to install the postgres 8.03 . It seems to be problem with the installing
postgreslibs. Plesae advice me to fix this problem. 
>
> warning: postgresql-libs-8.0.3-1PGDG.i686.rpm: V3 DSA signature: NOKEY, key ID 748f7d0e
> error: Failed dependencies:
>        libecpg.so.4 is needed by postgresql-libs-8.0.3-1PGDG
>        libpgtypes.so.1 is needed by postgresql-libs-8.0.3-1PGDG
>        libpq.so.3 is needed by postgresql-libs-8.0.3-1PGDG
>    Suggested resolutions:
>        postgresql-libs-7.3.2-3.i386.rpm

http://developer.PostgreSQL.org/~devrim/compat-postgresql-libs-3-3PGDG.i686.rpm

is the RPM you need.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com.tr                      http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFCsEUotl86P3SPfQ4RAtbeAJ9zMDpaLNpKUDkezoisLiEKUdCNoQCgrZ0s
rIfdpnpG5tBjg5gUu85MoiI=
=AvjU
-----END PGP SIGNATURE-----

I did install successully postgres 8.03  but I am getting the following
error message in the syslog eventhough /var/pgsql/data is pointing to new
configuration file which is postgres 8.03.
"ksqo" is configuration parameter for the postgres 7.4
Please advice me to fix this problem.

Jun 20 18:38:41 lab5md9181 postgres[2552]: [2-1] 2005-06-20 18:38:41 EDT
ERROR:
 unrecognized configuration parameter "ksqo"
Jun 20 18:38:41 lab5md9181 postgres[2553]: [2-1] 2005-06-20 18:38:41 EDT
ERROR:
 unrecognized configuration parameter "ksqo"
Jun 20 18:38:41 lab5md9181 postgres[2554]: [2-1] 2005-06-20 18:38:41 EDT
ERROR:
 unrecognized configuration parameter "ksqo"

Thanks
Prasad

----- Original Message -----
From: "Devrim GUNDUZ" <devrim@gunduz.org>
To: "Prasad Duggineni" <pduggineni@prominencenet.com>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, June 15, 2005 11:11 AM
Subject: Re: [GENERAL] 8.03 postgres install error


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Hi,
>
> On Wed, 15 Jun 2005, Prasad Duggineni wrote:
>
>> I am getting the following error when i try to install the postgres 8.03
>> . It seems to be problem with the installing postgres libs. Plesae advice
>> me to fix this problem.
>>
>> warning: postgresql-libs-8.0.3-1PGDG.i686.rpm: V3 DSA signature: NOKEY,
>> key ID 748f7d0e
>> error: Failed dependencies:
>>        libecpg.so.4 is needed by postgresql-libs-8.0.3-1PGDG
>>        libpgtypes.so.1 is needed by postgresql-libs-8.0.3-1PGDG
>>        libpq.so.3 is needed by postgresql-libs-8.0.3-1PGDG
>>    Suggested resolutions:
>>        postgresql-libs-7.3.2-3.i386.rpm
>
> http://developer.PostgreSQL.org/~devrim/compat-postgresql-libs-3-3PGDG.i686.rpm
>
> is the RPM you need.
>
> Regards,
> - --
> Devrim GUNDUZ
> devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.tdmsoft.com.tr                      http://www.gunduz.org
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (GNU/Linux)
>
> iD8DBQFCsEUotl86P3SPfQ4RAtbeAJ9zMDpaLNpKUDkezoisLiEKUdCNoQCgrZ0s
> rIfdpnpG5tBjg5gUu85MoiI=
> =AvjU
> -----END PGP SIGNATURE-----
>
>

"Prasad Duggineni" <pduggineni@prominencenet.com> writes:
> Please advice me to fix this problem.

> Jun 20 18:38:41 lab5md9181 postgres[2552]: [2-1] 2005-06-20 18:38:41 EDT
> ERROR:
>  unrecognized configuration parameter "ksqo"

KSQO has been obsolete for nigh five years now.  Update whatever
software you are using that expects it to do something.

            regards, tom lane

On Tue, Jun 21, 2005 at 10:01:00AM -0400, Prasad Duggineni wrote:
> I did install successully postgres 8.03  but I am getting the following
> error message in the syslog eventhough /var/pgsql/data is pointing to new
> configuration file which is postgres 8.03.
> "ksqo" is configuration parameter for the postgres 7.4
> Please advice me to fix this problem.

Get rid of the ksqo parameter in the config file.  Also I'd advise you
to get a whole new file, since other things have changed as well.

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Crear es tan difícil como ser libre" (Elsa Triolet)

I have updated the software still it is occurring whenever I  reboot my
computer. I don't have any references to old config file.Please advice me to
fix this problem.
Here is the syslog.


Jun 22 10:16:30 lab5md9181 gpm: gpm startup succeeded
Jun 22 10:16:31 lab5md9181 postgres[887]: [2-1] 2005-06-22 10:16:31 EDT LOG:
st
atement:
Jun 22 10:16:31 lab5md9181 postgres[887]: [3-1] 2005-06-22 10:16:31 EDT LOG:
st
atement: set DateStyle to 'ISO'
Jun 22 10:16:32 lab5md9181 postgres[887]: [4-1] 2005-06-22 10:16:32 EDT LOG:
st
atement:
Jun 22 10:16:32 lab5md9181 postgres[887]: [5-1] 2005-06-22 10:16:32 EDT LOG:
st
atement: set geqo to 'OFF'
Jun 22 10:16:32 lab5md9181 postgres[887]: [6-1] 2005-06-22 10:16:32 EDT LOG:
st
atement:
Jun 22 10:16:32 lab5md9181 postgres[887]: [7-1] 2005-06-22 10:16:32 EDT LOG:
st
atement: set ksqo to 'ON'
Jun 22 10:16:32 lab5md9181 postgres[887]: [8-1] 2005-06-22 10:16:32 EDT
ERROR:
unrecognized configuration parameter "ksqo"
Jun 22 10:16:32 lab5md9181 postgres[887]: [9-1] 2005-06-22 10:16:32 EDT LOG:
st
atement: select oid from pg_type where typname='lo'
Jun 22 10:16:32 lab5md9181 postgres[887]: [10-1] 2005-06-22 10:16:32 EDT
LOG:  s
tatement: select version()
Jun 22 10:16:32 lab5md9181 postgres[891]: [2-1] 2005-06-22 10:16:32 EDT LOG:
st
atement:
Jun 22 10:16:32 lab5md9181 postgres[891]: [3-1] 2005-06-22 10:16:32 EDT LOG:
st
atement: set DateStyle to 'ISO'
Jun 22 10:16:32 lab5md9181 postgres[891]: [4-1] 2005-06-22 10:16:32 EDT LOG:
st
atement:
Jun 22 10:16:32 lab5md9181 postgres[891]: [5-1] 2005-06-22 10:16:32 EDT LOG:
st
atement: set geqo to 'OFF'
Jun 22 10:16:32 lab5md9181 postgres[891]: [6-1] 2005-06-22 10:16:32 EDT LOG:
st
atement:
Jun 22 10:16:32 lab5md9181 postgres[891]: [7-1] 2005-06-22 10:16:32 EDT LOG:
st
atement: set ksqo to 'ON'
Jun 22 10:16:32 lab5md9181 postgres[891]: [8-1] 2005-06-22 10:16:32 EDT
ERROR:
unrecognized configuration parameter "ksqo"
Jun 22 10:16:32 lab5md9181 postgres[891]: [9-1] 2005-06-22 10:16:32 EDT LOG:
st
atement: select oid from pg_type where typname='lo'

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Prasad Duggineni" <pduggineni@prominencenet.com>
Cc: <pgsql-general@postgresql.org>; "Devrim GUNDUZ" <devrim@gunduz.org>
Sent: Tuesday, June 21, 2005 10:23 AM
Subject: Re: [GENERAL] 8.03 postgres install error


> "Prasad Duggineni" <pduggineni@prominencenet.com> writes:
>> Please advice me to fix this problem.
>
>> Jun 20 18:38:41 lab5md9181 postgres[2552]: [2-1] 2005-06-20 18:38:41 EDT
>> ERROR:
>>  unrecognized configuration parameter "ksqo"
>
> KSQO has been obsolete for nigh five years now.  Update whatever
> software you are using that expects it to do something.
>
> regards, tom lane
>
>

Hi,

On Wed, 22 Jun 2005, Prasad Duggineni wrote:

> I have updated the software still it is occurring whenever I  reboot my
> computer. I don't have any references to old config file.Please advice me to
> fix this problem.

Hrrm... Did you use rpm -Uvh while upgrading? I hope you did not...

--
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com.tr                      http://www.gunduz.org

Yep I have used the rpms while upgrading the postgres 8.0.


----- Original Message -----
From: "Devrim GUNDUZ" <devrim@gunduz.org>
To: "Prasad Duggineni" <pduggineni@prominencenet.com>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>; <pgsql-general@postgresql.org>; "Devrim
GUNDUZ" <devrim@gunduz.org>
Sent: Wednesday, June 22, 2005 11:06 AM
Subject: Re: [GENERAL] 8.03 postgres install error


>
> Hi,
>
> On Wed, 22 Jun 2005, Prasad Duggineni wrote:
>
>> I have updated the software still it is occurring whenever I  reboot my
>> computer. I don't have any references to old config file.Please advice me
>> to fix this problem.
>
> Hrrm... Did you use rpm -Uvh while upgrading? I hope you did not...
>
> --
> Devrim GUNDUZ
> devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.tdmsoft.com.tr                      http://www.gunduz.org
>
>