| From: | Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk> |
|---|---|
| To: | |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: see previous queries |
| Date: | 2003-12-04 10:26:13 |
| Message-ID: | Pine.LNX.4.58.0312041021410.5372@bluedragon.homelinux.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 4 Dec 2003, Sai Hertz And Control Systems wrote:
>
> Dear Ashok,
>
> Hope you are not using
> Postgresql 7.4
> if this is the case I think some insert /update statements are waiting
> for commit command
>
> Regards,
> V Kashyap
>
> >hi
> >i am a new user in postgresql.
> >problem:- in postgresql there is any command to see history (previous
> >day queries) like as history command in linux.
> >thank you
> >
postgres will log your queries. You need to configure it to do so.
7.4 also logs queries that take a long time. The logs go either to file or
the system message log. depending on how you set it up in postgresql.conf.
The log can not be used to rebuild your database :(
psql also has a shell like history function.
Peter Childs
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sai Hertz And Control Systems | 2003-12-04 10:28:00 | Re: see previous queries |
| Previous Message | Stephan Szabo | 2003-12-04 10:20:05 | Re: see previous queries |