Someone in our company wrote a script that backs up data from a certain
table, that person left the company and no one is able to figure it out.
Part of this script has something like, look at the COPY BINARY command
just below:
EXPORTFILE=${EXPORTFILE}.${AUD_UP_TO}_${MAX_AUDIT}
*$PSQL -c "C
On Thu, Mar 1, 2012 at 12:14 AM, Brian Fehrle
wrote:
> I am taking periodic snapshots from the system view 'pg_stat_bgwriter' from
> both the master and the hot standby.
You mean that you observed that pg_stat_bgwriter.checkpoints_timed in
the standby was larger than that in the master? I ran pgb
On Wed, Feb 29, 2012 at 03:55:13PM -0500, Ray Stell wrote:
> http://www.postgresql.org/docs/9.1/static/release-9-1-2.html
> This must be repeated in each
> database to be fixed.
including postgres, template0, and template1?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To mak
on rebuilding the information_schema:
http://www.postgresql.org/docs/9.1/static/release-9-1-2.html
...
Since the view definition is installed by initdb, merely upgrading will
not fix the problem. If you need to fix this in an existing installation,
you can (as a superuser) drop the information_sche
I am taking periodic snapshots from the system view 'pg_stat_bgwriter'
from both the master and the hot standby.
- Brian F
On 02/28/2012 09:22 PM, Fujii Masao wrote:
On Wed, Feb 29, 2012 at 7:53 AM, Brian Fehrle
wrote:
Hi all,
I have two PostgreSQL 9.0.5 clusters, one is a master and the o
