[ADMIN] Get data back after drop Command

2011-08-28 Thread Adarsh Sharma
Dear all, Today by mistake I issued a drop table statement in Postgresql database. Now is it possible to get that data back through WAL. My PostgresPLus Version : 8.4 OS : Linux ( CentOs ) My postgresql.conf parameters are : # WRITE AHEAD LOG #---

Re: [ADMIN] What is postgresql status? I'm not sure

2011-08-28 Thread Craig Ringer
On 25/08/2011 2:09 AM, Mcleod, John wrote: Hello all, Don't shoot me, I'm just the fella sweeping up after a departure. I'm supporting a web site with mapping features using Mapserver and PostgreSql 7.5 for windows. Recently, my mapping features went down. Error messages that display are t

Re: [ADMIN] [SQL] parsing audit table

2011-08-28 Thread Jan Eskilsson
Hi Jamie & All I experimented a bit with the audit function and i added a field to the audit table where i store which table the audit record originates from. I was thinking it should be possible to to pare the hstore fields using populate_record to its original form using the original table defi