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
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
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
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
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
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
<>
Buenas tardes.
Mi nombre es Mariano.
Mi pregunta es.
¿ Es posible modificar el tamaño de pg_xlog? ¿como? ¿donde?
Gracias
Un saludo.
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
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
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?
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).
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
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
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
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
15 matches
Mail list logo