Thread: Loosing all data in customer machine

Loosing all data in customer machine

From
Ricardo Oliveira
Date:
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

Re: Loosing all data in customer machine

From
"Day, David"
Date:

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@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Ricardo Oliveira
Sent: Monday, October 20, 2014 2:41 PM
To: pgsql-novice@postgresql.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

Re: Loosing all data in customer machine

From
Ricardo Oliveira
Date:
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@redcom.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@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Ricardo Oliveira
Sent: Monday, October 20, 2014 2:41 PM
To: pgsql-novice@postgresql.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