Re: [GENERAL] CentOS - PostgreSQL 9.2.13 - 9.4

that dropped in performance the most, then run it with explain (analyze, buffers) and with track_io_timing turned on, and compare this between the servers. Did the plan change, or just the time? Cheers, Jeff -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish

Re: [GENERAL] PostgreSQL - The Best Overall Database

://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Extension to rewrite queries before execution

, Aug 13, 2015 at 1:37 PM, Melvin Davidson melvin6...@gmail.com wrote: On Thu, Aug 13, 2015 at 3:49 PM, Jeff Janes jeff.ja...@gmail.com wrote: I am looking for an extension or a technique that will allow me to intercept a query by the exact query text, and replace that query with a different

Re: [GENERAL] I am unable to install PostgreSql

using postgresql-9.4.4-3 version to install. However I am getting the same issue with postgresql-9.3.9-3 version as well. Kindly suggest, what needs to be done. Regards Shashank From: Melvin Davidson melvin6...@gmail.com

[GENERAL] PostgreSQL - The Best Overall Database

This should put a smile on all PostgreSQL DBA's faces. The Best Overall Database http://www.dbta.com/Editorial/Trends-and-Applications/Best-Database-Overall%C2%AD-105362.aspx *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] PostgreSQL - The Best Overall Database

I uinderstand and agree. In like fashion, I have a large dislike for MySQL and Access. But then again, are either of them really db's? :) On Thu, Aug 13, 2015 at 9:21 AM, John McKown john.archie.mck...@gmail.com wrote: On Thu, Aug 13, 2015 at 8:03 AM, Melvin Davidson melvin6...@gmail.com wrote

Re: [GENERAL] I am unable to install PostgreSql

take few minutes). Kindly help me on this. Thanks in advance. Regards Shashank Mumbai, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I

Re: [GENERAL] Extension to rewrite queries before execution

-- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] How to intelligently work with views that depend on other views

mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] How to intelligently work with views that depend on other views

Correction, as Mr. Tober suggested. On Thu, Aug 6, 2015 at 8:34 PM, Melvin Davidson melvin6...@gmail.com wrote: As Mr. Wilson suggested, you can use pg_dump to extract the views, but I also suggest downloading and installing pg_extractor, which uses pg_dump but allows more options to dump

Re: [GENERAL] How to intelligently work with views that depend on other views

/pg_extractor These url's give more detail about it. http://www.keithf4.com/pg_extractor/ https://www.youtube.com/watch?v=a7P4TV8xUOM On Thu, Aug 6, 2015 at 7:41 PM, Berend Tober bto...@computer.org wrote: Melvin Davidson wrote: The best solution, IMHO, is don't create views that depend on other

Re: [GENERAL] scaling postgres - can child tables be in a different tablespace?

list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] user connection not recorded?

Thanks for the quick reply Adrian. On Thu, Jul 30, 2015 at 10:09 AM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 07/30/2015 06:42 AM, Melvin Davidson wrote: I have a puzzling question. All through the error log, there are connections for [unknown] user. EG: 2015-07-30 00:00:00

[GENERAL] user connection not recorded?

is not available in nslookup, but why is the user not being recorded? *Melvin Davidson*

Re: [GENERAL] instr detail

and operators: http://www.postgresql.org/docs/9.3/static/functions-string.html There is definitely a replacement for Oracle’s instr(…). Regards, Igor Neyman -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Connections closing due to terminating connection due to administrator command

adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy

Re: [GENERAL] Delete rule does not prevent truncate

://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Schema Help Needed To Get Unstuck

Does this help? CREATE TABLE permits ( permit_number bigint, ..., other_columns data_types, ..., CONSTRAINT permits_pk PRIMARY KEY (permit_number) ); CREATE TABLE parameters ( permit_number bigint, parameter varchar(50), ..., other_columns data_types, ..., CONSTRAINT parameters_pk PRIMARY KEY

Re: [GENERAL] Delete rule does not prevent truncate

think of TRUNCATE as an alias to DELETE, then I would think its not entirely unreasonable of me to expect a rule preventing DELETE to also cover truncate, since the rule would no doubt prevent an unqualified DELETE, would it not ?!? On 22 July 2015 at 14:03, Melvin Davidson melvin6...@gmail.com

Re: [GENERAL] Delete rule does not prevent truncate

/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] INSERT ... ON CONFLICT DO UPDATE

list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Backup fatal issue

in a virtualized Debian Linux 8.0. I do not know backup command because is launched by BARMAN 1.4.1. I have tried many times to execute the backup. I have restarted and reinstalled Postgres and I also rebooted OS many times. Thanks for your help. Meph On 17 July 2015 at 15:12, Melvin Davidson

