<div>
<blockquote>
Is it possible to recover table data in postgresql ?
</blockquote>
if data was backup, then you can restore it back, else it could mean your data is lost.<br />
<br />

<blockquote>
what approaches do you suggest to resolve this or to avoid such things to happen or some alternative plan.
</blockquote>
<b>always make a backup</b>. you may also set <b>read only privilege</b> for certain test users to avoid the risk of data lost.
</div>


> Is it possible to recover table data in postgresql ?

if data was backup, then you can restore it back, else it could mean your data is lost.



> what approaches do you suggest to resolve this or to avoid such things to happen or some alternative plan.

always make a backup. you may also set read only privilege for certain test users to avoid the risk of data lost.

Fractional CTO

David Favor

Rohit Bajaj

<div>
Best to take ste5an's advice.<br />
<br />
Build a test data generator... because... there's no real reason to backup a staging/dev database repeatedly, when the data will always be the same.<br />
<br />
Also, anytime you must spin up another staging/dev environment, having a test data generator will likely simplify your spin up process.
</div>


Best to take ste5an's advice.

Build a test data generator... because... there's no real reason to backup a staging/dev database repeatedly, when the data will always be the same.

Also, anytime you must spin up another staging/dev environment, having a test data generator will likely simplify your spin up process.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I accidentally truncated a table in postgresql on staging environment. It had lot of data.<br />
I needed it for testing. Although a small amount of data would also suffice.<br />
But the online portal which generates the data is also down.<br />
So i am kind of stuck.<br />
how do i test. what approaches do you suggest to resolve this or to avoid such things to happen or some alternative plan.<br />
Is it possible to recover table data in postgresql ?<br />
<br />
Thanks
</div>
</div>


Hi,
I accidentally truncated a table in postgresql on staging environment. It had lot of data.
I needed it for testing. Although a small amount of data would also suffice.
But the online portal which generates the data is also down.
So i am kind of stuck.
how do i test. what approaches do you suggest to resolve this or to avoid such things to happen or some alternative plan.
Is it possible to recover table data in postgresql ?

Thanks

Deletion of table accidently

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.

PostgreSQL

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.