Dear all,
I have a server running 8.2.4 and has a database 170GB in size.
Currently I am backing it up using pg_dump and it takes around 28 hours, sadly.
I was asked to check and compare the newly created DUMP file to the live
database and compare records.
I personally cannot see an easy or quic
Le 11/02/2010 à 20:39:30-0300, Alvaro Herrera a écrit
> Albert Shih wrote:
> > Le 11/02/2010 à 17:00:33-0600, Kevin Grittner a écrit
> > > Albert Shih wrote:
> > >
> > > > I would like to known what's best way to manage the WAL.
> > >
> > > You should design a policy which meets your particu
On Feb 12, 2010, at 4:58 AM, Renato Oliveira wrote:
> Dear all,
>
> I have a server running 8.2.4 and has a database 170GB in size.
> Currently I am backing it up using pg_dump and it takes around 28 hours,
> sadly.
That's suspiciously slow for a pg_dump alone. I have a ~168 GB database which
Josh,
That is great thank you very much
I really appreciate your reply
Thank you
Renato
Renato Oliveira
Systems Administrator
e-mail: renato.olive...@grant.co.uk
Tel: +44 (0)1763 260811
Fax: +44 (0)1763 262410
http://www.grant.co.uk/
Grant Instruments (Cambridge) Ltd
Company registered in
On Tue, Feb 09, 2010 at 05:39:52PM -0500, Ray Stell wrote:
> On Sat, Jan 30, 2010 at 09:59:36AM -0500, Ray Stell wrote:
>
> Is autovacuum handing all users off to vacuum all rels? Even those
> it does not own? Perhaps "admin" an unfortunate usename choice?
doh...the light comes on.
reading th
Hi,
We recently upgraded to 8.3.9 (from 8.3.6) because we were having the issue
described in the fix below. Our postgres user and other domain users with pam
authentication were getting locked out, in accords with our group domain policy
10 failed login attemps in 30 minutes. I included some
So far, we have only migratated 1 of 3 linux/postgresql servers from using
openldap to now using active directory. We'd like to move the other 2 to
production, once we solve this issue. It's a random issue. Some domain users
don't have the problem of getting locked out and some do, even t
Backing up a 170GB in 28 hours definitely doesn't sound right and I
almost certain has nothing to do with pg_dump, but rather your hardware,
ie, server, disk, etc. with a 170GB, backup should be done in a couple
of hours in my opinion. Seems to be more like a system resource issue.
Regards,
Hi All,
I am not able to figure out how to change the logging to a single line,
*My log file out puts*
LOG: duration: 0.492 ms
LOG: duration: 0.397 ms
LOG: duration: 0.097 ms
LOG: execute : select count(*) from v_mthly_demo_rollup
LOG: duration: 211.724 ms
LOG: duration: 0.499 ms
LOG: dur
Did you issue the reload command using pg_ctl after editing your
postgresql.conf, to tell the server to pick up the changes?
If you issue the following within a psql session, it will tell you what
config value the server is currently using:
show log_line_prefix;
Looks like either you
Thank you for your answer.
I had made a mistake in my postgresql.conf having 2 entries for
log_line_prefix one with log_line_prefix =
'%t|%u|%d|%r|%p|%m|%i|%c|%l|%s|%x'
and another log_line_prefix = '' (end of the file)
Its working now..
thanks
Deepak
On Fri, Feb 12, 2010 at 12:53 PM, Lewis Kap
Creo que tienes un probelma de conceptos. No creo que ese tipo se llame asi
pero de todas formas si es binario con bytea seria el equivalente. Que se
actualiza ahi ? Es decir, q tipo de informacion almacena?
MS-SQL 7 , cual es esa version? COnocia la 6.5 , 2000 , 2005 y 2008 , donde
enttro es
2010/2/12 Edwin Quijada :
> MS-SQL 7 , cual es esa version? COnocia la 6.5 , 2000 , 2005 y 2008 , donde
> enttro esa?
http://en.wikipedia.org/wiki/Microsoft_SQL_Server#History
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postg
13 matches
Mail list logo