Re: Loosing all data in customer machine

Hi David,

Thank you for your response.
According to the customer the machine was not rebooted but your response
seems consistent with the behavior I was able to observe.
Thank you very much for your help.

*Ricardo Oliveira*

2014-10-20 19:51 GMT+01:00 Day, David <dday(at)redcom(dot)com>:

> Data/content in tables created with the “unlogged” attribute will only
> persist till the point in time
>
> The postgres server is restarted. i.e. does the data disappear upon
> restarting postgres ?
>
>
>
>
>
> *From:* pgsql-novice-owner(at)postgresql(dot)org [mailto:
> pgsql-novice-owner(at)postgresql(dot)org] *On Behalf Of *Ricardo Oliveira
> *Sent:* Monday, October 20, 2014 2:41 PM
> *To:* pgsql-novice(at)postgresql(dot)org
> *Subject:* [NOVICE] Loosing all data in customer machine
>
>
>
> Hi,
>
>
>
> I'm facing a very strange problem using Postgre.
>
> I have Postgre v9.3.5 installed on a customer machine (WinXP SP3 2GB RAM).
>
> This instance of Postgre has one database with 4 schemas (public +3), each
> schema has several "simple" tables (table with primary key and a sequence).
>
> Postgre was installed without any additional configuration except to allow
> external IP's to connect.
>
>
>
> It seems that randomly the database looses all data.
>
> All the tables are present with the correct structure but the data simply
> vanishes.
>
> I don't think it is a bug in the software because each application only
> works with a schema and the data is erased from all schemas.
>
> Also, I don't think that it is the database's fault because I have one
> instance of Postgre here at the office and the data was never lost.
>
> No other connections are made to the database besides my software and
> pgAdmin (usually to backup the data).
>
>
>
> Can anyone give me some ideas and hints on were to look for problems?
>
> I'm I doing something wrong?
>
> I know this is probably not a very common problem so there must be
> something obvious that I'm missing.
>
>
>
> I don't know if this helps but my software is developed in Delphi XE5
> using FireDac to access the database.
>
>
>
> Thanks in advance,
>
>
>
> *Ricardo Oliveira*
>