Обсуждение: pg_restore and the use of encryption

This seems very strange.  Are you sure those binaries are all from the
same release.  Is your pg_hba.conf a cause? I know of now special
connection requirements for pg_restore.

---------------------------------------------------------------------------

Chris White wrote:
> I am trying to run pg_restore and it tells me it needs libssl, libcrypto,
> libkrb5 etc. Why does pg_restore need these libraries when neither pg_dump
> or postmaster require these libraries to run. Why is pg_restore requesting
> encryption libraries and what are they used for?
>
> Thanks
> Chris White

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> This seems very strange.  Are you sure those binaries are all from the
> same release.

I don't think they could be.  Our build procedure computes just one LIBS
list and uses it for all executables, so in ordinary circumstances all
the executables will have the same set of shared-library dependencies.
Certainiy pg_dump and pg_restore will, if they were built at the same
time.

            regards, tom lane

You are correct someone had rebuilt pg_dump, psql and postmaster without
encryption, but forgot to do pg_restore as they thought we would only be
using psql for restoring databases. Sorry about that.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Sunday, February 02, 2003 9:39 AM
To: Bruce Momjian
Cc: cjwhite@cisco.com; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_restore and the use of encryption


Bruce Momjian <pgman@candle.pha.pa.us> writes:
> This seems very strange.  Are you sure those binaries are all from the
> same release.

I don't think they could be.  Our build procedure computes just one LIBS
list and uses it for all executables, so in ordinary circumstances all
the executables will have the same set of shared-library dependencies.
Certainiy pg_dump and pg_restore will, if they were built at the same
time.

            regards, tom lane