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
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
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
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.
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
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,
> >
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
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
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
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
10 matches
Mail list logo