As others have already said, use the newer
version of pg_dump and it should go ok.
I had lots of problems restoring 7.1 dumps
into 7.4 database, but it goes smoothly if I use the 7.4 version of
pg_dump.
Assuming you have 2 servers, the old one
and a new one, call pg_dump from your new se
Hi Sarlav,
From what I understand, I need to execute the pg_dump command from the
new server( so that it will use the 7.4.6 version), but connect to the
old DB. Am I right?
Basically.
The truth is Sarlav, that any pg_dump version before the new 8.0 version
is likely to have errors restoring. Y
Title: RE: [PERFORM] PG Logging is Slow
Thankyou Alexander,
That has worked and appears to have fixed the issue with syslog.
Theo
-Original Message-
From: Alexander Borkowski [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 21 December 2004 10:09 AM
To: Theo Galanakis
Cc: '[EMA
Starting from 7.4.1 on P4 and FreeBSD 5.x (exclude 5.0 - gcc in this
edition have optimization error)
I use next configure command
--
./configure --prefix=/opt/postgres-7.4.1 --with-pgport=5432
--with-pam --enable-syslog --enable-depend
Any advice for settings for extremely IO constrained systems?
A demo I've set up for sales seems to be spending much of it's time in
disk wait states.
The particular system I'm working with is:
Ext3 on Debian inside Microsoft VirtualPC on NTFS
on WindowsXP on laptops of our sales team.
Some
Thank you for your attention.
I will try again with new postgres release and
examine access method of sql with explain command.
kondo
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I have recently transfered a big database on my master node of a 4 node openSSI Cluster... The system is working fine but sometimes, I get following errors:
http://192.168.1.100/cgi-bin/search.py
File "/usr/lib/python2.2/site-packages/pyPgSQL/PgSQL.py", line 3067, in execute, referer: http://19
[EMAIL PROTECTED] writes:
> I tried performance test of version 8.0.0 beta4 by osdl-dbt-1.
> The result is that throughput of version 8 fell to about 70 percent
> compared with V7.4.6.
beta4 is a little bit back ...
I don't have dbt1 at hand, but I tried pg_bench on PG 7.4.6 against 8.0rc2
just
(BHello.
(BI tried performance test of version 8.0.0 beta4 by osdl-dbt-1.
(BThe result is that throughput of version 8 fell to about 70 percent
(Bcompared with V7.4.6.
(BTest result is below. (measurement was repeated 3 times)
(B
(B---
Theo,
> I tried the -/var/log/postgresql.log option however I noticed no
> performance improvement. May be the fact that we use redhad linux and
> syslog, I'm no sys-admin, so I'm not sure if there is a difference
between
> syslogd and syslog.
Did you restart syslogd (that's the server process i
Title: RE: [PERFORM] PG Logging is Slow
Thank-you Grega,
I ended up using the pg_ctl -l parameter to write the output to a specified file. Much quicker to do so.
I tried the -/var/log/postgresql.log option however I noticed no performance improvement. May be the fact that w
Hi All,
I installed slony1.0.5 and tried the example replication of pgbench database. That seemed to work. Now I need to replicate a DB running on a different server. slony1.0.5 is installed on the Fedora core 3 machine where Postgres 7.4.6 is installed. I have to replicate the 'test' database in
On Fri, 17 Dec 2004 23:37:37 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Frank Wiles <[EMAIL PROTECTED]> writes:
> > I've also seen a huge difference between select count(*) and
> > select count(1) in older versions,
>
> That must have been before my time, ie, pre-6.4 or so. There is
> cert
Hi,
I think I miscommunicated something. I am doing a pg_dump from Postgres 7.3.2. I am restoring it on Postgres 7.4.6 on Fedora Core 3 on a different server.
I tried doing the dump and restoring it on the new DB. I did not have any problem with the UNIQUE contraint so far. But I got an error
Hi,
From what I understand, I need to execute the pg_dump command from the new server( so that it will use the 7.4.6 version), but connect to the old DB. Am I right?
Thanks,
SaranyaBruno Wolff III <[EMAIL PROTECTED]> wrote:
On Mon, Dec 20, 2004 at 06:40:34 -0800,sarlav kumar <[EMAIL PROTECTED]>
sarlav kumar wrote, On 2004-12-20 15:40:
> I would like to do a pg_dump on the test database, and restore it in
> the new database on Postgres 7.4.6. I would like to know if there
> would be any problem due to the postgres version/OS change. If so,
> could someone tell me what precautions I can tak
On Mon, Dec 20, 2004 at 06:40:34 -0800,
sarlav kumar <[EMAIL PROTECTED]> wrote:
>
> I would like to do a pg_dump on the test database, and restore it in the new
> database on Postgres 7.4.6. I would like to know if there would be any
> problem due to the postgres version/OS change. If so, cou
Hi All,
Thanks to everyone for helping with my previous questions.
I have a test database running on Postgres 7.3.2.
version - PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96
I have another ser
On Mon, Dec 20, 2004 at 03:17:11PM +1100, Theo Galanakis wrote:
> Under postgres 7.3 logging is incredibly slow!
>
> I have applied the following settings:
>
> syslog = 2
> syslog_facility = 'LOCAL0'
> syslog_ident = 'postgres'
>
> log_connections = true
> log_duration = true
> log_pid =
19 matches
Mail list logo
