Обсуждение: dll files missing in postgrsql bin folder in Windows

On 14 Oct 2011, at 12:25, Kalai R wrote:

> Hi,
>
> I am facing this strange problem where my postgres service couldn't start because of some missing dll files in
installationdirectory's bin folder. 
> I copied files from other machine and it start working again. After some time the same problem appeared again on
systemreboot. 
> I have no idea what causes these files to be deleted automatically. Please help if anyone has faced this kind of
situation.
>
> I' m using version 9.0 on Windows 7


Probably the same issue as in "[GENERAL] Tablespace files deleted during continuous run", or at least very similar in
nature.

* Check that you don't have anti-virus software that (correctly or incorrectly) identified those dll's as infected with
avirus and removed them. 
* Check that your file-system is undamaged.
* Check that windows hasn't been restoring a checkpoint with those dll's not installed.

If the database wasn't installed on a local file-system, check that the remote file-system is functioning properly and
doesn'tcache an old state or something similarly silly. 

Postgres doesn't remove any dll's, so it's some external factor at play here.

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.

Kalai R wrote:
> I am facing this strange problem where my postgres service couldn't
start because of some missing dll
> files in installation directory's bin folder.
> I copied files from other machine and it start working again. After
some time the same problem
> appeared again on system reboot.
> I have no idea what causes these files to be deleted automatically.
Please help if anyone has faced
> this kind of situation.
>
> I' m using version 9.0 on Windows 7

The obvious suspect is antivirus software. If you are running any, turn
it off.

Yours,
Laurenz Albe

On 10/14/11 4:59 PM, Kalai R wrote:
> I find out the problem.
> Windows has been restoring a checkpoint with those dll's not installed.
> I don't know how to inatall dll.
> Please help me to install those dll's in windows.

how to install *what* DLL's ?



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

John R Pierce wrote:
> how to install *what* DLL's ?

This is probably part of the problem - if some files are gone it's
sometimes hard to find out which ones ;-)

So let's see for my 64-bit installation...

PS C:\Users\Brar> & "C:\Program Files\PostgreSQL\9.0\bin\pg_config.exe"
| where { $_ -match "version"}
get-childitem "C:\Program Files\PostgreSQL\9.0\bin" | sort extension,
name | format-table name -GroupBy extension

VERSION = PostgreSQL 9.0.5


    Extension: .dll

Name
----
libeay32.dll
libiconv.dll
libintl.dll
libpq.dll
libxml2.dll
libxslt.dll
msvcr71.dll
ssleay32.dll
zlib1.dll


    Extension: .exe

Name
----
clusterdb.exe
createdb.exe
createlang.exe
createuser.exe
dropdb.exe
droplang.exe
dropuser.exe
ecpg.exe
initdb.exe
oid2name.exe
pg_archivecleanup.exe
pg_config.exe
pg_controldata.exe
pg_ctl.exe
pg_dump.exe
pg_dumpall.exe
pg_regress.exe
pg_regress_ecpg.exe
pg_resetxlog.exe
pg_restore.exe
pg_standby.exe
pg_upgrade.exe
pgAdmin3.exe
pgbench.exe
postgres.exe
psql.exe
reindexdb.exe
stackbuilder.exe
vacuumdb.exe
vacuumlo.exe
zic.exe

Kalai R wrote:
> Windows has been restoring a checkpoint with those dll's not installed.
> I don't know how to inatall dll.
> Please help me to install those dll's in windows.
Personally I wouldn't bother reinstalling single dll files (how do you
know that there are no other files that you will miss at some point) but
reinstall postgresql.

if there are good reasons not to do so you could probably download the
postgresql binary distribution that *exactly matches your existing one
(bitness and minor version)* as zip file from
http://www.enterprisedb.com/products/pgbindownload.do and get the
missing files from the zip archive.

Regards,

Brar

On 10 November 2011 08:56, Kalai R <softlinne.kv@gmail.com> wrote:
> please suggest, what are the configurations should I do in postgres to avoid
> these problem.
> Thank You

None, it's not a Postgres problem. Most likely it is a problem with
your Windows installation.
You have files disappearing, something is doing that and it's not
Postgres. Fix that and then reinstall Postgres and everything should
be fine.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.