[ADMIN] pgAgent Windows service startup time

2009-09-16 Thread Dmitry Samokhin
Hello, The first time I tried to setup the pgAgent job scheduler on Windows I was wondered the service couldn't start for a very long time. Further investigation shown that the 'poll time interval' executable parameter (-t) affects startup time. Moreover, startup time directly reflects this pa

[ADMIN] postgres scripting

2009-09-16 Thread John P Weatherman
Hi all, I have to reindex 2 indexes in pg_catalog using postgres --single. There are 16 seperate databases on each of 4 servers that I have to do this on, so obviously it would be much better to script the changes. I can handle identifying the dbs and starting postgres no problem, but I can't see

Re: [ADMIN] postgres scripting

2009-09-16 Thread Kevin Grittner
John P Weatherman wrote: > can handle identifying the dbs and starting postgres no problem, but I > can't seem to find a way to pass a CTRL-D character from within a bash > script to the postgres executable. Why not put the SQL in a separate file and pipe it in? (I haven't tested that, but it

Re: [ADMIN] postgres scripting

2009-09-16 Thread Tom Lane
John P Weatherman writes: > I can't seem to find a way to pass a CTRL-D character from within a bash > script to the postgres executable. Control-D is just a way to signal EOF from the keyboard. If you're scripting, reaching the end of the script input does the same thing.

[ADMIN] hardware information

2009-09-16 Thread std pik
Hello all.. I'm using PostgreSQL 8.3.. How can I get information about the hardware utilization: - CPU usage. - Disk space. - Memory allocation. thank you. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postg

Re: [ADMIN] LDAP where DN does not include UID attribute

2009-09-16 Thread Robert Fleming
On Mon, Sep 14, 2009 at 4:56 PM, Scott Marlowe wrote: > On Mon, Sep 14, 2009 at 5:47 PM, Robert Fleming > wrote: > > On Mon, Sep 14, 2009 at 4:23 PM, Tom Lane wrote: > >> > >> Robert Fleming writes: > >> > But I would like to authenticate to PostgreSQL using the "uid" LDAP > >> > attribute, > >

[ADMIN] locking issues with pg_dump and vacuum (win server 2003)

2009-09-16 Thread Pat Chan
Hello, I am running Postgresql 8.1.5 on a Win Server 2003 machine, and am 1) running a pg_dump every day at 2am (during lowest usage time - practically idle time)here is a script i use (this is in turn run from Scheduled Tasks in control panel):--...@echo OFF ECHO. ECHO This is a batch

Re: [ADMIN] hardware information

2009-09-16 Thread raghu ram
On Tue, Sep 15, 2009 at 3:28 PM, std pik wrote: > Hello all.. > I'm using PostgreSQL 8.3.. > How can I get information about the hardware utilization: > - CPU usage. > - Disk space. > - Memory allocation. > thank you. > > could you please share the operating system details? Tha

Re: [ADMIN] hardware information

2009-09-16 Thread wanpeng
you may get those infomation from your OS. std pik 写道: Hello all.. I'm using PostgreSQL 8.3.. How can I get information about the hardware utilization: - CPU usage. - Disk space. - Memory allocation. thank you. -- Sent via pgsql-admin mailing list (pgsql-admin@postgres

Re: [ADMIN] hardware information

2009-09-16 Thread Scott Marlowe
On Tue, Sep 15, 2009 at 3:58 AM, std pik wrote: > Hello all.. > I'm using PostgreSQL 8.3.. > How can I get information about the hardware utilization: >       - CPU usage. >       - Disk space. >       - Memory allocation. > thank you. Dude, there was a whole thread. Are you receiving our emails