Re: [ADMIN] Restore DataBase

2010-06-02 Thread Andreas Schmitz
hi, sounds like a plain text backup. your problem, I guess, will be some constraint issue. I suggest commenting out the constraints in the backup file before running the restore. regards andreas ALEXANDER JOSE wrote: psql coon I'm trying to restore a database that has 60 GB in size, wher

[ADMIN] Exception while accessing database

2010-06-02 Thread Manohar Bhattarai
Hi, This problem was initially asked to pgsql-j...@postgresql.org and I was suggested to ask this problem here. So my initial problem was that i was not able to set the Driver for postgresql. I solved that problem with the help there. But I have a new exception and it is : org.postgresql.util.PSQL

[ADMIN] pitrtools package wrong dependency (binary packages)

2010-06-02 Thread DANIEL CRISTIAN CRUZ
Hi all, I was trying to setup a test environment with PostgreSQL 8.2 + Heartbeat + pitrtools, but the package in http://yum.pgsqlrpms.org/8.2/redhat/rhel-5Server-x86_64/pitrtools-1.2-3.rhel5.noarch.rpm seems to have a wrong dependency (postgresql-server >= 8.3). Is it correct? Does someone k

Re: [ADMIN] Firebird To postgresql migration help needed

2010-06-02 Thread Lew
Scott Marlowe wrote: I use nano or vi for most stuff. Both can do color coding quite nicely for .sql files. mnavahan wrote: i [sic] need powerful IDE for it with modernize options (extended editor) rich good Scott Marlowe wrote: Got me. Maybe eclipse has a nice plugin? I find both

[ADMIN] FATAL: pg_hba.conf ::1

2010-06-02 Thread Fredy Ganga (GMAIL ACCOUNT)
Hello: I have been testing streaming replication on postgresql 9, and now i have this messages in pg_log on salve. pg_log: 2010-06-01 09:13:58 CLT LOG: el sistema de bases de datos fue interrumpido; última vez en funcionamiento en 2010-06-01 09:00:17 CLT 2010-06-01 09:13:58 CLT LOG: entering s

[ADMIN] Installing PostgreSQL

2010-06-02 Thread Daniel, Clyde D (Derrick)
Good Afternoon, I am trying to install PostgreSQL on my desktop and it is asking for a password. Everything I type in is not working it gives me this error: Any help would be greatly appreciated. Thanks <>

[ADMIN] Modificar tamaño de pg_xlog

2010-06-02 Thread mario martinez hernandez
Buenas tardes. Mi nombre es Mariano. Mi pregunta es. ¿ Es posible modificar el tamaño de pg_xlog? ¿como? ¿donde? Gracias Un saludo.

Re: [ADMIN] Installing PostgreSQL

2010-06-02 Thread Scott Marlowe
On Tue, Jun 1, 2010 at 10:01 AM, Daniel, Clyde D (Derrick) wrote: > > Good Afternoon, > > > >     I am trying to install PostgreSQL on my desktop and it is > asking for a password.  Everything I type in is not working . Try a really complex password like: azxygrh123DF$%yhn etc. nu

Re: [ADMIN] FATAL: pg_hba.conf ::1

2010-06-02 Thread Scott Marlowe
On Tue, Jun 1, 2010 at 7:55 AM, Fredy Ganga (GMAIL ACCOUNT) wrote: > Hello: > > I have been testing streaming replication on postgresql 9, and now i have > this messages in pg_log on salve. > pg_log: > 2010-06-01 09:13:58 CLT LOG:  el sistema de bases de datos fue interrumpido; > última vez en fun

Re: [ADMIN] Exception while accessing database

2010-06-02 Thread Kevin Grittner
Manohar Bhattarai wrote: > FATAL: password authentication failed for user "postgres" > But the password is the same that i use to login postgres user in > the terminal. > What could be the problem? When you say "postgres user in the terminal", do you mean logging in to the operating system?

Re: [ADMIN] pitrtools package wrong dependency (binary packages)

2010-06-02 Thread Lacey Powers
DANIEL CRISTIAN CRUZ wrote: Hi all, I was trying to setup a test environment with PostgreSQL 8.2 + Heartbeat + pitrtools, but the package in http://yum.pgsqlrpms.org/8.2/redhat/rhel-5Server-x86_64/pitrtools-1.2-3.rhel5.noarch.rpm seems to have a wrong dependency (postgresql-server >= 8.3).

[ADMIN] Strange performance issue apparently causd by pg_stat timeout

2010-06-02 Thread Benjamin Krajmalnik
System is running PG 8.4.0 (I have been unable to upgrade because the system needs to be up 24x7), FreeBSD 7.2 amd64, 8 cores, 16GB RAM. Our application is a network monitoring system, so we are constantly inserting vast amounts of data (server presently processes about 50 million transactions per

Re: [ADMIN] pitrtools package wrong dependency (binary packages)

2010-06-02 Thread Devrim GÜNDÜZ
On Wed, 2010-06-02 at 16:03 -0300, DANIEL CRISTIAN CRUZ wrote: > I was trying to setup a test environment with PostgreSQL 8.2 + > Heartbeat + > pitrtools, but the package in > http://yum.pgsqlrpms.org/8.2/redhat/rhel-5Server-x86_64/pitrtools-1.2-3.rhel5.noarch.rpm > > seems to have a wrong depe

Re: [ADMIN] Restore DataBase

2010-06-02 Thread Eric McKeeth
On Tue, Jun 1, 2010 at 9:26 PM, ALEXANDER JOSE wrote: > psql coon I'm trying to restore a database that has 60 GB in size, where > there is a table with 38 million records, has raised 18 million records when > the restore process fails on a syntax error, the backup was made with a > file. sql a

[ADMIN] graceful reload

2010-06-02 Thread Vasiliy G Tolstov
Hello. I'm use linux and postgresql under xen vps. Vps supports memory balloon (i need to increase memory some time). Can postgresql server has ability to graceful reload itself after it configuration files changed? Thank You. -- Vasiliy G Tolstov Selfip.Ru -- Sent via pgsql-admin mailing li