On 04/20/2011 10:49 PM, raghu ram wrote:
On Thu, Apr 21, 2011 at 1:01 AM, Mario Splivalo
mailto:mario.spliv...@megafon.hr>> wrote:
I have set up munin monitoring that plots nice graphs using
pg_stat_bgwriter and pg_stat_database views. It has been on for
quite some time now, and the n
Mlondolozi Ncapayi wrote:
> I installed PostgreSql 8.4 and now I want to delete/ uninstall it
> completely to start a new fresh installation.
> Can you please give me clear instructions on how to do that or
> maybe a script that I can run.
That's going to depend entirely on how you installed
>
>
> Heh, I've neglected to mention that i'm using postgres 8.4.5 on Debian
> Stable. Is there a way to reset statistics on pg8.4? I've tested it on 9.0
> and it works there.
>
>
>
AFAIK, I dont think we can achieve this in PG 8.4 at cluster level. Can
anybody has the information ?
-- Raghu
hi
I want just to install sepostgresql-9.0.3 from source code...
but I have some problems...
in fedora 14 when I issue ./configure --enable-selinux according the manual for
installing the sepostgresql, I have some errors : selinux support requires
libaudit!
however in fedora 14 I have installed
Is there a way to query a unix timestamp date? In the database the orderdate
field is a unix timestamp.
I would like to create the where clause to a query on a specific date like
December 17, 2010.
Select * from orders where orderdate = '12/17/2010';
Thanks
Marc
On Apr 21, 2011, at 2:19 PM, Marc Fromm wrote:
> Is there a way to query a unix timestamp date? In the database the orderdate
> field is a unix timestamp.
> I would like to create the where clause to a query on a specific date like
> December 17, 2010.
> Select * from orders where orderdate = ‘1
