Re: [GENERAL] Any Good Way To Do Sync DB's?

2001-10-13 Thread Gurunandan R. Bhat
On 12 Oct 2001, Doug McNaught wrote: > Probably the best thing to do is to export the data from Progress in a > format that the PostgreSQL COPY command can read. See the docs for > details. Hi, I wrote a quick and dirty function/trigger to sync two DBs - one local and the other on t

Re: [GENERAL] Multiple postgresql installations on one machine.

2001-10-13 Thread Lincoln Yeoh
Thanks. I didn't know psql -h did that, thought it was for hostnames only :). So I resorted to TCP access for the rest of the installations and moved the sockets out of the way. However the Redhat style initscript tends to shutdown all installations - even though I specified a different PID file

Re: [GENERAL] [Off-topic, Meta-question] Problems with psql-general list

2001-10-13 Thread Allan Engelhardt
Tom Lane wrote: > Allan Engelhardt <[EMAIL PROTECTED]> writes: > > 1. Am I the only one who are having problems with the listerver not honouring the >NOMAIL option? > > Marc said yesterday that he'd been forced to rebuild the subscriber list > for pgsql-general. Sounds like your NOMAIL preferen

[GENERAL] PGSQL & java applets

2001-10-13 Thread Svenne Krap
Hi, Is it possible to use pgsql in java-applets. If it is, any skeleton app woudl be greatly appriciated... /Svenne -- Mail [EMAIL PROTECTED] - [EMAIL PROTECTED] - PGP key id : 0xDF484022 ICQ: 5434480 - http://www.krap.dk - http://www.krap.net PGP Key http://keys.pgp.dk:11371/pks/lookup?op=

[GENERAL] why do I receive these news-group posts in my mail box?

2001-10-13 Thread David Pirotte
i was suppose to read the news group, not to receive messages in my mail box, which is what happens since few days can anyone in charge see what happens: it's only sort of 2 days ago that this started, before everything was OK thanks, david ---(end of broadcast)-

Re: [GENERAL] [Off-topic, Meta-question] Problems with psql-general list

2001-10-13 Thread Tom Lane
Allan Engelhardt <[EMAIL PROTECTED]> writes: > 1. Am I the only one who are having problems with the listerver not honouring the >NOMAIL option? Marc said yesterday that he'd been forced to rebuild the subscriber list for pgsql-general. Sounds like your NOMAIL preference got lost in the shuffle

Re: [GENERAL] Any Good Way To Do Sync DB's?

2001-10-13 Thread Tom Lane
Gordan Bobic <[EMAIL PROTECTED]> writes: > I'm going to have to rant now. The "dump" and "restore" which use the COPY > method are actually totally useless for large databases. The reason for > this is simple. Copying a 4 GB table with 40M rows requires over 40GB of > temporary scratch space to co

Re: [GENERAL] COMMIT after an ERROR?

2001-10-13 Thread J C Lawrence
On Fri, 12 Oct 2001 19:35:30 -0700 patrick keshishian <[EMAIL PROTECTED]> wrote: > The only things that are not rolled back are advancing of > sequences and such. I suspect serial types also exhibit similar > behavior to sequences. Ahh, that's actually critical information (which makes sense t

Re: [GENERAL] Contents of greatbridge.com?

2001-10-13 Thread Tom Lane
>> No one has mentioned it so far, but I wonder if any of the Great >> Bridge people were hired by Red Hat? The reason it hasn't been mentioned is that negotiations are still in play. I believe I can safely say that RH hasn't hired any ex-GB people yet ... but I doubt that will hold true for lon

[GENERAL] Book webpage update

2001-10-13 Thread Bruce Momjian
I have updated my book's web page at: http://www.postgresql.org/docs/awbook.html Additions include: o Information about the new German and Japanese translations o Book reviews o Two new chapters, in HTML and PDF format -- Bruce Momjian

Re: [GENERAL] Rotating PostgreSQL LOGs on Web site ??

2001-10-13 Thread Bruce Momjian
I think the general solution is to compile with syslog support and use the normal syslog rotation scripts. > Hi, > > I'm interesting to know how to find a solution for rotating the > PostgreSQL log file ... > > I'm usgin thoses options for the log generated : > silent_mode = false > log_connec

Re: [GENERAL] A tool for making console/text data enrty/display screens in C

2001-10-13 Thread Andrej Falout
In article <3bc3915b.1185965@gtech>, degoble@gtech says... > > I am lazy. I which to write some c console/text programs to interface > with postgresql. Are there any tools/utilities, to help make the data > entry/display screens...? Aubit is much more then you asked for, but it will allow you to

Re: [GENERAL] Multiple postgresql installations on one machine.

2001-10-13 Thread Tom Lane
Charles Tassell <[EMAIL PROTECTED]> writes: > I may be wrong, but I don't think it's possible to have them on the same > port. The problem is that the TCP/IP port defaults to the same as the UNIX > sockets port, and UNIX sockets are local to the machine, so they are > completely independent of