I have postgres *(PostgreSQL) 9.0.3 running.*
I also created several procedures/functions and now I don't remember the
last procedure I worked on! - I thought I could always get this from
metadata.
Now I'm stuck - couldn't find this details anywhere in catalog tables!
Is there anyway I can get th
I bundle Postgres (8.3.15) with another product as a back-end database. On
Windows, the default build includes a bunch of what appear to be codec
libraries, with names like, utf8_and_cyrillic.dll, ascii_and_mic.dll, etc.
But using Microsoft's dependency walker tool, I see no references to any
of
Hi,
Today I tried to promote a slave as master using rsync --checksum (without
doing vacuum freeze) instead of rsync --all.
It takes only 30 minutes with rsync --checksum. Only a few tables are
rsynced. Most of the time is consumed by checksum.
With rsync --all, it takes 1h40 min.
So, rsync --c
Jean-Armel Luce wrote:
> So, rsync --checksum looks better than rsync --all
I've never heard of an --all option for rsync. What does that do?
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/p
On Nov 16, 2011, at 9:37 AM, Jean-Armel Luce wrote:
> So, rsync --checksum looks better than rsync --all
--all??? What the heck is that and why were you using it?
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing li
2011/11/16 Jean-Armel Luce :
> Hi,
>
> Today I tried to promote a slave as master using rsync --checksum (without
> doing vacuum freeze) instead of rsync --all.
>
> It takes only 30 minutes with rsync --checksum. Only a few tables are
> rsynced. Most of the time is consumed by checksum.
> With rsy
You are right. I used -a, and I was wanting to be more meaningful so I
wrote --all in my post.
Please read --archive insterad of --all
I kept --recursive.
I didn't use --owner , --group, --perms (permissions, group and owner are
the same on each side).
I rsynced all the directory (without /*) as S
On Nov 16, 2011, at 10:11 AM, Jean-Armel Luce wrote:
> You are right. I used -a, and I was wanting to be more meaningful so I wrote
> --all in my post.
> Please read --archive insterad of --all
Oh, OK. Still seems odd that it took so much longer. Granted, for the files
with different timestamps
2011/11/16 Scott Ribe :
> On Nov 16, 2011, at 10:11 AM, Jean-Armel Luce wrote:
>
>> You are right. I used -a, and I was wanting to be more meaningful so I wrote
>> --all in my post.
>> Please read --archive insterad of --all
>
> Oh, OK. Still seems odd that it took so much longer. Granted, for the
David Schnur writes:
> I bundle Postgres (8.3.15) with another product as a back-end database. On
> Windows, the default build includes a bunch of what appear to be codec
> libraries, with names like, utf8_and_cyrillic.dll, ascii_and_mic.dll, etc.
> But using Microsoft's dependency walker tool,
On 11/17/2011 12:04 AM, David Schnur wrote:
I bundle Postgres (8.3.15) with another product as a back-end database.
On Windows, the default build includes a bunch of what appear to be
codec libraries, with names like,
utf8_and_cyrillic.dll, ascii_and_mic.dll, etc. But using Microsoft's
depende
11 matches
Mail list logo