I don't seem to be able to connect to gborg.postgresql.org this
evening...

Jerry


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Fri, 5 Nov 2004, Jerry LeVan wrote:

Already working on it ... I found an undocumented 'feature' in FreeBSD
today while doing some cleanups ... we ordered a terminal server to allow
us to do remote admin on the servers, but, unfortunately, we're still
waiting for it to arrive, so we're waiting for a tech to reset the server
....

I've posted details to the FreeBSD -stable and -current mailing list, but
the simple summary is that 'ifconfig <dev> -alias' with no ip specific'd
literally erases all IPs on that device, leaving the server running
'un-networked' ...


----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy (AT) hub (DOT) org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Jerry LeVan wrote:


I can second this. Gborg is down.

Sincerely,

Joshua D. Drake





--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd (AT) commandprompt (DOT) com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Sincerely,

Joshua D. Drake





--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd (AT) commandprompt (DOT) com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

On Fri, 5 Nov 2004, Joshua D. Drake wrote:

Ya well, its not something I'm particularly proud about ...

Stupid question for someone running Linux ... is this standard behaviour
that I've been lucky never to hit before, or is this something that Linux
deals with slightly more intelligently?

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy (AT) hub (DOT) org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Well in linux you would do something like this:

ifconfig <dev>

If you want an alias it is:

ifconfig <dev>:<alias>

If you don't specify a parameter such as up it will just display the
current config.
If there is no current config it just display the default.

So in short, no Linux will not do what you ran into. At least not in the
same manner.

On any init.d based Linux system (gentoo, redhat, suse) the only thing I
have found
really annoying is that it doesn't confirm for the following:

/etc/init.d/network stop

I have more than once, really late at night typed that command when
meaning to be

/etc/init.d/sendmail stop

Sincerely,

Joshua D. Drake






--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd (AT) commandprompt (DOT) com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Marc G. Fournier wrote:
I used to have a script on my remote server that I was running in BG before
to touch the network, that script was bringing up the network if was down
for more then 2 minutes. My server is now hosted in my house and I do not
need it anymore, I changed it with the no-ip script :-)



Regards
Gaetano Mendola

On Sat, 6 Nov 2004, Gaetano Mendola wrote:

Until now, I didn't think I'd need such a think In almost 12 years of
networking, that is one thing that I've never done, unconfigured the main
IP ;(

Then again, I think I've been lucky so far in that I've never done an 'rm
-rf /' either

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy (AT) hub (DOT) org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

On Sat, Nov 06, 2004 at 11:09:07AM -0400, Marc G. Fournier wrote:
Yeah, I think part of the problem was that it was an accident and not
something planned. I have had to change the main IP address of a remote
server a couple of times, so I used a script like Gaetano's (though I
measured time in terms of seconds, usually less than ten, not minutes).
But you weren't given the chance :-)

Very lucky indeed. I did that (or equivalents like rm -fr /lib) at least
two times.


Unrelated: I just noticed that you added the mboxen to lists archives.
Many many thanks for that!

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"La realidad se compone de muchos sueños, todos ellos diferentes,
pero en cierto aspecto, parecidos..." (Yo, hablando de sueños eróticos)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly