Hi, thank you for your response.
But does this mean, that only WinXP is no supported or doesn't it work at all?
I would need it on a Windows2003Server???
Best regards,
murphy
-Ursprüngliche Nachricht-
Von: Fujii Masao [mailto:masao.fu...@gmail.com]
Gesendet: Montag, 26. Oktober 2009 0
I thing he is writing about the database objects estructure too. You can avoid
users to access data from a schema, but you cant avoid they to access objects
structure. As example you will see, on a table, its columns but not its data.
Sergio Tito
- Original Message -
From: Scott Mea
Tom Lane wrote:
> What about the other direction: the script invoked by the archive
> returns "done" before the bits have all been shipped?
Do you mean the wal_archive_command? It waits for scp to finish.
It's written in Perl; here is the relevant part.
Regards,
David.
[Stuff deleted...]
my
Hello sir/madam
please let me know procedure of intracting b/w two databases with in
cluster even though i give grant permission on schema to other database it
is not working.
thank you in advance
--
Thanks®ards
sateesh kumar.pathivada
CONTACT NO:9885607011
On Tue, 2009-10-27 at 17:04 +0530, sateesh kumar wrote:
> Hello sir/madam
>
>
> please let me know procedure of intracting b/w two databases with in
> cluster even though i give grant permission on schema to other
> database it is not working.
>
You can't do it directly. Have a look at dblink
Hi,
In an effort to track down the problem, I switched to using rsync rather
than scp to copy the files. I also take the SHA1 hash on each end, and
have my archiving script exit with a non-zero status if there's a mismatch.
Sure enough:
Oct 27 14:26:35 colo2vs1 canit-failover-wal-archive[29118]:
"David F. Skoll" wrote:
> (My script exits with non-zero status if the SHA1s mismatch, and
> PostgreSQL re-archives the WAL a short time later, and that
> succeeds, so I'm happy for now.)
Just out of curiosity, could you show us the non-comment portions of
your postgresql.conf file?
-Kevin
Kevin Grittner wrote:
> Just out of curiosity, could you show us the non-comment portions of
> your postgresql.conf file?
Sure! Here they are.
Regards,
David.
=
data_directory = '/var/lib/postgresql/8.3/main'
hba_file
"David F. Skoll" writes:
> Sure enough:
> Oct 27 14:26:35 colo2vs1 canit-failover-wal-archive[29118]:
> Warning: rsync succeeded, but local_sha1
> 1fe9fc62b2a05d21530decac1c5442969adc5819
> != remote_sha1 4f9f8bcd151129db64acd05470f0f05954b56232 !!
> This is a "can't happen" situation, so I hav
Tom Lane wrote:
> So, when it archives successfully the second time, which if either of
> the two mismatched sha1's proves to have been correct?
The one on the master server (lines wrapped for readability).
"local" refers to the master server, and "remote" to the standby
server.
Oct 27 14:26:35
"David F. Skoll" wrote:
> shared_buffers = 24MB
You should probably set that higher. Different workloads favor
different settings, but if you've got any reasonable amount of RAM for
a modern machine, somewhere between 256MB and one-third of total RAM
is usually best.
> archive_command = '/u
Kevin Grittner wrote:
>> shared_buffers = 24MB
> You should probably set that higher.
Nah. This machine is totally bored; tweaking PostgreSQL would be pointless
since it's so under-utilized.
>> archive_command = '/usr/bin/wal_archive_command.pl %p'
> It would probably be safer to pass in %f, t
"David F. Skoll" writes:
> Tom Lane wrote:
>> So, when it archives successfully the second time, which if either of
>> the two mismatched sha1's proves to have been correct?
> The one on the master server (lines wrapped for readability).
> However, the sha1 is taken after rsync exits, so it's unk
Hi,
On Tue, Oct 27, 2009 at 4:53 PM, Andreas Schmidt wrote:
> Hi, thank you for your response.
> But does this mean, that only WinXP is no supported or doesn't it work at
> all? I would need it on a Windows2003Server???
According to the previous post, pg_standby in v8.3.7 would work file.
How a
14 matches
Mail list logo
