Re: [ADMIN] Server Down problem

2006-08-25 Thread Volker
Hi tom, the database is on a mountable volume. So that could be our problem. Reading your comments i would like to know if an automatic initdb on postmaster startup can be disabled. Is this possible? We would receive a severe postmaster error, but this would be expected behaviour in case that

[ADMIN] CMS - portal server Question

2006-08-25 Thread Achilleas Mantzios
Hi, i am thinking of deploying a CMS system for our corporate web server. I have seen/installed/tested : Jboss Portal : Seeems good and standards complying but too unstable Apache Lenya : Very unstable - could not get it to any useful work Php-nuke     : (despite our favor towards java, this seem

Re: [ADMIN] CMS - portal server Question

2006-08-25 Thread Sergiusz Jarczyk
Hi Achilleas Achilleas Mantzios wrote: Hi, i am thinking of deploying a CMS system for our corporate web server. I have seen/installed/tested : Jboss Portal : Seeems good and standards complying but too unstable Apache Lenya : Very unstable - could not get it to any useful work Php-nuke :

Re: [ADMIN] [GENERAL] CMS - portal server Question

2006-08-25 Thread Andrew Kelly
On Fri, 2006-08-25 at 12:07 +0300, Achilleas Mantzios wrote: > In the same sense java is prefered over PHP, since we dont intent to interfere > with CMS code, but if some killer PHP app does the job, then it will be the > one selected. Take a look at eZpublish (http://ez.no). Killer PHP app, s

Re: [ADMIN] CMS - portal server Question

2006-08-25 Thread Mark Matthews
On 25/08/2006, at 7:07 PM, Achilleas Mantzios wrote: Hi, i am thinking of deploying a CMS system for our corporate web server. I have seen/installed/tested : Jboss Portal : Seeems good and standards complying but too unstable Apache Lenya : Very unstable - could not get it to any useful work

[ADMIN] Strange message followed by server crash

2006-08-25 Thread Donald Fraser
I'm trying to figure out what exactly caused PostgreSQL to crash.   PostgreSQL 8.0.7 OS: Red Hat Linux EL 4.0   Log messages: <1Tmenteshvili 10709 2006-08-24 17:48:19 BST 0> ERROR:  invalid message format< 3670 2006-08-24 17:48:19 BST > LOG:  server process (PID 10709) was terminated by signa

[ADMIN] Is the server running on host "192.168.2.111" and accepting TCP/IP conn

2006-08-25 Thread Purusothaman A
hi all, I am purusothaman and new to PostgreSQL world. I am using PostgreSQL 8.1.3 in Windows 2000 machine. My problem is, I am unable to connect to PostgreSQL server from another machine's psql client. My system IP is 192.168.2.111, and client machine IP is 192.168.2.89. I can connect to th

Re: [ADMIN] CMS - portal server Question

2006-08-25 Thread Bradley Kieser
I think that PHP will be were you are at. The Java route in the WEB world is just too much code for too little benefit. It's fine for big apps, but frankly, for web environments it's very top-heavy. Modern scripting languages walk all over it. And yes, I do actually love working in Java, I am v

Re: [ADMIN] Server Down problem

2006-08-25 Thread Tom Lane
Volker <[EMAIL PROTECTED]> writes: > the database is on a mountable volume. So that could be our problem. > Reading your comments i would like to know if an automatic initdb on > postmaster startup can be disabled. Just change the initscript. There's been periodic discussion about whether the au

Re: [ADMIN] Strange message followed by server crash

2006-08-25 Thread Tom Lane
"Donald Fraser" <[EMAIL PROTECTED]> writes: > Log messages: > <1Tmenteshvili 10709 2006-08-24 17:48:19 BST 0> ERROR: invalid message format > < 3670 2006-08-24 17:48:19 BST > LOG: server process (PID 10709) was > terminated by signal 11 > At the same time, an engineer, who thought nobody was in

[ADMIN] 7.4 - data recovery

2006-08-25 Thread Bartosz Belter
-- I'm re-sending this email to pgsql-admin mailing list -- to get more people involved (already sent to -- pgsql-general) -- Very sorry, if it's not well seen on this mailing list! Hi, I'm not postgresql experienced user, so please forgive me, if I missed something obvious! I have the

Re: [ADMIN] Is the server running on host "192.168.2.111" and accepting TCP/IP conn

2006-08-25 Thread Tom Lane
Purusothaman A <[EMAIL PROTECTED]> writes: > My system IP is 192.168.2.111, and client machine IP is 192.168.2.89. > I can connect to the PostgreSQL server with " psql -Uroot -h192.168.2.111" > from same system(192.168.2.111) > If I give the above command from 192.168.2.89, results > E:\Program

Re: [ADMIN] Strange message followed by server crash

2006-08-25 Thread Donald Fraser
>"Donald Fraser" <[EMAIL PROTECTED]> writes:>> Log messages:>> <1Tmenteshvili 10709 2006-08-24 17:48:19 BST 0> ERROR:  invalid message format>> < 3670 2006-08-24 17:48:19 BST > LOG:  server process (PID 10709) was terminated by signal 11>> At the same time, an engineer, who thought nobody

Re: [ADMIN] Strange message followed by server crash

2006-08-25 Thread Tom Lane
"Donald Fraser" <[EMAIL PROTECTED]> writes: > "Tom Lane" writes: >> Given that this sounds like it won't be easy to reproduce, I'm hoping >> you have a core file left from that and can get a stack trace from it. > Where would I look for a core file? > There's nothing unusual in the data directory,

Re: [ADMIN] Strange message followed by server crash

2006-08-25 Thread Alvaro Herrera
Tom Lane wrote: > "Donald Fraser" <[EMAIL PROTECTED]> writes: > > "Tom Lane" writes: > >> Given that this sounds like it won't be easy to reproduce, I'm hoping > >> you have a core file left from that and can get a stack trace from it. > > > Where would I look for a core file? > > There's nothing

[ADMIN] Problem with PostgreSQL 8.1.4 Install (using RPMs)

2006-08-25 Thread Lane Van Ingen
The basic install of Red Hat (RHEL ES 4.0) for PostgreSQL version 8.1.4 appears to have gone well (database is up and running) except for one thing: I can't login as postgres. Assume the login would be 'postgres' or 'postgresql', but can't get in via psql or pgAdmin3 to set up new users and databa

Re: [ADMIN] Problem with PostgreSQL 8.1.4 Install (using RPMs)

2006-08-25 Thread Peter Eisentraut
Lane Van Ingen wrote: > Does anyone know what the initial user/password should be? Thanks. Probably postgres without a password but with ident authentication, which means you must log in as the postgres user on your OS. (That one probably doesn't have a password either, so go through root.) --

Re: [ADMIN] 7.4 - data recovery

2006-08-25 Thread Peter Eisentraut
Bartosz Belter wrote: > 3. I've recovered some files and it looks to me they're from > $PGDATA/base/data/xxx (it looks this is the complete folder) > 4. No other files! (no pg_clog, pg_xlog etc) If you don't have a clog, then all your transactions will appear as "didn't happen yet", so your table

Re: [ADMIN] Problem with PostgreSQL 8.1.4 Install (using RPMs)

2006-08-25 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Lane Van Ingen wrote: >> Does anyone know what the initial user/password should be? Thanks. > Probably postgres without a password but with ident authentication, > which means you must log in as the postgres user on your OS. (That one > probably do

Re: [ADMIN] 7.4 - data recovery

2006-08-25 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Bartosz Belter wrote: >> 3. I've recovered some files and it looks to me they're from >> $PGDATA/base/data/xxx (it looks this is the complete folder) >> 4. No other files! (no pg_clog, pg_xlog etc) > If you don't have a clog, then all your transaction

[ADMIN] Issue With Restoring a Dump

2006-08-25 Thread Jeanna Geier
Hi, I'm having a problem with restoring a dump that I executed and would appreciate any assistance anyone could give me. I'm a newbie here, so please bear with me. I'm using Postgre 8.0 Version 1.2.1; I executed the dump using the following command: pg_dump -h localhost -U postgres -o dbNa

Re: [ADMIN] Issue With Restoring a Dump

2006-08-25 Thread Magnus Hagander
> I'm using Postgre 8.0 Version 1.2.1; I executed the dump > using the following > command: There is no "version 1.2.1" of PostgreSQL 8.0. There 8.0, 8.0.1 etc up to 8.0.8. And this looks a lot like a bug that was fixed in 8.0.8, so you should try an upgrade. //Magnus -

Re: [ADMIN] Issue With Restoring a Dump

2006-08-25 Thread Scott Marlowe
On Fri, 2006-08-25 at 13:55, Magnus Hagander wrote: > > I'm using Postgre 8.0 Version 1.2.1; I executed the dump > > using the following > > command: > > There is no "version 1.2.1" of PostgreSQL 8.0. There 8.0, 8.0.1 etc up > to 8.0.8. > > And this looks a lot like a bug that was fixed in 8.0.8

Re: [ADMIN] CMS - portal server Question

2006-08-25 Thread Andy Shellam
We've just taken on ModX (www.modxcms.com) as our corporate CMS system. You can manage documents, and even write your own php "snippets" - similar idea to Webparts in M$ SharePoint and modules in Mambo, but they're much easier to create and use. You can design your site from the ground up if

Re: [ADMIN] Issue With Restoring a Dump

2006-08-25 Thread Jeanna Geier
Sorry for the mix-up My version of Postgres is just 8.0. The pgadmin is 1.2.1, that's where I got mixed up... So, it sounds like an upgrade might fix this; I'll give that a try. Thanks for your help! - Original Message - From: "Scott Marlowe" <[EMAIL PROTECTED]> To: "Magnus Ha

Re: [ADMIN] Issue With Restoring a Dump

2006-08-25 Thread Scott Marlowe
On Fri, 2006-08-25 at 16:04, Jeanna Geier wrote: > Sorry for the mix-up > > My version of Postgres is just 8.0. The pgadmin is 1.2.1, that's where I > got mixed up... > > So, it sounds like an upgrade might fix this; I'll give that a try. Just FYI, PostgreSQL has had the best batting avera

[ADMIN] DB Synchronization.

2006-08-25 Thread nilesh khode
Hello All, I am having Postgresql 8 installed on 2 RH Linux box. I am keeping one server in stand-by mode. If one server is failed for any reason, the DB should be serving from another server. I am having one question about the synchronization. How to keep another server in updated mode? It s