Hey..
I am facing a similar kind of problem, but in a two node setup. Streaming
replication is being used with a high wal_keep_segments, using log shipping
to bump up timelines on the standby server to setup SR(streaming
replication).
DB1 - master
DB2 - standby
When a switchover happens DB2
prakhar jauhari wrote:
I am facing a similar kind of problem, but in a two node setup. Streaming
replication is being used
with a high wal_keep_segments, using log shipping to bump up timelines on the
standby server to setup
SR(streaming replication).
DB1 - master
DB2 - standby
Hi
The question is regrading PostgreSQL 8.0.26 version on Linux platform. I
know that 8.0 version is no longer supported. But one of our customer is
using this version.
We are using File System based backup method to protect PostgreSQL server.
In PostgreSQL 8.2 and above versions, I can see that
On Wed, Jun 19, 2013 at 2:02 PM, girish R G peetle
giri.anami...@gmail.comwrote:
Hi
The question is regrading PostgreSQL 8.0.26 version on Linux platform. I
know that 8.0 version is no longer supported. But one of our customer is
using this version.
We are using File System based backup
On 19 June 2013 09:32, girish R G peetle giri.anami...@gmail.com wrote:
Is there a way to switch the current transaction log file in Postgres 8.0 ?
No, that was an addition to 8.2
Suggest that you send more data until the WAL file switches.
You should upgrade with some urgency.
--
Simon
I really hate the error permission denied for sequence x when I
grant on a table but forget to grant additionally on the related
sequence to users. Can the permission of table and related sequences be
merged?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
On 19 June 2013 11:35, Rural Hunter ruralhun...@gmail.com wrote:
I really hate the error permission denied for sequence x when I
grant on a table but forget to grant additionally on the related sequence
to users. Can the permission of table and related sequences be merged?
I can imagine
于 2013/6/19 17:47, Szymon Guz 写道:
On 19 June 2013 11:35, Rural Hunter ruralhun...@gmail.com
wrote:
I really
hate the error "permission denied for sequence x" when
I grant on a table but forget to
On 19 June 2013 12:06, Rural Hunter ruralhun...@gmail.com wrote:
于 2013/6/19 17:47, Szymon Guz 写道:
On 19 June 2013 11:35, Rural Hunter ruralhun...@gmail.com wrote:
I really hate the error permission denied for sequence x when I
grant on a table but forget to grant additionally on the
Hi,
Ya the error logs came, but only when the DB1 was corrupted. Here is a
excerpt from the logs.
*LOG: database system was shut down at 2013-06-19 09:40:55 UTC
LOG: restored log file 0004.history from archive
cp: cannot stat `/data/pgsql/archivedir/0005.history': No such file or
On Wed, Jun 19, 2013 at 4:32 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
girish R G peetle wrote:
@Albe
Even I was thinking to backup the transaction log files under pg_xlog
directory. But my concern is,
will it lead some kind of error or inconsistency ?
No.
During recovery,
girish R G peetle wrote:
I was wondering if I can use the modified version of your solution.
1. Convert output of pg_stop_backup to transaction log file name. (This
refers to the latest active
transaction log file)
2. If we are able to see this file under archive(WAL) directory, backup
Thanks a lot Laurenz Albe.
On Wed, Jun 19, 2013 at 6:16 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
girish R G peetle wrote:
I was wondering if I can use the modified version of your solution.
1. Convert output of pg_stop_backup to transaction log file name. (This
refers to the
On Thu, Jun 13, 2013 at 10:51 AM, francis picabia fpica...@gmail.com wrote:
I think my needs are standard for PITR: single master server and single
backup server, warm, with desire for PITR.
I'm running postgres 8.4.
I've looked at Postgres docs on warm backup, and several blogs
attempting
On 6/6/13 8:01 PM, Kasia Tuszynska wrote:
dpkg: error processing
/var/cache/apt/archives/postgresql-9.0_9.0.13-1.pgdg10.4+1_amd64.deb
(--unpack):
trying to overwrite '/usr/share/locale/zh_TW/LC_MESSAGES/plpython-9.0.mo',
which is also in package postgresql-plpython-9.0 0:9.0.5-1~lucid
so i tried to do a
/usr/local/pgsql.old/bin/postgres -D /usr/local/pgsql.old/data start
LOG: database system was shut down at 2013-06-19 08:10:51 CST
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
it got stuck there ^^
the i tried to
so when following the instructions of pg_upgrade
If your installation directory is not version-specific, e.g.
/usr/local/pgsql, it is necessary to move the current PostgreSQL install
directory so it does not interfere with the new PostgreSQL installation.
Once the current PostgreSQL server is
On Mon, Jun 17, 2013 at 07:08:03PM -0400, Bruce Momjian wrote:
On Mon, Jun 17, 2013 at 10:54:06AM -0700, jmfox180 wrote:
so i'm running ubuntu 12.04 with pg8.3.2 installed on it, i want to upgrade
to 9.2.4 using the pg_upgrade. i've followed this steps:
1) download postgres9.2.4
On 13-06-19 10:16 AM, jmfox180 wrote:
so i tried to do a
/usr/local/pgsql.old/bin/postgres -D /usr/local/pgsql.old/data start
LOG: database system was shut down at 2013-06-19 08:10:51 CST
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
it got stuck
so i'm trying to migrate/upgrade from 8.3.2 to 9.2.4 and following the
instructions of the documentation i've found myself in a major issue which
has overwhelmed my little knowledge.
these were the steps i followed:
1)downloand and install 9.2.4, with the contrib packages.
2)init the 9.2.4
On Wed, Jun 19, 2013 at 11:37:30AM -0600, Marcos Cano wrote:
ERROR: could not access file $libdir/liblwgeom: No such file or directory
STATEMENT: LOAD '$libdir/liblwgeom'
command: /usr/local/pgsql9.2.4/bin/pg_ctl -w -D
/usr/local/pgsql9.2.4/data/
-o -m fast stop pg_upgrade_server.log 21
so i'm trying to migrate/upgrade from 8.3.2 to 9.2.4 and following the
instructions of the documentation i've found myself in a major issue which
has overwhelmed my little knowledge.
these were the steps i followed:
1)downloand and install 9.2.4, with the contrib packages.
2)init the 9.2.4
This error:
ERROR: could not access file $libdir/liblwgeom: No such file or directory
Means that you have PostGIS installed and it can't find it in the upgrade path
I believe. Did you get postGI configured correctly in the upgraded version?
r.b.
--
Sent via pgsql-admin mailing list
On Wed, Jun 19, 2013 at 2:35 AM, Rural Hunter ruralhun...@gmail.com wrote:
I really hate the error permission denied for sequence x when I
grant on a table but forget to grant additionally on the related sequence
to users. Can the permission of table and related sequences be merged?
You
On Tue, Jun 18, 2013 at 11:20 PM, prakhar jauhari prak...@gmail.com wrote:
When a switchover happens DB2 becomes the new master and when DB1 comes up
it will act as the standby to the new master (.history files from new master
are copied to DB1 to bump up its timeline so as to setup SR). DB1 is
yes i guess is postgis... because we are using postgis in our DB but I
wasn't aware
On Wednesday, June 19, 2013, Bruce Momjian wrote:
On Wed, Jun 19, 2013 at 11:37:30AM -0600, Marcos Cano wrote:
ERROR: could not access file $libdir/liblwgeom: No such file or
directory
STATEMENT: LOAD
Just turned on WAL archiving to an S3 bucket for a small database - total size
of perhaps 2-4G. After turning on achiving, we're seeing WAL logs written to
S3 at the rate of about 1G every 3 minutes. That seems completely unreasonable
given usage of the db. I can even see that nearly nothing
Yes, that's also an acceptable
solution.
于 2013/6/20 3:48, Craig James 写道:
On Wed, Jun 19, 2013 at 2:35 AM, Rural
Hunter ruralhun...@gmail.com
wrote:
I really hate the error "permission denied for sequence
28 matches
Mail list logo