Re: [ADMIN] Case studies

2007-11-26 Thread Scott Marlowe
On Nov 26, 2007 9:34 PM, Elvis Henríquez <[EMAIL PROTECTED]> wrote: > Hello everybody. > > Rather than asking for a technical detail or writing about a problem, > I'm asking for up-to-date case studies involving PostgreSQL. > > The company where I'm actually working is migrating some apps; one > re

Re: [ADMIN] Case studies

2007-11-26 Thread Rodrigo De León
On Nov 26, 2007 10:34 PM, Elvis Henríquez <[EMAIL PROTECTED]> wrote: > I hope you could help me with this. See: http://www.lethargy.org/~jesus/archives/66-Big-Bad-PostgreSQL.html ---(end of broadcast)--- TIP 5: don't forget to increase your free spa

Re: [ADMIN] Someone let me get instruction to remove service of postgreSQL database server

2007-11-26 Thread Vishal Arora
use net commands on prompt. Eg. net stop - Vishal > Date: Wed, 21 Nov 2007 17:29:08 +0900> From: [EMAIL PROTECTED]> To: > pgsql-admin@postgresql.org> Subject: [ADMIN] Someone let me get instruction > to remove service of postgreSQL database server> > Hello, I support > postgreSQL 8.0

Re: [ADMIN] postmaster -D PGDATA and postmaster.pid

2007-11-26 Thread Tom Lane
"Medi Montaseri" <[EMAIL PROTECTED]> writes: > However if I try to start the engine with "/etc/init.d/postgresql start " or > service postgresql start" I see the following error message in my PGLOG (ie > /var/log/pgsql/pgstartup.log) > postmaster cannot access the server configuration file > "/qms

[ADMIN] postmaster -D PGDATA and postmaster.pid

2007-11-26 Thread Medi Montaseri
Hi, I am configuring a PG 8.1.9 on CentOS 5. I am seeing some anomalies and would like you feedback. I have defined a new PGDATA=/qmsvol/pg_8.1.9/data, ran initdb -D /qmsvol/pg_8.1.9/data successfully and can start the engine with pg_ctl -D $PGDATA. I have also populated /etc/sysconfig/pgsql/post

[ADMIN] Case studies

2007-11-26 Thread Elvis Henríquez
Hello everybody. Rather than asking for a technical detail or writing about a problem, I'm asking for up-to-date case studies involving PostgreSQL. The company where I'm actually working is migrating some apps; one requires a Data Warehouse, and I'm proposing PostgreSQL, but they're thinking of O

Re: [ADMIN] database cluster missing

2007-11-26 Thread Tom Lane
Jose Calderon <[EMAIL PROTECTED]> writes: > Hello I don't know where to start with this problem, so we do weekly > backups of our computers. The hard drive of one of our computers stopped > working so we are trying to restore it. We had an image of the hard drive > and used the latest backups.

[ADMIN] Is there an easy and safe way to migrate a database to a new tablespace?

2007-11-26 Thread David Young
Hi, I recently converted to using a postgresql engine that support tablespaces. There's a database that I would like to move to a new tablespace for performance reasons. What is the safe and correct way of doing this? The documentation is a bit sketchy on this. Thanks in advance, David

[ADMIN] database cluster missing

2007-11-26 Thread Jose Calderon
Hello I don't know where to start with this problem, so we do weekly backups of our computers. The hard drive of one of our computers stopped working so we are trying to restore it. We had an image of the hard drive and used the latest backups. Now I can start the database without a problem

Re: [ADMIN] Error while compiling PostgreSQL with Java

2007-11-26 Thread Lew
Peter Eisentraut wrote: Никоноров Григорий wrote: I have a problem. I try to install PostgreSQL from source with java. I Installed JDK, ANT properly but when i try to configure i have an error - Warning.Ignored options - --with-java. Please help me ! PostgreSQL has no such option. You may be

Re: [ADMIN] Restoring wrong accents

2007-11-26 Thread José Roberto Motta Garcia
You where right. It's ok now, it was the old one "If you want it to be done correctly do it yourself". Tks a lot. Jose Roberto M. Garcia, MSc Analista de Sistemas - Grupo Banco de Dados Fone: (12) 3186-8405 -- A luta contra o aquecimento global depende de cada um de nós, faça sua parte, econom

Re: [ADMIN] Migrating from 32 to 64 bit

2007-11-26 Thread Medi Montaseri
I agree with you practical pointsI qualified my comments by sayingtheoretically speaking Cheers Medi On Nov 26, 2007 8:01 AM, Chris Browne <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] ("Medi Montaseri") writes: > > But theoretically speaking, 32 or 64-bit ness of the application (i

Re: [ADMIN] Error while compiling PostgreSQL with Java

2007-11-26 Thread Lew
Никоноров Григорий wrote: Thanks for your answer.When i [sic] download this "JDBC4 Postgresql Driver, Version 8.2-506" driver what should i do next to configure PostgreSQL with it ? Place the JAR containing the driver in the classpath for your Java application. In the Java program be sure to

Re: [ADMIN] Migrating from 32 to 64 bit

2007-11-26 Thread Chris Browne
[EMAIL PROTECTED] ("Medi Montaseri") writes: > But theoretically speaking, 32 or 64-bit ness of the application (ie the > postmaster server) should not influence the data types offered by a > particular DB > version. That is the semantics of data types and cpu-arch (register width, > big endian,

Re: [ADMIN] pg_start_backup without WAL archiving

2007-11-26 Thread Simon Riggs
On Sun, 2007-11-25 at 15:24 +0100, Peter Eisentraut wrote: > Why is it not allowed to call pg_start_backup when WAL archiving is off? > Wouldn't this be useful as a discrete file system backup without PITR > capability? I'm submitting a patch today that better describes PITR facilities for maki