I tried to use only %p to specify the path, but it does not seem to output the
full path according to the server log. It only starts at /pg_xlog:
archive_command = '/usr/bin/scp -B "%p"
postgres@172.20.204.55:/Volumes/DataDrive/wals_from_master/%f'
DETAIL: The failed archive co
I'm trying to setup wal archiving to a secondary computer on OSX 10.6.5 using
postgres 9.0.3.
Here are my settings in postgresql.conf on the primary box:
wal_level = archive
archive_mode = on
max_wal_senders = 1
archive_command = '/usr/bin/scp -B /Volumes/DataDrive/data/%p
postgres@172.20.204.5
I'm trying to setup wal archiving to a secondary computer on OSX 10.6.5 using
postgres 9.0.3.
Here are my settings in postgresql.conf on the primary box:
wal_level = archive
archive_mode = on
max_wal_senders = 1
archive_command = '/usr/bin/scp -B /Volumes/DataDrive/data/%p
postgres@172.20.204.5
Hi,Development is Mac OS 10.4.0 (PPC). Production is Mac OS 10.4.7 (Intel). Is that the kicker... PPC vs Intel?On Aug 8, 2006, at 1:46 PM, Talha Khan wrote:Hey Joe!! Which OS are you running on development server and production server?? regards Talha Khan On 8/8/06, Joe Lester <[EMAIL PROTEC
I'm having a little trouble restoring a backup (from the production
server to our development server).
I recently updated both production and development servers to
postgres 8.1.4 from 8.0.x. When I updated production, I did a fresh
initdb and imported from a previous dump. This server is r
ck would help any in this circumstance... and I don't want
to resort to table locks for performance reasons.
On Nov 8, 2005, at 10:14 AM, Tom Lane wrote:
Joe Lester <[EMAIL PROTECTED]> writes:
In my custom postgres client app I'd like to be able to determine if
another user is &
Is there a recommended "postgres way" to determine if a certain row is
locked... without blocking?
In my custom postgres client app I'd like to be able to determine if
another user is "modifying" a given record. If so, I would present a
dialog to the user such as "Record Locked. Sam Smith is a
http://archives.postgresql.org/pgsql-general/2004-08/msg00972.php
This bug appears to be fixed in Tiger (Mac OS 10.4). That's great, if
it's really true. Can anyone confirm?
---(end of broadcast)---
TIP 7: don't forget to increase your free space m
Watch out for the memory leak bug on OS 10.3.2 though 10.3.5 (this is
apparently an OS X bug, not a Postgres bug):
http://archives.postgresql.org/pgsql-general/2004-08/msg00972.php
I don't know if it exists on 10.3.6 or 10.3.7 (the current version). I
submitted a bug report to Apple many months
I'm just moved my Postgres client project from Mac 10.2.8 to 10.3.5.
It's an Objective-C program that links to libpq.a (the header file is
libpq-fe.h). However, when I try to compile now I get the following
linking error:
ld: Undefined symbols: _poll
Does this sound familiar to anyone? My guess
On Aug 20, 2004, at 3:01 PM, Bill Moran wrote:
Please don't wrap machine-generated output ... it makes it VERY
difficult
to understand.
This is usually caused by a setting in your mail client that reads
something like "wrap lines at 72 characters" being turned on.
You should wrap your text at 72 c
On Aug 20, 2004, at 2:43 PM, Tom Lane wrote:
Bill Moran <[EMAIL PROTECTED]> writes:
Joe Lester <[EMAIL PROTECTED]> wrote:
I'm wondering, however, if you have a connection leak instead. i.e.
is it possible that your client application is opening a whole bunch
of connections and n
On Aug 20, 2004, at 2:28 PM, Tom Lane wrote:
I think what you've found is an OS X bug.
I was able to replicate this behavior on OS X 10.3.5. All I did was
start the postmaster and then start a continuous loop in a shell
window:
while true
do
psql -c "select count(*) from tenk1" regression
do
Thanks for the suggestion Scott. I did a...
find / -type f -size +10 -print
The results contained 9 Gig! of swap files:
/private/var/vm/swapfile0
/private/var/vm/swapfile1
/private/var/vm/swapfile10
[plus many more entries]
That seems to indicate to me a memory "leak" of some sort. My s
That makes sense since the "connection reset by peer" statement is
always followed immediately by
"unexpected EOF on client connection"
I should have noticed that before :-0
Thanks!
On Apr 20, 2004, at 10:04 PM, Doug McNaught wrote:
Joe Lester <[EMAIL PROTECTED]>
Yeah. It was my shell that was the bottleneck. What did the trick was
adding this line in /etc/profile:
ulimit -n 8000
Thanks!
Bruno Wolff III <[EMAIL PROTECTED]> writes:
It sounds like what is really happening is that
you are hitting an OS limit on the number of open files. You should be
able
I'm trying to figure out what the optimal Postgres configuration would be for my server (with 200 connecting clients, even though I'd really like to get it up to 500).
I've got a 700 MHz eMac running Mac OS 10.3.2 (Panther) with 512 MB of RAM. I've messed around with some settings but I'm still ge
Would anyone have some example code they could share using libpq to
encode an image into a text field? Right now, I'm converting my image
into a hexadecimal string representation in my SQL statement. I'm sure
there must be a better (faster) way. The hex encodeing/decoding slows
things down for
Thanks. I was kind of suspecting that. But it's nice to have it
confirmed.
I might try a random delay on the client side after receiving the
notification, before I query. That may help to break up the load on the
server.
On Feb 16, 2004, at 10:27 AM, Mikhail Terekhov wrote:
I'd say it is relat
Yes, my client receives the notification and then it immediately
executes a query that hangs for a while.
On Feb 15, 2004, at 12:07 PM, Tom Lane wrote:
Hmm. Are you certain that the clients have received the NOTIFY?
Perhaps the bottleneck is in delivering the NOTIFY messages, not in
executing th
I'm using PostgreSQL 7.4.1. I have 140 clients connected on average
using libpq. When one client sends "NOTIFY timeclock;" to the server
all 140 clients are listening for it.
After receiving a notification from libpq (PQnotifies), each client
proceeds to execute a query for the last five record
Would this be kern.maxfiles? There's also one called
kern.maxfilesperproc.
Is it OK to set these before starting the server? Or should I set them
in /etc/rc?
On Feb 10, 2004, at 10:04 AM, Tom Lane wrote:
Also look at increasing the kernel's limit on number of open files
(I remember seeing it i
Joe Lester <[EMAIL PROTECTED]> writes:
That's odd. It's giving me a -1 for the shmmax value. I assume that's
NOT normal. Why would that be?
It's not --- you should get back the same value you set. I speculate
that you tried to set a value that exceeded some internal
Joe Lester <[EMAIL PROTECTED]> writes:
I installed Postgres 7.4.1 on a dual processor G5 running Mac OS
10.3.2. I'm trying to increase the max_connections to 300 and running
into some trouble.
Hmm, it WorksForMe (TM). You did reboot after changing /etc/rc, no?
Yes, I did a "Restar
24 matches
Mail list logo
