Re: [GENERAL] PostgreSQL advocacy

On 3/22/16, 8:07 AM, "Bruce Momjian" wrote: >On Mon, Mar 21, 2016 at 04:46:51PM +, Jernigan, Kevin wrote: >> Disk is only a single point of failure in RAC if you configure >> non-redundant storage. In general, Oracle recommends triple mirroring >> to protect against disk

Re: [GENERAL] PostgreSQL advocacy

On 3/24/16, 3:09 PM, "Albe Laurenz" wrote: >Jernigan, Kevin wrote: >> Disk is only a single point of failure in RAC if you configure non-redundant >> storage. >> In general, Oracle recommends triple mirroring to protect against disk >> failures, >> as they have had

Re: [GENERAL] PostgreSQL advocacy

Jernigan, Kevin wrote: > Disk is only a single point of failure in RAC if you configure non-redundant > storage. > In general, Oracle recommends triple mirroring to protect against disk > failures, > as they have had many experiences over the years where customers with > mirrored disks > would

Re: [GENERAL] Multixacts wraparound monitoring

Pavlov, Vladimir wrote: > There is nothing: > select * from pg_prepared_xacts; > transaction | gid | prepared | owner | database > -+-+--+---+-- > (0 rows) > It is also noticed that a lot of files in a directory > main/pg_multixact/members/, now - 69640. Can

Re: [GENERAL] Multixacts wraparound monitoring

There is nothing: select * from pg_prepared_xacts; transaction | gid | prepared | owner | database -+-+--+---+-- (0 rows) It is also noticed that a lot of files in a directory main/pg_multixact/members/, now - 69640. Kind regards,   Vladimir Pavlov

[GENERAL] Way to get at parsed trigger 'WHEN' clause expression?

Folks, I see that psql's \d displays trigger information of a table by making a call to pg_catalog.pg_get_triggerdef(), which abstracts away most all need to parse the contents of system catalog pg_trigger. However, we'd like to be able to get at a human readable representation of just

Re: [GENERAL] Uninstalled working db by mistake

On 24/03/2016 17:52, David Wilson wrote: Per the heading printed by dpkg --list, this means the package is in the removed state, but it's config files are still present. "apt-get install postgresql-9.0" should be all required. David David, I owe you a beer. Nay - several drinks of your

Re: [GENERAL] Multixacts wraparound monitoring

Pavlov, Vladimir wrote: > Thanks for your reply. > Yes, the first thing I looked at the statistics from pg_stat_activity. > But I have a transaction is not more than 60 seconds and the condition 'idle > in transaction' lasts only a few seconds. Maybe you have a prepared transaction? See select

Re: [GENERAL] Uninstalled working db by mistake

On Thu, Mar 24, 2016 at 05:44:27PM +, Howard News wrote: > Thanks David, > > Unfortunately my cluster wont start - I am not entirely sure on the state of > postgresql-9.0, this is the output from dpkd --list > > > > rc postgresql-9.0 9.0.4-1~lucid1 object-relational SQL database, version

Re: [GENERAL] Uninstalled working db by mistake

Thanks David, Unfortunately my cluster wont start - I am not entirely sure on the state of postgresql-9.0, this is the output from dpkd --list rc postgresql-8.4 8.4.6-0ubuntu1 object-relational SQL database, version 8.4 rc postgresql-9.0 9.0.4-1~lucid1 object-relational SQL database,

Re: [GENERAL] Uninstalled working db by mistake

On Thu, Mar 24, 2016 at 05:34:21PM +, David Wilson wrote: > So long as you haven't touched anything else, simply reinstalling the > package should restore your cluster. Debian packages only do > initialization if the data directories are missing. Just for good measure I would strongly

Re: [GENERAL] Uninstalled working db by mistake

Hi Howard, So long as you haven't touched anything else, simply reinstalling the package should restore your cluster. Debian packages only do initialization if the data directories are missing. David On Thu, Mar 24, 2016 at 05:29:23PM +, Howard News wrote: > Hi, > > I uninstalled the

[GENERAL] Uninstalled working db by mistake

Hi, I uninstalled the wrong version of postgres on Ubuntu using apt-get remove postgresql-9.0, convinced that this was an old unused version. You guess the rest... The data files still appear to be there, all 485GB of them. Can these be restored? Thanks.

Re: [GENERAL] Multixacts wraparound monitoring

Thanks for your reply. Yes, the first thing I looked at the statistics from pg_stat_activity. But I have a transaction is not more than 60 seconds and the condition 'idle in transaction' lasts only a few seconds. Kind regards,   Vladimir Pavlov -Original Message- From: Adrian Klaver

Re: [GENERAL] Only owners can ANALYZE tables...seems overly restrictive

On Thu, Mar 24, 2016 at 4:51 AM, Stephen Frost wrote: > David, > > * David G. Johnston (david.g.johns...@gmail.com) wrote: > > Which means that, aside from effort, the main blocking factors here are > > code complexity (which I understand) and limited grant "bits" as Stephen

[GENERAL] Foreign key referencing a VIEW

Hi all, I have a feature request for our dear fellow developpers : I would like to be able to create a foreign key constraint that references a view (or anything that looks like a table, as a function returning a table for instance) instead of a table. Does that look doable ? The trickiest part

Re: [GENERAL] Partitioning and ORM tools

On 03/23/2016 02:48 AM, Chris Travers wrote: On Wed, Mar 23, 2016 at 9:39 AM, Chris Travers > wrote: Use a view with a DO INSTEAD trigger. That will allow you to return the tuple properly. On Tue, Mar 22, 2016 at 7:40

Re: [GENERAL] Multixacts wraparound monitoring

On 03/24/2016 12:54 AM, Pavlov, Vladimir wrote: Hello, How can we determine when an error of approximation multixacts wraparound? According to the information from pg_class: select datname,datminmxid from pg_database; datname | datminmxid + template1

Re: [GENERAL] Only owners can ANALYZE tables...seems overly restrictive

David, * David G. Johnston (david.g.johns...@gmail.com) wrote: > Which means that, aside from effort, the main blocking factors here are > code complexity (which I understand) and limited grant "bits" as Stephen > puts it. So I pose the question: do any of the committers consider a grant > bit

Re: [GENERAL] PostgreSQL crash with PANIC message

Il 24/03/2016 05:12, Michael Paquier ha scritto: On Thu, Mar 24, 2016 at 5:57 AM, Adrian Klaver wrote: On 03/23/2016 12:02 PM, Moreno Andreo wrote: Il 23/03/2016 19:57, Adrian Klaver ha scritto: Might help to look in: Control Panel --> Administrative Tools -->

[GENERAL] Multixacts wraparound monitoring

Hello, How can we determine when an error of approximation multixacts wraparound? According to the information from pg_class: select datname,datminmxid from pg_database; datname | datminmxid + template1 | 347462426 template0 | 347462426 postgres