Re: [GENERAL] Backup fatal issue

at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] How to get total count of queries hitting DB per day or per hour?

to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

else should do it for you. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy

Re: [GENERAL] database-level lockdown

it needs. I think you need to reconsider your objectives. What if two or more transactions are repeatedly failing and retrying, perhaps because they conflict? They can't all forcibly win. regards, tom lane -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish

Re: [GENERAL] very slow queries and ineffective vacuum

this issue. Best regards. Lukasz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my

Re: [GENERAL] PgPool Configuration Document required

of PgPool? -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] very slow queries and ineffective vacuum

-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Which replication is the best for our case ?

to use a bulldozer to change a lightbulb. Improving queries (including the effect running some queries has on the entire system) starts with EXPLAIN (ANALYZE, BUFFERS), not with multimaster replication. Cheers, Jeff -- *Melvin Davidson* I reserve the right to fantasize. Whether

Re: [GENERAL] Correct place for feature requests

changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

[GENERAL] pg_upgrade problem

this is catalog corruption. Can anyone else confirm and/or suggest a recommended fix? -- *Melvin Davidson*

Re: [GENERAL] pg_upgrade problem

: Melvin Davidson melvin6...@gmail.com writes: Using pg_upgrade in 9.4 CentOS release 6.6 (Final) (from PostgreSQL 9.1.15) it fails when GRANTING permits to roles. Checking pg_upgrade_dump_globals.sql, I see the point of failure is caused by the -- Role memberships section. In there I

Re: [GENERAL] support for ltree

Shapiro Senior Systems Engineer National Center for Supercomputing Applications (NCSA) University of Illinois, Urbana-Champaign (UIUC) -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] PostgreSQL and iptables

/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] PostgreSQL and iptables

mephystoonh...@gmail.com wrote: I am sorry, I forgot to say that port of my database in postgresql.conf is setted to 5997. Byem Meph On 12 June 2015 at 17:10, Melvin Davidson melvin6...@gmail.com wrote: The default port for PostgreSQL is 5432. To allow external ip access, you need to specifcally

Re: [GENERAL] alter column type

that might affect integrity. Cheers, Casey -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] pg_relation_size performance issue

Correction, pg_relation_size includes toast data. On Thu, Jun 4, 2015 at 10:03 AM, Melvin Davidson melvin6...@gmail.com wrote: I'm not sure why you are adding toast to table size, since pg_relation_size already does that. http://www.postgresql.org/docs/9.3/interactive/functions-admin.html

Re: [GENERAL] pg_relation_size performance issue

get a list that also includes indexes, constraints, etc. Is there a way to restrict the returned set to tables only? Hans Guijt *From:* Melvin Davidson [mailto:melvin6...@gmail.com] *Sent:* 04 June 2015 16:08 *To:* Tom Lane *Cc:* Hans Guijt; pgsql-general@postgresql.org *Subject

Re: [GENERAL] pg_relation_size performance issue

Dammit pg_total_relation_size includes toast data. Thumb problems and to quick to hit send. :( On Thu, Jun 4, 2015 at 10:07 AM, Melvin Davidson melvin6...@gmail.com wrote: Correction, pg_relation_size includes toast data. On Thu, Jun 4, 2015 at 10:03 AM, Melvin Davidson melvin6...@gmail.com

Re: [GENERAL] pg_relation_size performance issue

list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] postgres db permissions

and development. Announcing I'm offended is basically telling the world you can't control your own emotions, so everyone else should do it for you. -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] postgres db permissions

subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] postgres db permissions

to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] TRIGGER TRUNCATE -- CASCADE or RESTRICT

all tables and can be referenced. No need for a key table. On Tue, Jun 2, 2015 at 3:45 PM, Andreas Ulbrich andreas.ulbr...@matheversum.de wrote: On 02.06.2015 16:20, Melvin Davidson wrote: You can use the following to list the triggers and see what functions they call. Then you can check

Re: [GENERAL] TRIGGER TRUNCATE -- CASCADE or RESTRICT

. If no, it might have been called either way, but the effect would be the same. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right

Re: [GENERAL] Minor revision downgrade (9.2.11 - 9.2.10)

-- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Help me recovery databases.

://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] How to retrieve Comment text using SQL, not psql?

-comment.html pgAdmin3 had no problem with entering a comment: COMMENT ON TABLE articlestats IS 'Comprehensive data for every article.' - Bob Futrelle -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] How to retrieve Comment text using SQL, not psql?

- Test comment (1 row) - Bob Futrelle -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve

Re: [GENERAL] Planner cost adjustments

it is too much information for me;-) Any rules of thumb, recipes I could use to select which parameters I should look at first? Daniel -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Partitioning and performance

