On Wed, 1 Dec 2004 04:36:44 -0800 (PST), Sudhakar Kurumella
<[EMAIL PROTECTED]> wrote:
Hello Everyone,
I am new to PostgreSQL, i have a question, i'll appreciate if anybody
helps me.
How can i export/import a complete database running on one machine to
another machine. I have gone through th
Hi,
I used to make synchrnoistation between data directories with Rsync cause
it's faster when synchronizing offline database than making a dump.
It works really nice between all the PowerPC we used, but it doesn't work
on x86 server (the postmaster refuses to start because the
PG_CONTROL_VE
On 20 Aug 2004 12:05:47 -, bala srini <[EMAIL PROTECTED]>
wrote:
Hi
I want to disconnect all already established REMOTE DB connections
from the server without restarting the Postmaster daemon. Requirement is
that diconnect should be done from the server side. Actually I tried to
kill
On Wed, 16 Jun 2004 09:37:58 -0500 (CDT), C. Bensend
<[EMAIL PROTECTED]> wrote:
You might want to look into the autovacuum daemon, and / or increasing
fsm settings to be large enough to hold all the spare tuples released by
vacuuming.
IIRC, the autovacuum stuff was added in 7.4, which I'm not r
Hi,
I've a "little" problem while trying to access any pg database trough our
VPN. It simply refuse the connection. Otherwise, The connection works fine
on our server put in the DMZ with a classical connection.
Our setup is:
client: Eclipse with a JDBC driver trough VPN
server: Pg SQL 7.4.2 wi
On Wed, 19 May 2004 11:03:11 +0300, Olivier Hubaut
<[EMAIL PROTECTED]> wrote:
Hi,
I've a "little" problem while trying to access any pg database trough our
VPN. It simply refuse the connection. Otherwise, The connection works
fine
on our server put in the DMZ with a class
Hi,
I've a "little" problem while trying to access any pg database trough our
VPN. It simply refuse the connection. Otherwise, The connection works fine
on our server put in the DMZ with a classical connection.
Our setup is:
client: Eclipse with a JDBC driver trough VPN
server: Pg SQL 7.4.2 with a
Tom Lane wrote:
Olivier Hubaut <[EMAIL PROTECTED]> writes:
PANIC: could not open transaction-commit log directory
(/usr/local/pgsql/annot/pg_clog): Too many open files
But it's amazing to me that i had to reduce it so much as the postmaster
is almost the only application runn
Tom Lane wrote:
Olivier Hubaut <[EMAIL PROTECTED]> writes:
PANIC: could not open transaction-commit log directory
(/usr/local/pgsql/annot/pg_clog): Too many open files
Try reducing max_files_per_process (in postgresql.conf) and/or
increasing the kernel's limit on number of op
Hi,
On PostgreSQL 7.3.3 on MacOS X 10.2, the ANALYZE command sometimes crash
and I don't know why! I've tried it some binaries copies of the DB, it's
a totally random behaviour.
When it crahes, I get this message:
PANIC: could not open transaction-commit log directory
(/usr/local/pgsql/annot
Arun Gananathan wrote:
Could any one let me know is there a way to findout the rules previously created in the database .
thanks
ganesh
http://www.postgresql.org/docs/7.4/static/view-pg-rules.html#AEN51975
--
Ci-git une signature avortee.
** RIP **
---(end of broadcast)-
I'm wondering how to cleanly disconnect a user from the DB. For the
moment, the only way I found is to kill the pid of the user but I found
it quite ugly.
--
Ci-git une signature avortee.
** RIP **
---(end of broadcast)---
TIP 9: the planner will i
Hi,
I need to use the cross database reference form some select closes. I've
install PG 7.3.4 using the 'make all' option, but it seems that the
functionnality isn't set anyway.
Is there another package I need to install or some commands I need to do?
Thanks,
--
Ci-git une signature avortee.
Hi everyboy, my first post.
I currently have PgSQL 7.3.4 install on a OS X 10.2.8 and it works fine.
I've tried to install the new version (7.4) but each time I try to
compile it, it make me a error. I've tu upgrade th Bison parser, as says
in the warning message, but it does nothing.
I'searc
14 matches
Mail list logo
