Re: [GENERAL] Replication fell out of sync

On 03/02/2015 03:25 PM, David Kerr wrote: Howdy, I had an instance where a replica fell out of sync with the master. Now it's in in a state where it's unable to catch up because the master has already removed the WAL segment. (logs) Mar 2 23:10:13 db13 postgres[11099]: [3-1] user=,db=,host

Re: [GENERAL] VACUUM FULL doesn't reduce table size

On 03/09/2015 08:57 AM, Adrian Klaver wrote: On 03/09/2015 08:49 AM, Kevin Grittner wrote: pinker wrote: INFO: vacuuming "my_table" INFO: "my_table": found 0 removable, 3043947 nonremovable row versions in 37580 pages DETAIL: 0 dead row versions cannot be removed yet. So there are no l

Re: [GENERAL] Best way to migrate a 200 GB database from PG 2.7 to 3.6

On 04/15/2015 12:14 PM, Andy Colson wrote: Postgresql is on version 9. What do you mean version 2 or 3? He probably means 9.2.7 to 9.3.6. Remember to a lot of people 9 means 9. That said, pg_upgrade is the way to do this as long as you can have an outage. JD -- Command Prompt, Inc. - h

Re: [GENERAL] Streaming-SQL Database PipelineDB (Based on PostgreSQL 9.4) - Available in Beta

On 04/22/2015 01:09 PM, Jeff Ferguson wrote: Hello (PostgreSQL) World, We recently shipped our streaming-SQL analytics database, PipelineDB , which is based on PostgreSQL 9.4, in beta and are looking for companies to participate as early access partners. You can rea

Re: [GENERAL] New column modifier?

On 04/29/2015 10:03 AM, John McKown wrote: I am wondering about useful something might be. So I hope ya'll don't mind me throwing out for feedback. I am fairly good with standard SQL, but not the more advanced DBA things such as TRIGGERs. I am reading good book, "PostgreSQL Server Programming" t

Re: [GENERAL] PostgreSQL HA config recommendations

On 04/29/2015 10:53 AM, Alex Gregory wrote: Hello- I have been doing lots of reading and I really want to make sure that I get this HA architecture I am working on correct. I figured the best way would be to reach out to the community for advice. I am installing Cisco Jabber and want to use

Re: [GENERAL] documenting tables version control

On 05/05/2015 01:13 PM, Suresh Raja wrote: Hi All: I have tables with different versions in the same schema. Like T1a, T1b, T1c T2a, T2b, T2c, T2d ... etc. I'm interested in documenting various version of tables, may be in excel sheet or may be in another schema in the database. I

Re: [GENERAL] [pgsql-jobs] PostreSQL Engineer and DBA! Atlanta, GA

On 05/06/2015 08:11 AM, Sujit K M wrote: On Wed, May 6, 2015 at 8:35 PM, Jason May wrote: You find the description offensive? That’s interesting. You're very easily offended. I think it reads more like an Engineer than a DBA lol, you are cribbing like a third graders looking for some fr

Re: [GENERAL] Does PG support bulk operation in embedded C

On 05/19/2015 04:47 PM, Ravi Krishna wrote: To explain pls refer to this for DB2 http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0002329.html Essentially in one single sql call, we can do -- Add new rows -- Update a set of rows where each row is i

Re: [SQL] [GENERAL] Does PG support bulk operation in embedded C

On 05/19/2015 05:27 PM, Ravi Krishna wrote: Not sure whether I am understanding this. I checked embedded C and did not find any section which describes what I have asked, that is the ability to do multiple inserts, or updates or deletes in one sql call. For example, if my application does the fo

Re: [GENERAL] date with month and year

On 05/21/2015 10:01 AM, Daniel Torres wrote: I everybody, I'm new in the Postgresql world, and have an easy question: Is it possible to have date type data that only contain month and year?, how can I obtain that from a timestamp (without time zone) column? I've made this, but I think the result

Re: [GENERAL] WAL Streaming Failure PostgreSQL 9.4

On 05/28/2015 09:56 AM, Ivann Ruiz wrote: I'm trying to setup streaming replication but I'm stuck, please help! autovacuum launcher started| And then nothing else happens, please I really need help with this, I appreciate all comments. Any questions, please feel free to ask. I would like