-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] duplicate key value violates unique constraint pg_class_relname_nsp_index

CHAR(23), -- /MM/DD HH:MM:SS.mmm realUser VARCHAR(80), host VARCHAR(80), application VARCHAR(80) ) TABLESPACE MMDATA; Regards Mitu -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish

Re: [GENERAL] Queries for unused/useless indexes

: On 2015-05-25 12:25:01 -0400, Melvin Davidson wrote: I'm not sure why you are using pg_stat_user_indexes. Because you did. I didn't change that. My original query below uses pg_stat_all_indexes and the schema names are joined and it does work. I'm not sure what you mean by original

Re: [GENERAL] Queries for unused/useless indexes

, Peter J. Holzer hjp-pg...@hjp.at wrote: On 2015-05-22 09:41:57 -0400, Melvin Davidson wrote: I'd like to share those queries with the community, as I know there must be others out there with the same problem. /* useless_indexes.sql */ SELECT idstat.schemaname AS schema

Re: [GENERAL] Queries for unused/useless indexes

: On Fri, May 22, 2015 at 11:41 PM, Melvin Davidson melvin6...@gmail.com wrote: Over the years I've wrote many scripts and queries to track the database status. Recently I've had to convince a client who thought it was a good idea to create indexes for every column on every table

[GENERAL] Queries for unused/useless indexes

= 0 AND NOT idx.indisprimary AND NOT idx.indisunique GROUP BY table_size, table_size_pretty; *Melvin Davidson*

Re: [GENERAL] Replicate over pgbouncer?

not. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] About COPY command (and probably file fdw too)

Stefanov ​Hi, I guess it already does (from documentation): COPY table_name [ ( column_name [, ...] ) ] FROM { 'filename' | STDIN } [ [ WITH ] ( option [, ...] ) ] Then you can order the column_name as the source file has.​ -- *Melvin Davidson* I reserve the right

Re: [GENERAL] Slaves show different results for query

-- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] SELECT INTO and ON COMMIT

-- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

[GENERAL] Why is there no object create date is the catalogs?

a certain age. EG: SELECT 'DELETE TABLE ' || relname || ';' FROM pg_class WHERE relkind = 'r' AND relcreated current_timestamp - INTERVAL ' 1 year'; Adding that column should be relatively easy and would not break backwards compatiblity with previous versions. -- *Melvin Davidson*

Re: [GENERAL] Why is there no object create date is the catalogs?

:08 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 05/12/2015 03:44 PM, Melvin Davidson wrote: Adrian, You are over thinking this. An object is only created once! That is what I meant by relcreatedate. If it is dropped, then it is deleted from the catalogs. If it is modified

Re: [GENERAL] Why is there no object create date is the catalogs?

it is such a big deal ( or so hard ) to track when an object is created. It should be a very simple patch to the catalogs. On Tue, May 12, 2015 at 6:00 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 05/12/2015 12:51 PM, Melvin Davidson wrote: Can anyone tell me why there is no relcreated column

Re: [GENERAL] moving to PostgreSQL from MS-SQL and from Oracle, looking for feature comparison information

/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] detached query?

way to start a query, detach from the server and have the query keep going (long query that updates tables, but nothing is returned)? ​No. Sessions require an external client to maintain its connection. David J. ​ -- *Melvin Davidson* I reserve the right to fantasize. Whether

Re: [GENERAL] Standby problem after restore_command Implementation

pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Standby problem after restore_command Implementation

work. On Tue, May 5, 2015 at 11:35 AM, Edson F. Lidorio ed...@openmailbox.org wrote: On 05-05-2015 11:22, Melvin Davidson wrote: It's possible you have wal_keep_segments set too low. What happens is that the master will keep the wals ( in your case 20) after processing them, before sending

Re: [GENERAL] Standby problem after restore_command Implementation

a Standby Server On Tue, May 5, 2015 at 2:05 PM, Edson F. Lidorio ed...@openmailbox.org wrote: Em 2015-05-05 14:31, Adrian Klaver escreveu: On 05/05/2015 08:35 AM, Edson F. Lidorio wrote: On 05-05-2015 11:22, Melvin Davidson wrote: It's possible you have wal_keep_segments set too low. What

Re: [GENERAL] documenting tables version control

control your own emotions, so everyone else should do it for you. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether

Re: [GENERAL] Setting up a database for 10000 concurrent users

, then put pg_pool in front, and set pg_pools max count to 1. -Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize

Re: [GENERAL] plpgsql functions organisation

, Alban Hertroys haram...@gmail.com wrote: On 03 May 2015, at 2:56, Melvin Davidson melvin6...@gmail.com wrote: OK, Here is a simple example that shows the difference between using a self contained function and one that calls sub functions. After loading all the functions below, repeat

