This message has been digitally signed by the sender.
Re___GENERAL__failed_archive_command.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscriptio
On Wed, 2011-07-06 at 23:39 -0500, Joe Lester wrote:
> archive_command = '/usr/bin/scp -B /Volumes/DataDrive/data/%p
> postgres@172.20.204.55:/Volumes/DataDrive/wals_from_master/%f'
%p is expanded to the *full* path, so /Volumes/DataDrive/data/%p might
not be the correct. I'd use just %p instead o
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
Greetings Postgres Community,
I am certain that I am signing my own death certificate by emailing to a
general address that is out of place, but I was referred to this list by a
Postgres advocate here in Seattle, who suggested I give it a shot...so here I
am. I don't know if anyone would b
I think you should make the base database the same
6. Make a base backup by copying the primary server's data directory to the
standby server.
$ psql -c "SELECT pg_start_backup('label', true)"
$ rsync -a ${PGDATA}/ standby:/srv/pgsql/standby/ --exclude postmaster.pid
$ psql -c "SELECT pg_stop_back
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
On Wed, Jul 6, 2011 at 3:13 PM, David Johnston wrote:
>
> The product 9 is a hard drive, so it's inserted in the hard drive table, but
> as it inherits product, I see it in product table too.
>
> Why do i Have this message ? Can you help me ?
First you need to have some way to differentiate what
On Wed, Jul 6, 2011 at 4:54 PM, David Hartveld
wrote:
> Is there possibly a known issue with the beta, or do I have to configure my
> cluster differently for 9.1?
Thanks for trying 9.1beta
No known bugs, no differences in configuration.
You haven't enabled any of the new 9.1 features either so
On Thu, Jun 23, 2011 at 8:48 PM, John R Pierce wrote:
> the 2nd example on http://wiki.postgresql.org/wiki/Index_Maintenance
> doesn't work on 8.4 or 9.0 unless you add ::text to the arguments of the
> two pg_relation_size calls near the beginning.
>
> I don't have wiki edit privs and don't see a
The product 9 is a hard drive, so it's inserted in the hard drive table, but
as it inherits product, I see it in product table too.
Why do i Have this message ? Can you help me ?
Thank you
David
Working as designed; foreign keys and unique indexes are only valid for the
explicit table the
Hello Everyone,
I got trouble with inherit and foreign key.
I give you example of what's it likes.
I got 4 tables :
- order
- order_details
- product
- hard_drive
Hard_drive inherit product
order_details got order on foreign key
order_details got product on foreign key
When I try to add an or
>> Monitoring PostgreSQL has been a big issue for us since beginning to
>> migrate from Oracle, so if anyone else has any experience with this I
>> would love to hear other suggestions.
>
> Most of our monitoring is done through Nagios and Cacti by extracting data
> from log files or pg_stat_activ
On Jul 6, 8:44 am, wmo...@potentialtech.com (Bill Moran) wrote:
>
> > Monitoring PostgreSQL has been a big issue for us since beginning to
> > migrate from Oracle, so if anyone else has any experience with this I would
> > love to hear other suggestions.
>
> Most of our monitoring is done throug
On 07/06/11 6:42 AM, Bill Moran wrote:
FYI, to follow up on another post. "postgre" is not really an acceptable
shortening of PostgreSQL. "postgres" is generally accepted, although there
seem to be some people who dislike that as well. "PG" or "PGSQL" also seem
to be generally accepted shorten
Hello,
I have the question regarding pg_dump functionality.
I using PostgreSQL 8.4.8 database and defined the dblink between two
databases. dblink uses foreign data wrapper, user mappings and foreign
server.
When I perform database backup using pg_dump utility it also includes
foreign data wrapper
Good morning,
A question about: ERROR: malformed record literal: ""
DETAIL: Missing left parenthesis.
Can someone tell me what cause the error?
Table z_drop;
Column| Type
-+
run_date| character varying(128)
adm
Hi all,
I am experimenting with (synchronous) streaming replication on postgresql 9.1
beta 2 and am having performance problems. I have initially set up an
(asynchronous) streaming replication master cluster with postgresql 9.0, which
streamed to a single slave cluster. This seemed to work quit
In response to Bobby Dewitt :
> I think by AWR he is referring to Oracle's Automatic Workload Repository. It
> automatically gathers information on wait events, object usage, session and
> system statistics, etc. It also provides a nice report of what is going on
> in your database and can he
I think by AWR he is referring to Oracle's Automatic Workload Repository. It
automatically gathers information on wait events, object usage, session and
system statistics, etc. It also provides a nice report of what is going on in
your database and can help identify bottlenecks that may be cau
On Wed, Jul 6, 2011 at 3:57 AM, BangarRaju Vadapalli <
bangarraju.vadapa...@infor.com> wrote:
> Hi Everybody,
>
> ** **
>
>We want to monitor the performance of PostGRE database. Could anyone
> please suggest any tools tried/working successfully…
>
> ** **
>
> **1. **We want AWR
In response to BangarRaju Vadapalli :
> Hi Everybody,
>
>We want to monitor the performance of PostGRE database. Could anyone
> please suggest any tools tried/working successfully...
>
>
> 1. We want AWR kind of report in Postgres
You shouldn't use common acronyms in a question like
This message has been digitally signed by the sender.
Re___GENERAL__Performance_Monitoring_of_PostGRE.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Hi!
2011/7/6 Durumdara :
>> Most importantly, PostgreSQL's "stored procedures" cannot control
>> transactions. They cannot commit, rollback, or begin a new transaction. They
>> have some control over subtransactions using PL/PgSQL exceptions, but that's
>> about it.
>
> So: I tried it, I created a
On Wed, 2011-07-06 at 14:27 +0530, BangarRaju Vadapalli wrote:
>We want to monitor the performance of PostGRE database
I am not aware of a database called PostGRE.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat
Hi Everybody,
We want to monitor the performance of PostGRE database. Could anyone please
suggest any tools tried/working successfully...
1. We want AWR kind of report in Postgres
2. We would like to do CPU Utilization monitoring based on the postgres
processes
Thanks in Advan
On Wed, Jul 06, 2011 at 12:54:21PM +0200, Willy-Bas Loos wrote:
> I'd like to do a dirty read from plpgsql, so that i can stop the function
> that is in a long loop without rolling back the work that it did.
> All i want to read is a flag that says 'stop'.
this doesn't need dirty read.
just read c
On 6/07/2011 6:54 PM, Willy-Bas Loos wrote:
I'd like to do a dirty read from plpgsql, so that i can stop the
function that is in a long loop without rolling back the work that it
did.
All i want to read is a flag that says 'stop'.
I've figured 2 ways of doing that, both of which i don't like ve
I'd like to do a dirty read from plpgsql, so that i can stop the function
that is in a long loop without rolling back the work that it did.
All i want to read is a flag that says 'stop'.
I've figured 2 ways of doing that, both of which i don't like very much.
* with a sequence: while value = nextva
I'm looking for a simple application which supports table-based and
card-based browsing and runs on a character terminal. Field editing
should support an external editor for large values. (The databases are
not directly reachable from a graphic terminal, and there is no HTTP
server running on the
Hello
there is not reason for using PP from plpgsql. PostgreSQL's prepared
statement are limited by session too.
Regards
Pavel Stehule
2011/7/6 Wim Bertels :
> Hallo,
>
> good reasons to use prep statements
> seem
> - performance
> - some sql injection defence
>
> but when i look at plpgsql
> h
Hallo,
good reasons to use prep statements
seem
- performance
- some sql injection defence
but when i look at plpgsql
http://www.postgresql.org/docs/8.4/interactive/plpgsql-implementation.html
i see that sql statements are translated into prep statements,
and live (the plan) as long the db conne
Hi!
2011/7/4 Craig Ringer :
> On 4/07/2011 7:50 PM, Durumdara wrote:
>
>> As I understand you then running Queries forced to abort on the end of
>> Session and no more Query running over the session's ending point (or
>> after TCP connection broken).
>
> Correct. The server might not notice that t
32 matches
Mail list logo