Thread: basic log question
Hi,
Could anyone please let me know how can I view the pgsql log?
A week back everything was ok but today I open my db and see many data deleted.
Can I view when this happened?
Thanks,
AK
Could anyone please let me know how can I view the pgsql log?
A week back everything was ok but today I open my db and see many data deleted.
Can I view when this happened?
Thanks,
AK
Angshu Kar wrote: > Hi, > > Could anyone please let me know how can I view the pgsql log? > A week back everything was ok but today I open my db and see many data > deleted. > Can I view when this happened? If logging is enabled, then sure. You'll need to check the postgresql.conf file to see where the logs point to (your host/system admin may need to help you out). -- Postgresql & php tutorials http://www.designmagick.com/
Thanks Chris. I;ll try that tomorrow
--
I will live forever or die trying...
On 7/5/06, Chris <dmagick@gmail.com> wrote:
Angshu Kar wrote:
> Hi,
>
> Could anyone please let me know how can I view the pgsql log?
> A week back everything was ok but today I open my db and see many data
> deleted.
> Can I view when this happened?
If logging is enabled, then sure.
You'll need to check the postgresql.conf file to see where the logs
point to (your host/system admin may need to help you out).
--
Postgresql & php tutorials
http://www.designmagick.com/
--
I will live forever or die trying...