Adrian Klaver wrote:
On Wednesday, August 10, 2011 11:47:25 am Geoffrey Myers wrote:
Is max connections in any table in the database I can access?
SELECT current_setting('max_connections');
current_setting
-
100
Thanks for all the responses folks. Obviously, there's
Greg Smith wrote:
On 08/10/2011 02:46 PM, Geoffrey Myers wrote:
Is the max connections value in a system table somewhere?
If you intend to do anything with the value you probably want one of
these forms:
SELECT CAST(current_setting('max_connections') AS integer);
SELECT CAST(setting
Is max connections in any table in the database I can access?
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql-general mailing
Is the max connections value in a system table somewhere?
Thanks.
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Scott Marlowe wrote:
On Wed, Aug 10, 2011 at 12:47 PM, Geoffrey Myers
li...@serioustechnology.com wrote:
Is max connections in any table in the database I can access?
No it's in the postgresql.conf file, which is in various places
depending on how pg was installed. for debian / ubuntu it's
Am I correct in assuming that the 'running out of oids' issue was
resolved with a design change within Postgresql?
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them
Merlin Moncure wrote:
On Wed, Aug 3, 2011 at 2:41 PM, Geoffrey Myers
li...@serioustechnology.com wrote:
Am I correct in assuming that the 'running out of oids' issue was resolved
with a design change within Postgresql?
not exactly -- for quite some time now the use of oids in user tables
has
Alban Hertroys wrote:
On 3 Jul 2011, at 12:00, Geoffrey Myers wrote:
We have a process that we successfully ran on virtually identical
databases. The process completed fine on a machine with 8 gig of
memory. The process fails when run on another machine that has 16
gig of memory
Craig Ringer wrote:
On 3/07/2011 6:00 PM, Geoffrey Myers wrote:
out of memory for query result
How is this possible?
Resource limits?
Could this message be generated because of shared memory issues?
The odd thing is the error was generated by a user process, but there is
no reference
One other note, there is no error in the postgres log for this database.
I would have expected to find an error there.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care
Geoffrey Myers wrote:
We have a process that we successfully ran on virtually identical
databases. The process completed fine on a machine with 8 gig of
memory. The process fails when run on another machine that has 16 gig
of memory with the following error:
out of memory for query result
Craig Ringer wrote:
On 3/07/2011 6:00 PM, Geoffrey Myers wrote:
out of memory for query result
How is this possible?
Resource limits?
Could this message be generated because of shared memory issues?
The odd thing is the error was generated by a user process, but there is
no reference
Tom Lane wrote:
Geoffrey Myers g...@serioustechnology.com writes:
Geoffrey Myers wrote:
out of memory for query result
One other note that is bothering me. There is no reference in the log
regarding the out of memory error. Should that not also show up in the
associated database log
space.
Any clues would be appreciated.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general
the
same character in multiple records using regex_replace() ?
In reality, we are trying to change characters like the 1/2 character to
the three characters '1/2'.
Thanks for any assistance.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from
I'm relatively new to postgres. I've got a Visual Basic (VB)
application that i would like to connect to a Postgres database using
ODBC . Both the VB application and postgres are on my laptop and both
work beautifully independent of each other. Trouble is, I have a
windows 7 64bit OS and
I'm relatively new to postgres. I've got a Visual Basic (VB)
application that i would like to connect to a Postgres database using
ODBC . Both the VB application and postgres are on my laptop and both
work beautifully independent of each other. Trouble is, I have a
windows 7 64bit OS and
Jasen Betts wrote:
On 2011-04-22, Geoffrey Myers g...@serioustechnology.com wrote:
Vick Khera wrote:
On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers
li...@serioustechnology.com mailto:li...@serioustechnology.com wrote:
Here's our problem. We planned on moving databases a few at a time
mentioned above, the process fails.
So, now the question is, is this effort even worth our effort?
What is the harm in leaving our databases SQL_ASCII encoded?
Thanks for any insights.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from
Vick Khera wrote:
On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers
li...@serioustechnology.com mailto:li...@serioustechnology.com wrote:
Here's our problem. We planned on moving databases a few at a time.
Problem is, there is a process that pushes data from one database to
another
pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence
for encoding UTF8: 0xbd
As I see it, the perl code above should catch this '0xbd' character, but
somehow it is finding it's way through.
Any insights would be greatly appreciated.
--
Until later, Geoffrey
I predict future
Tom Lane wrote:
Geoffrey Myers li...@serioustechnology.com writes:
So we are in the process of converting our databases from SQL_ASCII to
UTF8. If a particular row won't import because of the encoding issue we
get an error like:
pg_restore: [archiver (db)] Error from TOC entry 5317; 0
that line.
Is there a way to view that data line without converting this dump to a
text dump?
All I'd like to do is know which column in the table caused the problem
so I could apply my fix to that particular column.
--
Until later, Geoffrey
I predict future happiness for America if they can
about some sort of wal log shipping replication?
WAL Log shipping won't help.
Thanks Regards,
Vibhor Kumar
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
-
iEYEAREDAAYFAk1iy74ACgkQvJuQZxSWSsgWQACgrxKDvN/yCZD5GZJvlqFMyyIC
9mwAnjOMJ9QDRa3IoiBCvaS9mT5sMR6f
=JYCs
-END PGP SIGNATURE-
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care
-
iEYEAREDAAYFAk1ew9MACgkQvJuQZxSWSshETwCg2oEEicHhokORuQRl3sxkLkpj
ghIAnRe02LCuyyRlyzvKZ67QCYUyfPzC
=H9Wb
-END PGP SIGNATURE-
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense
-
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
-
iEYEAREDAAYFAk1d360ACgkQvJuQZxSWSsidCQCfTnQxp5w6psa3C9NREX0ecZ+j
Ft0An2JKofuxVJNwxhVkh4NBTJU3Xcom
=fLDa
-END PGP SIGNATURE-
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas
+nzZz26xQ7c70Bxl5Hs3
AuUAn1uD7MY2BtGR7usl45pC3Yv2pqVS
=mLCm
-END PGP SIGNATURE-
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql
;
I'm still getting the errors. If it doesn't belong at the beginning of
this process, I'm not exactly sure where it should go.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking
-
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
using pg_restore all the data is loaded into all tables BEFORE any
constraints are created. I believe that if you did a data-only dump from
pg_dump you would have the same integrity problems.
Yes.
A
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
SIGNATURE-
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
-
iEYEAREDAAYFAk1diwUACgkQvJuQZxSWSshcPgCdGuHIe4bINl/BmoKW89YmQscD
IdAAnA8bwbzmMKssCga9G0dpSh1GopzD
=khQx
-END PGP SIGNATURE-
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
block
ROLLBACK
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
-
iEYEAREDAAYFAk1dpvQACgkQvJuQZxSWSsjvrgCgmiITSLnGyrBunVZTScc4HKvz
Y3IAn1sYG4/BdM6XJpBAVMz6lU1WfUVH
=XZcQ
-END PGP SIGNATURE-
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-
iEYEAREDAAYFAk1diwUACgkQvJuQZxSWSshcPgCdGuHIe4bINl/BmoKW89YmQscD
IdAAnA8bwbzmMKssCga9G0dpSh1GopzD
=khQx
-END PGP SIGNATURE-
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing
the data integrity issue.
Is there a way to resolve this issue with the psql loading approach?
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
to decimal values at
http://www.asciitable.com/
while ()
{
$_ =~ s/(.)/((ord($1) = 0) (ord($1) = 8))
|| ((ord($1) = 11) (ord($1) = 31))
|| ((ord($1) = 127)) ?: $1/egs;
print;
}
comments would be appreciated.
--
Until later, Geoffrey
I predict future happiness
Vick Khera wrote:
On Tue, Feb 15, 2011 at 11:09 AM, Geoffrey Myers
li...@serioustechnology.com wrote:
comments would be appreciated.
If all you're doing is filtering stdin to stdout and deleting a range
of characters, it seems that tr would be a faster tool:
cat foo.txt | tr -d '\000-\008
I am trying to write a plsql routine that will delete a range of
characters based on their octal or hexadecimal values. Something like
the 'tr' shell command will do:
cat file| tr -d ['\177'-'\377']
Can't seem to figure this one out.
Pointers would be appreciated.
--
Until later, Geoffrey
Is there a way to search for a character in the database by the
hexidecimal value of that character?
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas
is controlled by
client_encoding.
CONTEXT: COPY cust, line 778
Is there any easy way to figure out which record caused this error?
Thanks.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking
' is your hexadecimal character value.
Be sure to read and understand everything you can find about encodings;
and make sure the hexadecimal value you are searching for is from the
same encoding.
Best wishes,
Harald
On Mon, Jan 24, 2011 at 16:00, Geoffrey Myers
li...@serioustechnology.com
Adrian Klaver wrote:
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
We need to change the database encoding on our databases as they were
created with the wrong encoding. They were created as SQL_ASCII and we
are changing them to UTF8.
When testing this Friday, I received
Adrian Klaver wrote:
On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote:
Adrian Klaver wrote:
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
We need to change the database encoding on our databases as they were
created with the wrong encoding. They were created
Adrian Klaver wrote:
On Monday 24 January 2011 8:06:38 am Geoffrey Myers wrote:
Adrian Klaver wrote:
On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote:
Adrian Klaver wrote:
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
We need to change the database encoding on our
Adrian Klaver wrote:
On 01/24/2011 09:16 AM, Geoffrey Myers wrote:
We hope to identify the characters and fix them in the existing
database, then convert. It appears to be very limited, but it would help
if there was some way to identify these characters outside of simply
doing the reload
, Geoffrey
Sent from my iPhone
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Patience is my friend. No transactions so no archiving. Waiting long enough
produced results. Sorry for the noise.
--
Later, Geoffrey
Sent from my iPhone
On Dec 27, 2010, at 3:18 PM, Geoffrey Myers li...@serioustechnology.com wrote:
Set up wal shipping on postgresql 8.3.9 and rhel 5.5. When
hardware, where one machine is
running a 32 bit OS and the other is running a 64 bit OS?
Further:
Say 32 bit hardware and 64 bit hardware, where both are running a 32 bit OS?
Specifically speaking of RHEL.
Thanks.
--
Until later, Geoffrey
I predict future happiness for America if they can
On 10/13/2010 11:30 AM, zhong ming wu wrote:
On Wed, Oct 13, 2010 at 11:17 AM, Geoffrey Myers
li...@serioustechnology.com mailto:li...@serioustechnology.com wrote:
Excuse the ignorance, but I see the following in the docs:
'In any case the hardware architecture must be the same — shipping
Oliver Kohll
oli...@agilebase.co.uk mailto:oli...@agilebase.co.uk / +44(0)7814
828608 / skype:okohll
www.agilebase.co.uk http://www.agilebase.co.uk - software
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors
???
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
for point @ point from
ll_to_earth().
Regards
Oliver Kohll
oli...@agilebase.co.uk mailto:oli...@agilebase.co.uk / +44(0)7814
828608 / skype:okohll
www.agilebase.co.uk http://www.agilebase.co.uk - software
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
Oliver Kohll - Mailing Lists wrote:
On 22 Jul 2010, at 12:57, Geoffrey wrote:
For completeness, the earthdistance module also provides the distance
between two lat/longs, the point@point syntax is simple to use:
http://www.postgresql.org/docs/8.3/static/earthdistance.html
Disgregard my
at a different
approach? Thanks for any suggestions or RTFM pointers.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql-general
many cached connections you have, but not sure how to
properly assess this issue.
(I've tried posting to the pgpool list, but it's apparently unavailable
at this time)
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors
frequent query cancellations.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
Guillaume Lelarge wrote:
Le 02/07/2010 15:46, Geoffrey a écrit :
Tatsuo Ishii wrote:
I'm trying to get a handle on sane values for these two parameters.
I assume that they should somehow correlate to my existing
max_connections in my postgresql.conf file. Anyone using pgpool-II
care
the '-i' option be safe in this case?
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general
So running the following command:
dropdb -p 5443 swr
I get:
dropdb: could not connect to database postgres: FATAL: database
postgres does not exist
Why is it not 'seeing' the database name I'm passing to it? Why is it
trying to drop a database named postgres??
--
Until later, Geoffrey
Tom Lane wrote:
Adrian Klaver adrian.kla...@gmail.com writes:
On Tuesday 29 June 2010 1:04:27 pm Geoffrey wrote:
dropdb: could not connect to database postgres: FATAL: database
postgres does not exist
Why is it not 'seeing' the database name I'm passing to it? Why is it
trying to drop
must also own the server process.
.
.
Why is it trying to change directory to /root??? Running as the
postgres user.
Any assistance would be appreciated.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people
must also own the server process.
.
.
Why is it trying to change directory to /root??? Running as the
postgres user.
Any assistance would be appreciated.
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Tom Lane wrote:
Geoffrey li...@serioustechnology.com writes:
I wrote a script that creates a new database from an existing backup.
Works great on my machine. Another user tries to use it and sees the
following output from initdb:
could not change directory to /root
The files belonging
priority users have a
larger connection pool.
Is there a problem with using connection pooling and traditional
connections to connect to the same database?
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people
this piece of info in the docs?
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general
Gerd Koenig wrote:
Hi Geoffrey,
you do not need to connect to your database directly, just connect to pgpool
itself.
e.g.: your database runs on port 5434, pgpool runs on port 5432
=
* pgpool has to be configured in that way that it connects to the database on
port 5434
* you/your app's
Gerd Koenig wrote:
Hi Geoffrey,
you do not need to connect to your database directly, just connect to pgpool
itself.
e.g.: your database runs on port 5434, pgpool runs on port 5432
=
* pgpool has to be configured in that way that it connects to the database on
port 5434
What parameter
Geoffrey wrote:
Gerd Koenig wrote:
Hi Geoffrey,
you do not need to connect to your database directly, just connect to
pgpool itself.
e.g.: your database runs on port 5434, pgpool runs on port 5432
=
* pgpool has to be configured in that way that it connects to the
database on port 5434
pgpool.conf file and I've restarted the pgpool processes. I can
connect to the first entry as follows:
psql -p master
But if I attempt to connect to the second postmaster as follows:
psql -p mwv
I can not connect. What am I missing?
--
Until later, Geoffrey
I predict future happiness
Guillaume Lelarge wrote:
Le 21/06/2010 15:52, Geoffrey a écrit :
So I've got the following:
port =
.
.
backend_hostname0 = 'localhost'
backend_port0 = 5434
backend_weight0 = 1
backend_data_directory0 = '/data/pgsql/master'
backend_hostname1 = 'localhost'
backend_port1 = 5435
, what happens to the 21st connection attempt? Is it rejected
or put into a queue to wait for the next available connection?
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care
John R Pierce wrote:
On 06/21/10 5:37 AM, Geoffrey wrote:
So I've got 13 different databases on 13 different postmasters, now
does pgpool know which databases I'm trying to connect to?
you would need 13 different connection pools.
Can this be done?
--
Until later, Geoffrey
I predict
Scott Marlowe wrote:
On Mon, Jun 21, 2010 at 1:45 PM, Geoffrey li...@serioustechnology.com wrote:
John R Pierce wrote:
On 06/21/10 5:37 AM, Geoffrey wrote:
So I've got 13 different databases on 13 different postmasters, now does
pgpool know which databases I'm trying to connect to?
you would
Scott Marlowe wrote:
On Mon, Jun 21, 2010 at 2:42 PM, Geoffrey li...@serioustechnology.com wrote:
Scott Marlowe wrote:
On Mon, Jun 21, 2010 at 1:45 PM, Geoffrey li...@serioustechnology.com
wrote:
John R Pierce wrote:
On 06/21/10 5:37 AM, Geoffrey wrote:
So I've got 13 different databases
Does postgresql have functions to calculate the distance between two
sets of longitude and latitude.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas
ever asked for that. There must be some tool
that will dump an HTML tree as a single text file.
Or maybe convert the PDF file to text.
On Linux:
/usr/bin/pdftotext
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors
Do temp tables need to be explicitly dropped, or do the go away when the
process that created them leaves?
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them
I'm trying the following:
ship_date between '04/30/2010' AND '04/30/2010' + 14
But this returns:
ERROR: invalid input syntax for integer: 04/30/2010
Can I use between with dates?
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting
Geoffrey wrote:
I'm trying the following:
ship_date between '04/30/2010' AND '04/30/2010' + 14
But this returns:
ERROR: invalid input syntax for integer: 04/30/2010
Can I use between with dates?
Got it:
ship_date between '04/30/2010' and timestamp '04/30/2010' + interval '14
day
Tom Lane wrote:
Geoffrey li...@serioustechnology.com writes:
ship_date between '04/30/2010' AND '04/30/2010' + 14
ERROR: invalid input syntax for integer: 04/30/2010
Can I use between with dates?
The problem with that is the parser has no reason to treat the strings
as dates, at least
I'm trying the following:
ship_date between '04/30/2010' AND '04/30/2010' + 14
But this returns:
ERROR: invalid input syntax for integer: 04/30/2010
Can I use between with dates?
--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651
--
Sent via pgsql-general mailing list (pgsql-general
LinkedIn
Geoffrey Gowey requested to add you as a connection on LinkedIn:
--
Andrew,
I'd like to add you to my professional network on LinkedIn.
- Geoffrey Gowey
Accept invitation from Geoffrey Gowey
http://www.linkedin.com/e
.
The cgi code is perl.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
Craig Ringer wrote:
On 18/03/2010 9:19 PM, Geoffrey wrote:
We are trying to determine the best solution for a web based
application. We have 13 databases (separate postmaster for each
database) that we need to retrieve data from in order to produce the web
page. This data is changing
is different.
Where do I look to fix this?
Thanks.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general
Nov 17 08:22 000100610019
Nov 17 08:34 000100610012
I would expect that these things are sequential, yet the file that I
would think would be the oldest (000100610012) has the
latest time stamp.
What am I missing?
--
Until later, Geoffrey
Those who would
Tom Lane wrote:
Geoffrey li...@serioustechnology.com writes:
listing of wal file time stamps for one of our production databases:
Nov 17 06:22 000100610013
Nov 17 06:42 000100610014
Nov 17 07:02 000100610015
Nov 17 07:22 000100610016
Nov 17 07:42
, but
that entails some delicate timing issues.
Any suggestions, pointers would be greatly appreciated.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-general
Geoffrey wrote:
We currently have a PITR solution in place that is facilitated via WAL
shipment. This is implemented on 13 databases, where the two primary
machines which contain the production databases and the PITR machine are
physically located in the same facility.
We now want to add
Geoffrey wrote:
Geoffrey wrote:
We currently have a PITR solution in place that is facilitated via WAL
shipment. This is implemented on 13 databases, where the two primary
machines which contain the production databases and the PITR machine
are physically located in the same facility.
We
, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
Greg Smith wrote:
On Wed, 3 Jun 2009, Geoffrey wrote:
My assumption was that since pg_standby does not have the scp/rsync
functionality, I would have to either modify it, change the way we do
things, or 'reinvent' a little different wheel.
There are three things to setup here:
1
Joshua D. Drake wrote:
On Wed, 2009-06-03 at 15:07 -0400, Geoffrey wrote:
You are still going to need to either:
A. Reinvent the wheel, by scripting it all yourself
B. Use solutions that are already used by others such as walmgr or
pitrtools
My assumption was that since pg_standby does
Greg Smith wrote:
On Thu, 4 Jun 2009, Geoffrey wrote:
For now, I'm still looking at the other tools as well as attempting to
verify that my current solution doesn't miss any 'little issues.'
The main thing you want to test out are that it acts sanely when the
network connection
Joshua D. Drake wrote:
On Tue, 2009-06-02 at 19:44 -0400, Geoffrey wrote:
pg_standby it self isn't a solution for warm standby. It is a component
thereof. Also don't use SCP. Use rsync. Take a look at walmgr or
PITRTools it will make your life easier.
I still don't understand why
). I'm certainly looking at rsync rather then scp, which really
makes more sense.
Greg Smith wrote:
On Tue, 2 Jun 2009, Geoffrey wrote:
The problem with my current process is as noted, my script keeps
looking for the *.history file, but never sees it.
From the restore_command section
1 - 100 of 304 matches
Mail list logo