Re: [HACKERS] Re: [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1

On 05/28/2015 12:56 PM, Robert Haas wrote: FTR: Robert, you have been a Samurai on this issue. Our many thanks. Sincerely, jD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended"

Re: [GENERAL] postgres db permissions

On 06/02/2015 10:36 AM, Steve Pribyl wrote: Good Afternoon, Built a fresh 9.3. postgres server and added some users and noticed that any user can create tables in any database including the postgres database by default. Have I missed some step in securing the default install? How exactly

Re: [GENERAL] postgres db permissions

On 06/02/2015 11:08 AM, Steve Pribyl wrote: They all look like this. CREATE ROLE dbA NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION; And how are you connecting to the database via psql? JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Center

Re: [GENERAL] postgres db permissions

On 06/02/2015 11:46 AM, Tom Lane wrote: Adrian Klaver writes: On 06/02/2015 11:04 AM, Steve Pribyl wrote: I have noted that "GRANT ALL ON SCHEMA public TO public" is granted on postgres.schemas.public. I am looking at this in pgadmin so excuse my nomenclature. Is this what is allowing wr

Re: [HACKERS] [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1

On 06/05/2015 01:56 PM, Tom Lane wrote: If we have confidence that we can ship something on Monday that is materially more trustworthy than the current releases, then let's aim to do that; but let's ship only patches we are confident in. We can do another set of releases later that incorporate

Re: [GENERAL] WAL archive "resend policy"

On 06/29/2015 12:49 PM, Edson Richter wrote: Dear all, Another question about WAR archiving: what is the "resend policy" if remote storage runs out of space? The failed archives will be resend automatically in future, or there is need for manual interation? They will be resent. Thanks,

Re: [GENERAL] PgPool Configuration Document required

On 06/30/2015 09:05 AM, Jimit Amin wrote: Dear Sir/Mam, Can I have technical documentation for configuration of PgPool? http://www.pgpool.net/mediawiki/index.php/Main_Page -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consultin

Re: [GENERAL] PgPool Configuration Document required

On 06/30/2015 09:35 AM, Jimit Amin wrote: Dear Sir, Sorry for this type of question, I have already configured PgPool but facing 3 issue. That's why I thought that I may have done wrong setup. I would suggest the pgpool mailing lists. JD -- Command Prompt, Inc. - http://www.commandprompt.c

Re: [GENERAL] Ubuntu 14.04 LTS install problem

On 07/01/2015 02:59 PM, Scott Marlowe wrote: postgresql. When I try via terminal apt-get install postgresql-9.3 there are the same messages about postgresql-common (>= 142~) ... defect packages ... This isn't really a postgresql problem this is a problem with an ubuntu machine with a broken

Re: [GENERAL] Download PostgreSQL 9.5 Alpha

On 07/03/2015 04:32 PM, Edson F. Lidorio wrote: Hello, PostgreSQL 9.5 Alpha not appear on the downloads list in [1] Where do I download for Windows? [1] http://www.enterprisedb.com/products-services-training/pgdownload#windows For those in the community who may not know, EnterpriseDB hosts

Re: [GENERAL] could not fork new process for connection: Resource temporarily unavailable

On 07/04/2015 12:19 PM, Jimit Amin wrote: ello, I have heavy transaction load production database 9.3 PPAS .Today Database is not able to give new process. I checked pg_stat_activity , there are so many transaction in waiting stage because of one procedure and lock on one table (Code inside pro

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

On 07/08/2015 12:47 PM, John McKown wrote: ​Why are they converting? Would EnterpriseDB (a commercial version of PostgreSQL which has extensions to make it a "drop in" replacement for Oracle) be a possibility? http://www.enterprisedb.com/solutions/oracle-compatibility-technology Because EDB

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 08:34 AM, William Dunn wrote: Hello Aviel, On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila mailto:avie...@gmail.com>> wrote: How can I set a highly available postgresql in a share-nothing architecture? I suggest you review the official documentation on high-availability c

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 11:04 AM, William Dunn wrote: If you dig deeper into pgpool-II you will find that it does not have failover logic. Its intention is to pool connections and distribute query load among replicas, but it cannot differentiate node failure from network partition and cannot promote a sta

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 01:21 PM, William Dunn wrote: That's pretty cool! But the intended use of watchdog is so you can have multiple pgpool-II instances and failover among them (http://www.pgpool.net/docs/latest/pgpool-en.html#watchdog) rather than failure of Postgres. In the configuration described in

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 01:37 PM, William Dunn wrote: But it appears that the fail condition for "watchdog" is the failure of a pgpool-II instance. In the configuration described in the wiki you would put a pgpool-II instance on each Postgres node, and if one of the pgpool-II instances fails it executes a

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 02:48 PM, William Dunn wrote: Maybe Linux-HA which you recommended is the more promising option for open source tool. http://www.linux-ha.org/wiki/Main_Page The Postgres resource agent appears to monitor the instance by executing 'SELECT now();' which is typically the recommended

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 07:07 PM, Tatsuo Ishii wrote: But it appears that the fail condition for "watchdog" is the failure of a pgpool-II instance. In the configuration described in the wiki you would put a pgpool-II instance on each Postgres node, and if one of the pgpool-II instances fails it executes

Re: [GENERAL] Delete rule does not prevent truncate

On 07/22/2015 06:13 AM, Tim Smith wrote: Melvin, May I point out that the manual states : "TRUNCATE quickly removes all rows from a set of tables. It has the same effect as an unqualified DELETE on each table" This is actually wrong. The end result is the same but it does not in any way have

Re: [GENERAL] Delete rule does not prevent truncate

On 07/22/2015 06:24 AM, Tim Smith wrote: Adrian, It still doesn't make much sense, especially as given the rather obscure and questionable design decision of allowing triggers to refer to truncate ops, but not allowing rules to refer to truncate ops !!! Actually it makes perfect sense becaus

Re: [GENERAL] Delete rule does not prevent truncate

On 07/22/2015 08:42 AM, Geoff Winkless wrote: On 22 July 2015 at 16:32, Joshua D. Drake mailto:j...@commandprompt.com>>wrote: This is actually wrong. The end result is the same but it does not in any way have the same effect. ​ "in any way"? ​ ​I'd say in the p

Re: [GENERAL] Delete rule does not prevent truncate

On 07/24/2015 02:32 AM, Andres Freund wrote: On 2015-07-24 10:29:21 +0100, Tim Smith wrote: That's not the point. Backups are important, but so is the concept of various layers of anti-fat-finger protection. Restoring off backups should be last resort, not first. Oh, comeon. Install a TRU

Re: [GENERAL] Postgresql upgrade from 8.4 to latest

On 07/28/2015 01:12 PM, AI Rumman wrote: Hi, I need to upgrade Postgresql database from 8.4 to latest stable version (9.4). The db size is almost 2.5 TB. Is pg_upgrade in-place is a good idea for it? With quite a bit of testing, yes. But keep in mind, it is still an outage. JD Thanks fo

Re: [GENERAL] Postgresql upgrade from 8.4 to latest

On 07/28/2015 01:35 PM, AI Rumman wrote: But what I read, in-place upgrade has smaller outage, compared to dump/restore. Correct, in fact if you do it with the link option, it will be very fast. But so many articles on having bugs afterwards. Do you think it is a good idea to use pg_upgrade

Re: [GENERAL] Synchronous replication and read consistency

On 07/29/2015 02:27 PM, Ravi Krishna wrote: "Not necessarily. There has been discussion of adding a new mode which will delay the commit on the primary until it is visible on a synchronous standby, but I don't recall where that left off. " Joshua: THis essentially contradicts your statement

Re: [GENERAL] Bi-Directional replication(BDR)

On 08/04/2015 12:47 PM, clingare...@vsoftcorp.com wrote: Hi, Please help me on: what is the use of bidirectional replication in PostgreSQL? How BDR works? how to setup BDR? on which versions BDR works? Please do not cross post. What you are looking for is here: http://bdr-project.org/do

Re: [GENERAL] Sync replication + high latency server

On 08/12/2015 05:33 PM, Edson Richter wrote: Hi! I've a situation where I would like to keep sync replication, where servers have 10Mbps network connection but high latency (normally, ~20ms but sometimes, 1000ms~2000ms, even 3000ms when network is under load). Considering that I will keep enou

Re: [GENERAL] [BDR] vs pgpool-II v3

On 08/13/2015 08:52 AM, Wayne E. Seguin wrote: "BDR is only one in Beta compare to stable options: https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling. Not sure why this solution would be chosen. Experience with pgpool is that you only needed to change a port and no

Re: [GENERAL] CentOS - PostgreSQL 9.2.13 -> 9.4

On 08/18/2015 08:01 AM, Michael H wrote: Hi, I've been tuning our new database server, here's some info... CentOS Linux release 7.1.1503 (Core) 3.10.0-229.11.1.el7.x86_64 8 x 16GB 1600MHz PC3-12800 DDR3- 128GB total 2 x AMD Opteron 6386SE 2.8GHz/16-core/140w - 32 cores total

Re: [GENERAL] CentOS - PostgreSQL 9.2.13 -> 9.4

On 08/18/2015 09:19 AM, Melvin Davidson wrote: 8 x 16GB 1600MHz PC3-12800 DDR3 - 128GB total >>shared_buffers=60GB I would say 60GB is too high when you have 128GB system memory. Try lowering it to shared_buffers=32GB and let the O/S handle more of the work. I would also loo

Re: [GENERAL] CentOS - PostgreSQL 9.2.13 -> 9.4

On 08/18/2015 09:41 AM, Alvaro Herrera wrote: Alvaro Herrera wrote: One thing to look at is the rate of WAL generation for a set number of transactions. Maybe the later releases are generating more WAL due to multixacts, for instance (prior to 9.3 these weren't wal-logged.) Also try 9.5alp

Re: [GENERAL] PostgreSQL customer list

extensively. Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone

Re: [GENERAL] PostgreSQL Developer Best Practices

On 08/24/2015 07:58 AM, John Turner wrote: On Mon, 24 Aug 2015 09:15:27 -0400, Ray Cote Point 9 is well-intentioned, but perhaps needs to be clarified/rephrased: Developers should not be creating production-grade tables devoid of well-defined business keys, period. That would be regardless o

Re: [GENERAL] PostgreSQL Developer Best Practices

On 08/24/2015 08:56 AM, Melvin Davidson wrote: >The "serial" key is the default primary key amongst every single web development environment in existence. Methinks thou doest take too much for granted. Yes, serial has it's purpose, but I sincerely doubt it is "the default primary key amongst e

Re: [GENERAL] PostgreSQL Developer Best Practices

On 08/24/2015 09:34 AM, Melvin Davidson wrote: And again, I am talking about _database_ design, not Web apps. Letting Web developers design a database to work with their app, is a very, Very, VERY bad idea. And I don't argue that but we also live in a world based on reality. DBAs are rare, web

Re: [GENERAL] PostgreSQL Developer Best Practices

On 08/25/2015 09:09 AM, Rob Sargent wrote: On 08/25/2015 09:40 AM, Melvin Davidson wrote: Adrian, Stop being so technical. When we/I speak of natural keys, we are talking about the column that would NATURALly lend itself as the primary key. No one ever said a number is not natural. just that th

Re: [GENERAL] PostgreSQL Developer Best Practices

On 08/25/2015 05:28 PM, Adrian Klaver wrote: On 08/25/2015 05:17 PM, Melvin Davidson wrote: I think a lot of people here are missing the point. I was trying to give examples of natural keys, but a lot of people are taking great delight in pointing out exceptions to examples, rather than understa

Re: [GENERAL] bdr download

On 08/31/2015 09:37 AM, Bruce Momjian wrote: On Mon, Aug 31, 2015 at 12:30:52PM -0300, Alvaro Herrera wrote: BDR is not currently part of community Postgres so you will need to report it to them directly. As discussed a year ago or so, this list is what to use for BDR reports and discussions,

Re: [GENERAL] bdr download

On 08/31/2015 12:14 PM, Bruce Momjian wrote: On Mon, Aug 31, 2015 at 09:58:36AM -0700, Joshua Drake wrote: On 08/31/2015 09:37 AM, Bruce Momjian wrote: On Mon, Aug 31, 2015 at 12:30:52PM -0300, Alvaro Herrera wrote: It clearly is being developed by 2nd Quadrant: http://bdr-project.o

Re: [GENERAL] BDR mailing list

On 09/10/2015 10:11 AM, Martín Marqués wrote: El 10/09/15 a las 13:17, Ioana Danes escribió: I could not find a mailing list for BDR/UDR so I thought to post my issue here with my hope that somebody can help me. It seems people are now looking for a specific mailing list for bdr/udr extension

Re: [GENERAL] Hiding name and version

On 09/17/2015 10:32 AM, Quiroga, Damian wrote: Hi, Is it possible to prevent users from running the “version” function or all system information functions? If so, how? You could probably revoke access to the function(s) (I haven't tried it because it seems very silly). JD -- Command Promp

Re: [GENERAL] Not storing MD5 hashed passwords

On 10/14/2015 01:31 PM, Quiroga, Damian wrote: Hi, In case someone knows… Does postgres support other (stronger) hashing algorithms than MD5 to store the database passwords at disk? No. If not, is there any plan to move away from MD5? Not currently although it has been mentioned. However

Re: [GENERAL] Where do I enter commands?

On 10/24/2015 09:19 PM, David Blomstrom wrote: I'm a writer. I studied programing and MySQL so I could create websites that I can publish my articles to. I don't have time to keep up with the endless technology - MySQL, PDO, stored procedures, PHP, JavaScript, JQuery, and on and on - especially w

Re: [GENERAL] is there any difference DROP PRIMARY KEY in oracle and postgres?

On 11/05/2015 07:52 PM, M Tarkeshwar Rao wrote: Hi, one thing in oracle is there any difference between “DROP PRIMARY KEY” used directly in oracle to drop primary key, or “DROP CONSTRAINT CDRAUDITPOINT_pk”, as first syntax is not available in postgres and we need to give primary key name as cons

Re: [GENERAL] Disk I/O Question

On 11/10/2015 10:58 AM, tbro wrote: The application is called Nable and is owned by Solarwinds http://www.n-able.com It is not uncommon for DAS to be much faster than NAS/SAN. JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support

Re: [GENERAL] Does PostgreSQL ever create indexes on its own?

On 11/12/2015 02:21 PM, Doiron, Daniel wrote: I’m troubleshooting a schema and found this: Indexes: "pk_patient_diagnoses" PRIMARY KEY, btree (id) "index_4341548" UNIQUE, btree (id) "idx_patient_diagnoses_deleted" btree (deleted) "idx_patient_diagnoses_diagnosis_type_id" btre

Re: [GENERAL] What is the general opinion on use of tablespaces

On 06/10/2016 10:20 AM, David G. Johnston wrote: Can you be more precise? A single table can only be placed onto one file system. Only if those different file systems have different physical characteristics is using a tablespace likely to be a good solution. In other scenarios having some kin

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

On 06/15/2016 01:30 PM, David G. Johnston wrote: On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne mailto:maheshpostgr...@gmail.com>>wrote: may i know recommended approach to migrate the tables from sql server to postgresql instead of using 3rd party tools ​Answering this specifical

Re: [GENERAL] PostgresSQL and HIPAA compliance

On 06/17/2016 03:03 AM, Alex John wrote: Hello, I have a few questions regarding the use of PostgreSQL and HIPAA compliance. I work for a company that plans on storing protected health information (PHI) on our servers. We have looked at various solutions for doing so, and RDS is a prime candidate

Re: [GENERAL] OT hardware recommend

On 06/18/2016 11:52 AM, Andy Colson wrote: On 06/17/2016 04:39 PM, John R Pierce wrote: On 6/17/2016 2:33 PM, John W Higgins wrote: http://www.ebay.com/itm/2U-24-bay-2-5-Supermicro-Server-X8DTH-iF-2x-Xeon-Quad-Core-32GB-RAM-SAS2-216EL1-/222132081393?hash=item33b81a92f1:g:UzYAAOSwR5dXSQVw With

Re: [GENERAL] pg_dump fundenental question

On 07/05/2016 10:10 AM, J. Cassidy wrote: Hello Adrian, appreciate the prompt reply, thank you. As stated in the original email, I want to know whether compression (whatever level) is on by default (or not) - if I supply NO extra switches/options. There is no compression by default. -- Com

Re: [GENERAL] pglogical cascading replication (chaining replication)

On 07/12/2016 07:20 AM, Nick Babadzhanian wrote: I apologize if this is wrong place to ask the question. A quote from pglogical FAQ: Q. Does pglogical support cascaded replication? Subscribers can be configured as publishers as well thus cascaded replication can be achieved by forwarding/chai

Re: [GENERAL] MediaWiki + PostgreSQL is not ready for production?

On 07/19/2016 12:20 AM, Tatsuo Ishii wrote: On 7/18/2016 9:14 PM, Tatsuo Ishii wrote: My colleague has been working on making the latest version of WordPress work with PostgreSQL (there used be a PostgreSQL plugin but it has not been maintained and does not work with the latest version of Word

Re: [GENERAL] MediaWiki + PostgreSQL is not ready for production?

On 07/20/2016 08:57 AM, John DeSoi wrote: On Jul 18, 2016, at 11:47 PM, John R Pierce wrote: Drupal even tried to offer a database API so plugin developers wouldn't touch SQL directly, but too many ignored it. I have been using Drupal with PostgreSQL for more than 10 years without too man

Re: [GENERAL] Uber migrated from Postgres to MySQL

On 07/26/2016 10:39 AM, Guyren Howe wrote: Honestly, I've never heard of anyone doing that. But it sounds like they had good reasons. https://eng.uber.com/mysql-migration/ Thoughts? Hello, I started a thread about hackers on this. Sincerely, JD -- Command Prompt, Inc. h

Re: [GENERAL] Uber migrated from Postgres to MySQL

On 07/26/2016 02:49 PM, Rakesh Kumar wrote: This is an old news. They are using mysql as a nosql to store schemaless. Basically one giant blob col. And thats where the role of mysql ends. The bulk of the processing will be in nosql. That doesn't mean they didn't bring up some very good points

Re: [GENERAL] Uber migrated from Postgres to MySQL

On 07/28/2016 10:43 AM, Scott Marlowe wrote: On Thu, Jul 28, 2016 at 11:23 AM, Alex Ignatov wrote: And? Oracle and MySql doesnt have it but can downgrade right out the box. Quick and easy. So you can swap between oracle 11 and 12 back and forth in a live environment with no downtime? Please

Re: [GENERAL] Uber migrated from Postgres to MySQL

On 07/28/2016 04:58 PM, Joe Conway wrote: On 07/28/2016 03:16 PM, Bruce Momjian wrote: Not really true. I ran into two separate cases where on older (pre 9.3 I believe) Postgres if you had hundreds of thousands of tables (in the case I remember well, it was about 500k tables) the schema dump fro

Re: [GENERAL] 9.6beta3

On 07/29/2016 09:06 AM, rob stone wrote: Hi, "The database cluster was initialized with PG_CONTROL_VERSION 942, but the server was compiled with PG_CONTROL_VERSION 960." So, could somebody tell me if the 9.6beta1 version of initdb contained an incorrect version constant? 9.3Beta3 requires a ne

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

On 08/11/2016 10:43 AM, David G. Johnston wrote: On Thu, Aug 11, 2016 at 1:13 PM, support-tiger mailto:supp...@tigernassau.com>>wrote: It would be great if the Ruby and Node drivers can be brought under the Postgres team umbrella and make them as reliable and clearly documented as th

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On 08/25/2016 07:18 AM, arnaud gaboury wrote: I am deploying mattermost on my machine following their documentation[0]. There is a public IP with a domain name (http works OK). I entered this line in pg_hab.conf: I assume you mean pg_hba.conf -- host matte

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On 08/25/2016 07:44 AM, arnaud gaboury wrote: On Thu, Aug 25, 2016 at 4:38 PM, Joshua D. Drake wrote: Did you reload PostgreSQL? That is how you tell PostgreSQL to reread the pg_hba.conf. FTR: I have deployed Mattermost and it works wonderfully. The issue is solved (see my replies). By

Re: [GENERAL] Rackspace to RDS using DMS (Postgres 9.2)

On 08/31/2016 03:41 PM, Patrick B wrote: Hi guys, I posted this question on the ADMIN list but will post here as well so more people can comment... https://www.postgresql.org/message-id/CAJNY3it_AfxJhmwMHtpiAbHG47GS5rJOAUgfHw%2BGm5OXCbUm7w%40mail.gmail.com I've got a 2.3TB Database running at Ra

[GENERAL] Thanks to the Pg community (Louisiana Flood)

Hello fellow community members, I just wanted to put out a public thanks to all the community members that sent donations to the CMD office in Baton Rouge. We received a ton of needed supplies. You can see the reference here: http://www.linuxhiker.org/2016/08/helping-lousiana.html Thanks aga

Re: [GENERAL] Online course for those who want tot contribute

On 10/06/2016 10:39 AM, Andrew Borodin wrote: Hi everyone! From time to time I teach at Ural Federal University. Currently university wants me to make up online course. They are going to put it to platform like edX or something. I do not want to do another general programming course, so I made

Re: [GENERAL] Hardware recommendations?

On 11/02/2016 10:03 AM, Steve Atkins wrote: I'm looking for generic advice on hardware to use for "mid-sized" postgresql servers, $5k or a bit more. There are several good documents from the 9.0 era, but hardware has moved on since then, particularly with changes in SSD pricing. Has anyone se

Re: [GENERAL] PHP-Shop with PostgreSQL

Hello, Drupal + Ubercart should service your needs. Sincerely, JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are ho

Re: [GENERAL] C code with embedded SQL

On 11/14/2016 10:21 AM, Poul Kristensen wrote: Can't the gcc compiler be used for the subject Without sample code and an error message there isn't much we can do here. jD I have ordered the book "Postgresql for develophers" and hope to see some examples there covering C(Gnu) with embedded S

Re: [GENERAL] PostgreSQl HA solution

On 11/30/2016 06:00 AM, Marcin Giedz wrote: Hello, Does anyone know any reliable open source HA solution with stream replication and IP live migration in case of master node failure? Recently I've been attending Fujitsu PostgreSQL webinar and they presented so called "mirroring controler" + sync

Re: [GENERAL] Overwrite pg_catalog?

On 12/01/2016 03:16 AM, Juliano wrote: Hi everyone, I tried to restore pg_catalog to my new database, but the existing pg_catalog can't be overwritten or dropped, and postgres auto creates pg_catalog when I create a new DB. So, there is a way to restore the pg_catalog to a new database? Why w

Re: [GENERAL] Create DB ends with error "FATAL: Ident authentication failed for user "postgres""

On 12/02/2016 09:58 AM, Fabricio Pedroso Jorge wrote: Hi all, /[root@vm-ora12 ~]# service postgresql-9.5 status postgresql-9.5 (pid 18507) is running.../ Why am i getting the above error while trying to create a new database? See here: http://stackoverflow.com/questions/2942485/psql-fata

Re: [GENERAL] Index size

On 12/03/2016 03:57 PM, Samuel Williams wrote: With some indexes, it looks like MySQL might not be adding all data to the index (e.g. ignoring NULL values). Does MySQL ignore null values in an index? Can we get the same behaviour in Postgres to minimise usage? What would be the recommendation he

Re: [GENERAL] PDF files: to store in database or not

On 12/06/2016 10:30 AM, Rich Shepard wrote: My thinking is to not store these documents in the database, but to store them in subdirectories outside the database. Your thoughts? Due to the widely variable size of a PDF document, I would say no. I would store the metadata and file locatio

Re: [GENERAL] PDF files: to store in database or not

On 12/06/2016 11:12 AM, Eric Schwarzenbach wrote: On 12/06/2016 01:34 PM, Joshua D. Drake wrote: On 12/06/2016 10:30 AM, Rich Shepard wrote: My thinking is to not store these documents in the database, but to store them in subdirectories outside the database. Your thoughts? Due to the

Re: [GENERAL] PDF files: to store in database or not

On 12/06/2016 11:09 AM, Moreno Andreo wrote: ... but what if database is replicated? Use a network mounted filesystem (or replicated filesystem). JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack s

Re: [GENERAL] PDF files: to store in database or not

On 12/06/2016 10:50 AM, Rich Shepard wrote: On Tue, 6 Dec 2016, Joshua D. Drake wrote: Due to the widely variable size of a PDF document, I would say no. I would store the metadata and file location. Joshua, I read your answer as "don't store them in the database, but store th

Re: [GENERAL] PDF files: to store in database or not

On 12/06/2016 11:21 AM, David Wall wrote: The advantages of storing in the database is that a DB backup will have everything, instead of a DB backup and a file system backup. Using a BLOB, you can certainly keep track of variable length PDFs. This is true but also not necessarily an advantage.

Re: [GENERAL] CRM where pg is a first class citizen?

On 12/13/2016 08:58 AM, Ivan Sergio Borgonovo wrote: Hi, I was looking for a open source CRM, PHP or python based, with a large community where Postgresql is a first class citizen. I'd prefer ease of use over features. DjangoCMS Drupal 7+ JD Thanks -- Command Prompt, Inc.

Re: [GENERAL] CRM where pg is a first class citizen?

On 12/13/2016 12:19 PM, John R Pierce wrote: On 12/13/2016 10:19 AM, Joshua D. Drake wrote: I was looking for a open source CRM, PHP or python based, with a large community where Postgresql is a first class citizen. I'd prefer ease of use over features. DjangoCMS Drupal 7+ CRM (Cus

Re: [GENERAL] Default column value

On 12/30/2016 06:46 AM, Adrian Klaver wrote: On 12/30/2016 06:38 AM, Rich Shepard wrote: test=> \d default_test Table "public.default_test" Column | Type| Modifiers +---+--- id | integer | fld_1 | character varying | To

Re: [GENERAL] HELP!!! The WAL Archive is taking up all space

On 12/09/2015 04:38 PM, FattahRozzaq wrote: Quick information, After I realize, the line "archive_command=/bin/true" is a bad decision, I have revert it back. Now I'm really confused and panic. I don't know what to do, and I don't really understand the postgresql.conf I'm a network engineer, I s

[GENERAL] Happy New Year

Welcome to 2016. Let's have another bang up year! -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone els

Re: [GENERAL] PostgreSQL GUI tools

On 01/03/2016 02:15 AM, subhan alimy wrote: Hello everyone, Is there any PostgreSQL GUI tools to pull the tables structure along with the relationships? A simple Google will show you that there are literally dozens. Much appropriated. -- View this message in context: http://postgresql.

[GENERAL] Code of Conduct: Is it time?

Hello, I had a hard time writing this email. I think Code of Conducts are non-essential, a waste of respectful people's time and frankly if you are going to be a jerk, our community will call you out on it. Unfortunately a lot of people don't agree with that. I have over the course of the las

Re: [GENERAL] Code of Conduct: Is it time?

On 01/05/2016 08:56 AM, Melvin Davidson wrote: Joshua, I have to agree that a COC is in order. But to add to that, I would like to see basic requirements when submitting a problem. IE: 1. Version of PostgreSQL 2.. O/S 3. Enough info to duplicate the problem EG: minimal schema & data

Re: [GENERAL] Code of Conduct: Is it time?

On 01/05/2016 09:06 AM, Adrian Klaver wrote: Brendan Eich fiasco Has absolutely nothing to do with a CoC. At least from my understanding of what happened. JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and developm

Re: [GENERAL] Code of Conduct: Is it time?

On 01/05/2016 11:08 AM, Roland van Laar wrote: On January 5, 2016 5:47:16 PM GMT+01:00, "Joshua D. Drake" wrote: Hello, I had a hard time writing this email. I think Code of Conducts are non-essential, a waste of respectful people's time and frankly if you are going to

Re: [GENERAL] Failing to known state

On 01/05/2016 03:09 PM, oleg yusim wrote: The question here, what is PostreSQL 9.4.5 (hosted on Linux box) behavior? Does it fail to known/secure state in these 3 cases? I tried to find the description of the way PostgreSQL fails in this regard, but didn't find much. Based on what you paste

  1   2   3   4   5   6   7   8   9   10   >