>Jens Hartwig writes:
>
>> is there any way to identify users which are currently connected to the
>> database? Does perhaps even exist a method to notify this users (e.g. to
>> close the connection)?
>
>ps ax | grep postgres
>
>is the best way to go.
This command tells me that several backends
>is there any way to identify users which are currently connected to the
>database? Does perhaps even exist a method to notify this users (e.g. to
>close the connection)?
I don't know if this feature exists, but it will be very useful
for me, too...
hello everybody,
I was trying playing with the CREATE FUNCTION statement in psql when I made
a copy/paste mistake : the function body was empty. The error message was
strange:
guanabara:~> psql
Password:
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distrib
>Is it posible to schedule / automate a backup task and functions to execute
>at a pre-defined time at a pre-defined recurrence rate?
yes, using the cron daemon and the commands pg_dump or pg_dumpall.
The following entry in the postgres user crontab will backup the
database every day at 03:01 A
>ERROR: Load of file /usr/local/pgsql/lib/pltcl.so failed: ld.so.1: /usr/
>local/pgsql/bin/postmaster: fatal: relocation error: file /usr/local/pgs
>ql/lib/pltcl.so: symbol CurrentMemoryContext: referenced symbol not found
>
> Is there a way to solve this dynamic link problem ?
ok, sorry for th
Hello,
I'm a beginner postgresql admin and I have problems with pltcl on a solaris
box.
Some users need statistical function (standard deviation, variance) and
I know
that this feature is not (yet) implemented. I found a piece of Tcl code
in the
mailing list archive at
http://www.
