Re: [ADMIN] full data disk -- any chance of recovery

2006-01-01 Thread Gregory S. Williamson
Jeff -- Thanks for the suggestion -- I think this fills the bill except that the postmaster won't quit because it has no space (at least that is how I interpet it). These are all linux boxes with the same architecture (2 CPUs, 2 gigs of RAM, disks not adequate for a database: QED). I had an ur

Re: [ADMIN] full data disk -- any chance of recovery

2006-01-01 Thread Jeff Frost
Greg, I'm not sure what you're looking for in the way of suggestions. Do you just want to be able to start this postgres server up and remove some data? Easiest way I see to accomplish that given the information you provided is to move pg_xlog to the sda disk and symlink it to the data dir. In

[ADMIN] full data disk -- any chance of recovery

2006-01-01 Thread Gregory S. Williamson
An enthusiastic person in out content department went and did a silly thing ... Well, he went and fired off an update that consumed all of the remaining disk space on two runtime servers. We've fallen back to a hot spare and I am faced with trying to retrieve these machines by Tuesday morning

Re: [ADMIN] Connect to PostgreSQL server from an ADSL connection

2006-01-01 Thread John DeSoi
Szabolcs, On Jan 1, 2006, at 2:05 PM, Szabolcs Andrási wrote: The documentation says about the "listen_addresses" configuration parameter in the postgresql.conf file, that to accept TCP/IP connections its value must be '*' or at least its value must contain the host names on which the server is

Re: [ADMIN] Connect to PostgreSQL server from an ADSL connection

2006-01-01 Thread tony
Le dimanche 01 janvier 2006 à 20:05 +0100, Szabolcs Andrási a écrit : > > ssh -v -L 5432:localhost:5432 [EMAIL PROTECTED] > > > > Then connect to your database on localhost. > Thank you very much for your answer. Sorry to bother you again with > the same question but unfortunately it is still not

Re: [ADMIN] Connect to PostgreSQL server from an ADSL connection

2006-01-01 Thread Szabolcs Andrási
> ssh -v -L 5432:localhost:5432 [EMAIL PROTECTED] > > Then connect to your database on localhost. Hi Tony, Thank you very much for your answer. Sorry to bother you again with the same question but unfortunately it is still not clear to me how to configure the PostgreSQL server. Could you please b

Re: [ADMIN] Connect to PostgreSQL server from an ADSL connection

2006-01-01 Thread tony
Le dimanche 01 janvier 2006 à 16:40 +0100, Szabolcs Andrási a écrit : > Hi all, > > I am writing because I would like to know that how can I connect > remotely to a PostgreSQL database from an ADSL connection, which has > different IP address every time when it connects to the Internet. This > ADS

[ADMIN] Connect to PostgreSQL server from an ADSL connection

2006-01-01 Thread Szabolcs Andrási
Hi all, I am writing because I would like to know that how can I connect remotely to a PostgreSQL database from an ADSL connection, which has different IP address every time when it connects to the Internet. This ADSL connection is registered to www.dyndns.org, so its dynamic IP address is replace

Re: [ADMIN] Running Postgres on CD - With Win32

2006-01-01 Thread Dennis Wagner
Hi Peter! Of course I don't want to just include a client. For that i would just use Npgsql and that's it. And I wouldn't need a CD/DVD at all. No, I want to export some of the data stored in the (linux-)backend onto the DVD together with a read-only-version of the client-app. And that applica

Re: [ADMIN] Req Documentation for installing PG SQL8.1 by hand

2006-01-01 Thread Magnus Hagander
> Hi Magnus, > > Thanks a lot for the info. It works! I am still facing some > issues related to rights when I do not run PG as a service. > Could you help me by providing the documentation to do the > installation of pg8.0 by hand. It's in the main postgresql documentation (www.postgresql.or