Search Postgresql Archives

Re: urgent request : PSQLException: FATAL: could not open relation XXX: No such file or directory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I copied back to list as your chances of getting an answer are greater.

On Sunday 01 February 2009 10:15:04 pm you wrote:
> The Postgres version is PostgreSQL version 8.3.4.
> OS type - Windows XP Proffesional Version 2002
> Our application is a client server Java application which collects data
> from the db and send to Platform to be shown to the user.
> Only our application is touching Postgresdb.
>
> The application was running smoothly.. But at some point of time the
> db(postgres service) stopped and Platform stopped receiving data from db.
> While checking on the problem we found this exception in the server logs.
>
>
>
> Warm regards,
> Preethi K Valsalan, Team Lead
> Sphere Networks FZCo. P.O.Box 341010, Dubai UAE
> Tel: (+9714) 501-5863   Fax: (+9714) 501-5872
> preethi.valsalan@xxxxxxxxx
> www.sphere.ae
>
>

Some more questions:
Was does Postgres logging show about the shutdown?
What does the XP logging show?
Files in the data folder map to objects in the database, is it possible some 
code in the application deleted objects?
Is there a Anti-Virus program running on this machine?
Do you know which files disappeared?

As to recovery, do you have a backup?



-- 
Adrian Klaver
aklaver@xxxxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux