[ADMIN] How could I find the last modified procedure in the database?

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

[ADMIN] How and when are encoding DLLs used on Windows?

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

Re: [ADMIN] rsync and streaming replication

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

Re: [ADMIN] rsync and streaming replication

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

Re: [ADMIN] rsync and streaming replication

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

Re: [ADMIN] rsync and streaming replication

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

Re: [ADMIN] rsync and streaming replication

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

Re: [ADMIN] rsync and streaming replication

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

Re: [ADMIN] rsync and streaming replication

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

Re: [ADMIN] How and when are encoding DLLs used on Windows?

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,

Re: [ADMIN] How and when are encoding DLLs used on Windows?

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