Re: [GENERAL] How to exclude blobs (large objects) from being loaded by pg_restore?

, veuillez m'en aviser immédiatement, par retour de courriel ou par un autre moyen. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize

Re: [GENERAL] plpgsql functions organisation

://yves.zioup.com gpg: 4096R/32B0F416 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my

Re: [GENERAL] plpgsql functions organisation

jeff.ja...@gmail.com wrote: On Sat, May 2, 2015 at 1:05 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 05/02/2015 10:12 AM, Melvin Davidson wrote: AFAIK, you cannot package functions in PostgreSQL, but it is possible to call a function from within a function

Re: [GENERAL] plpgsql functions organisation

Klaver adrian.kla...@aklaver.com wrote: On 05/02/2015 02:07 PM, Jeff Janes wrote: On Sat, May 2, 2015 at 1:05 PM, Adrian Klaver adrian.kla...@aklaver.com mailto:adrian.kla...@aklaver.com wrote: On 05/02/2015 10:12 AM, Melvin Davidson wrote: AFAIK, you cannot package

Re: [GENERAL] Partition Help

changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Partition Help

-- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] New column modifier?

exploring, are you on a textpedition? He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! John McKown -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL]

parts.i placed query select deleteparts(); when click run now job,it returns statistics failed and etc/pg_log not contian any error please suggest How to solve this.. -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] newsfeed type query

; On Apr 28, 2015, at 6:56 PM, Melvin Davidson wrote: Since you very nicely DID NOT provide the pg version, O/S or table structure(s), which is what you should do REGARDLESS of the type of question (it's just the smart and polite thing to do when asking for help) The best I can

Re: [GENERAL] newsfeed type query

: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] On using doubles as primary keys

-- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] no pg_hba.conf entry for replication connection from host

...@gmail.com wrote: HI Adrian, Can you connect remotely from the standby using psql? Yes, I can connect directly from the standby using psql and DB_USER and DB_PASS. -- *Volkan Unsal* *web and mobile development* volkanunsal.com http://bit.ly/1h1ebjy -- *Melvin Davidson* I reserve

Re: [GENERAL] no pg_hba.conf entry for replication connection from host

LOG: consistent recovery state reached at 0/EF0 What am I doing wrong? -- *Volkan Unsal* *web and mobile development* volkanunsal.com http://bit.ly/1h1ebjy -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you

Re: [GENERAL] ERROR: out of memory

') AND (stats.created_at = '2015-04-03 03:59:59.99') AND (stats.source IS NOT NULL) AND stats.device IN (1, 2) AND stats”.ra = 0 AND stats.paid = ’t' Any help appreciated. -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Relation name stored in Postgres

, K.Ravikiran -- Regards, K.Ravikiran -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Why doesn't `RAISE EXCEPTION` provide error context?

http://postgresql.nabble.com/PostgreSQL-general-f1843780.html at Nabble.com. -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] PL/PgSQL and pg_temp pseudo-schema

. -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right

Re: [GENERAL] Issue dumping schema using readonly user

doing anything else. So, for my 2c, it seems like we should be able avoid issuing the LOCK TABLE statements when we're doing a schema-only dump and then this would work. Thanks! Stephen -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish

Re: [GENERAL] Partioning with overlapping and non overlapping constraints

on this column should be sufficient as long as your partition count remains small. regards, Marc Mamin -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Temporarily suspend a user account?

-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Partioning with overlapping and non overlapping constraints

://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Getting truncated queries from pg_stat_statements

-- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] How to analyze a slowdown in 9.3.5?

that is slowing down, or perhaps some other process grabbing CPU time. On Sun, Jan 11, 2015 at 11:07 AM, Michael Nolan htf...@gmail.com wrote: On Sat, Jan 10, 2015 at 8:54 PM, Melvin Davidson melvin6...@gmail.com wrote: Just curious. Have you checked that the tables are being vacuum/analyzed

Re: [GENERAL] How to analyze a slowdown in 9.3.5?

-posting in my last note. -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] partial on-delete set null constraint

Your main problem is that column domain of mailboxes is specified as NOT NULL, so of course the SET NULL option will not work. Here is the full message I see when I execute your code, which should be self explanatory. ERROR: null value in column domain violates not-null constraint DETAIL:

Re: [GENERAL] Rollback on include error in psql

at dba.stackexchange.com: http://dba.stackexchange.com/questions/87040/rollback-on-include-error-in-psql -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] Stored procedure workflow question

-- _ Pulchritudo splendor veritatis. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you

Re: [GENERAL] Programmatic access to interval units

just do that. Regards, Nelson -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

<    1   2   3   4   5   6   7   >