Re: [GENERAL] Postgresql and github

> On Nov 9, 2017, at 9:37 AM, Poul Kristensen wrote: > > No it isn't. > > What I want to do is: > > ansible-playbook somepostgresql.yml > > and postgresql is then changed on some server > the way things are done by e.g. > github.com/oravirt/ansible-oracle You're

Re: [GENERAL] Logical decoding error

> On Nov 2, 2017, at 9:34 AM, Mark Fletcher wrote: > > Hello, > > Running Postgres 9.6.5, we're using logical decoding to take changes to the > database and propagate them elsewhere in our system. We are using the PGX Go > Postgres library, at

Re: [GENERAL] Postgresql CDC tool recommendations ?

> On Oct 5, 2017, at 10:28 AM, avi Singh wrote: > > Guys > Any recommendation on a good CDC tool that can be used to push > postgresql changes to Kafka in json format ? Not sure whether json is a constraint, but I'd look at http://debezium.io and (maybe)

Re: [GENERAL] New interface to PG from Chapel?

> On Sep 15, 2017, at 12:56 PM, Thelonius Buddha wrote: > > I’m interested to know the level of effort to build a psycopg2-like library > for Chapel: http://chapel.cray.com/ Not being much of a programmer myself, > does someone have an educated opinion on this? It looks

Re: [GENERAL] looking for a globally unique row ID

> On Sep 14, 2017, at 8:38 AM, Karl Czajkowski wrote: > > On Sep 14, vinny modulated: > >> If it is only one database, on one server, then couldn't you just >> use one sequence? >> If oyu prefix the value with some identifier of the current table >> then you cannot get

Re: [GENERAL] Schema/table replication

> On Sep 6, 2017, at 8:48 AM, Marcin Giedz wrote: > > Does pglogical support views replication as I can't find it in any > restrictions ? There's no need to replicate the contents of a view, as it doesn't contain any data. pglogical can replicate the initial schema,

Re: [GENERAL] Schema/table replication

> On Sep 6, 2017, at 6:00 AM, Marcin Giedz wrote: > > Hi, is there any way (3rd party software) to replicate particular > schema/table not the whole database with streaming replication built-in > mechanism ? I don't believe so. You can do that with logical replication

Re: [GENERAL] Create Action for psql when NOTIFY Recieved

> On Sep 4, 2017, at 10:25 PM, Nico Williams <n...@cryptonector.com> wrote: > > On Mon, Sep 4, 2017 at 4:21 PM Steve Atkins <st...@blighty.com> wrote: > > > > Me too. > > https://github.com/wttw/pgsidekick > > Select-based, sends periodic kee

Re: [GENERAL] Create Action for psql when NOTIFY Recieved

> On Sep 3, 2017, at 3:32 PM, Nico Williams wrote: > > > My principal problem with psql(1) relative to NOTIFY/LISTEN is that > psql(1) won't check for them until it has had some input on stdin. So > it will appear to do nothing when it's idle, even if there millions of

Re: [GENERAL] Would you add a --dry-run to pg_restore?

> On Aug 2, 2017, at 9:02 AM, Edmundo Robles wrote: > > I mean, to verify the integrity of backup i do: > > gunzip -c backup_yesterday.gz | pg_restore -d my_database && echo > "backup_yesterday is OK" > > but my_database's size, uncompresed, is too big more than

Re: [GENERAL] storing postgres data on dropbox

> On Jun 18, 2017, at 10:58 AM, Karsten Hilbert wrote: > > On Sun, Jun 18, 2017 at 05:30:44PM +, Martin Mueller wrote: > >> Thank for this very helpful answer, which can be >> implemented for less than $100. For somebody who started >> working a 128k Mac in the

Re: [GENERAL] Rounding Double Precision or Numeric

> On Jun 1, 2017, at 9:26 AM, Louis Battuello > wrote: > > Is the round() function implemented differently for double precision than for > numeric? Forgive me if this exists somewhere in the documentation, but I > can't seem to find it.

Re: [GENERAL] column names and dollar sign

> On May 17, 2017, at 2:02 PM, Armand Pirvu (home) > wrote: > > Hi > > Ran into the following statement > > CREATE TABLE test( > Date$ date, > Month_Number$ int, > Month$ varchar(10), > Year$ int > ); > > > While it does execute, I wonder if

Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?

> On May 7, 2017, at 9:16 AM, Adam Brusselback > wrote: > > there's also pg_agent which is a cron-like extension, usually bundled with > pg_admin but also available standalone > > https://www.pgadmin.org/docs4/dev/pgagent.html > > > -- > john r pierce, recycling

Re: [GENERAL] Can PG replace redis, amqp, s3 in the future?

> On Apr 30, 2017, at 4:37 AM, Thomas Güttler > wrote: > > Is is possible that PostgreSQL will replace these building blocks in the > future? > > - redis (Caching) > - rabbitmq (amqp) > - s3 (Blob storage) No. You can use postgresql for caching, but caches

Re: [GENERAL] mysql_config_editor feature suggestion

> On Mar 21, 2017, at 3:03 PM, Tom Ekberg wrote: > > I have been working with MySQL a bit (yes, I know, heresy) and encountered a > program called mysql_config_editor. In my opinion it does a better job of > local password management than using a ~/.pgpass file. Instead of

Re: [GENERAL] appropriate column for storing ipv4 address

> On Mar 1, 2017, at 8:39 AM, jonathan vanasco wrote: > > > I have to store/search some IP data in Postgres 9.6 and am second-guessing my > storage options. > > > The types of searching I'm doing: [...] > > 2. on tracked_ip_block, i search/join against the

Re: [GENERAL] could not translate host name

> On Feb 24, 2017, at 1:37 PM, Tom Ekberg wrote: > > I'm running postgres 9.6.2 (also happened on 9.3.14) and have a cron job that > runs hourly that runs a program that does mostly postgres SELECTs on a > different host. Occasionally I get email (not hourly) from the cron

Re: [GENERAL] How to evaluate "explain analyze" correctly after "explain" for the same statement ?

> On Feb 15, 2017, at 3:58 PM, Patrick B wrote: > > Hi all, > > I just got a quick question about warm-cache. I'm using PG 9.2. > > When I execute this statement soon after I start/restart the database: > > explain select id from test where id = 124; > > The

Re: [GENERAL] Can't restart Postgres

> On Feb 14, 2017, at 8:47 PM, Shawn Thomas wrote: > > No it doesn’t matter if run with sudo, postgres or even root. Debian > actually wraps the command and executes some some initial scripts with > different privileges but ends up making sure that Postgres ends up

Re: [GENERAL] get inserted id from transaction - PG 9.2

> On Feb 14, 2017, at 2:55 PM, Patrick B wrote: > > Hi all, > > I'm simply doing an insert and I want to get the inserted id with a select. > I'm doing this all in the same transactions. > > Example: > > BEGIN; > > INSERT INTO test (id,name,description) VALUES

Re: [GENERAL] 64 and 32 bit libpq

> On Feb 12, 2017, at 5:03 PM, Jerry LeVan wrote: > > Hello, I am trying to upgrade my postgresql ‘stuff’ to 64 bits from 32 bits. > > I am running MaxOS Sierra. > > I have built the 64 bit version of the server and have loaded > my database into the new server ( 9.6.2

Re: [GENERAL] Logging broken messages

> On Feb 6, 2017, at 9:21 AM, Rui Pacheco wrote: > > Hello, > > I’m trying to implement a version of the wire protocol but I’ve hit a > problem: whenever I send a Close Statement message to the remote, it just > hangs indefinitely. I suspect the problem could be on my

Re: [GENERAL] Testing an extension exhaustively?

> On Feb 1, 2017, at 4:03 PM, John R Pierce wrote: > > On 2/1/2017 3:39 PM, postgres user wrote: >> If I have the Postgresql server installed on my machine i.e I have all the >> bins, libs and share directories of the Postgresql and I have the libs and >> sql's installed

Re: [GENERAL] Why does this hot standy archive_command work

> On Jan 20, 2017, at 7:03 PM, bto...@computer.org > wrote: > > While learning a bit about basic hot standby configuration, I was reviewing > an article that used these parameters > > wal_level = 'hot_standby' > archive_mode = on > archive_command = 'cd .' >

Re: [GENERAL] COPY to question

> On Jan 17, 2017, at 10:23 AM, Rich Shepard wrote: > > Running -9.6.1. I have a database created and owned by me, but cannot copy > a table to my home directory. Postgres tells me it cannot write to that > directory. The only way to copy tables to files is by doing

Re: [GENERAL] Means to emulate global temporary table

> On Jan 11, 2017, at 7:02 PM, David G. Johnston > wrote: > > ​"throughout" mustn't mean "by other sessions" or this becomes unwieldy. > > Here's a mock-up: > > CREATE TABLE template_table (); > CREATE VIEW view_over_my_template_instance AS SELECT * FROM >

Re: [GENERAL] LYDB: What advice about stored procedures and other server side code?

> On Dec 27, 2016, at 2:03 PM, Guyren Howe wrote: > > I am putting together some advice for developers about getting the most out > of SQL servers in general and Postgres in particular. I have in mind the > likes of most web developers, who through ignorance or a strange

Re: [GENERAL] Importing SQLite database

> On Dec 10, 2016, at 11:32 AM, Igor Korot wrote: > > Hi, guys, > I'm working thru my script and I hit a following issue: > > In the script I have a following command: > > CREATE TABLE playersinleague(id integer, playerid integer, ishitter > char, age integer, value

Re: [GENERAL] Index size

> On Dec 3, 2016, at 3:57 PM, Samuel Williams > wrote: > > Thanks everyone for your feedback so far. I've done a bit more digging: > > MySQL in MBytes (about 350 million rows): > > index_user_event_on_what_category_id_created_at_latlng | 22806.00 >

[GENERAL] Hardware recommendations?

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 seen a more recent discussion of what someone

Re: [GENERAL] Integer fields and auto-complete clients

> On Oct 26, 2016, at 6:59 AM, Tim Smith wrote: > > Hi, > > I'm curious as to what the current advice would be in relation to > auto-complete type applications (e.g. "AJAX" type java-script "guess > as you type" applicatoins). > > In relation to text fields, I

Re: [GENERAL] PostgreSQL Database performance

> On Sep 6, 2016, at 12:08 PM, Scott Marlowe wrote: > > On Fri, Sep 2, 2016 at 9:38 PM, Pradeep wrote: >> >> max_connections = 100 >> shared_buffers = 512MB >> effective_cache_size = 24GB >> work_mem = 110100kB > > This is WAY too high for

Re: [GENERAL] PostgresSQL and HIPAA compliance

> On Jun 17, 2016, at 3: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

Re: [GENERAL] Converting Postgres SQL constraint logic to PHP?

> On Jun 10, 2016, at 1:01 PM, Ken Tanzer wrote: > > Hi. I was hoping this list might be able to offer some > help/advice/suggestions/opinions about feasibility for something I want to > implement, namely converting Postgres constraints into PHP logic. Here's the >

Re: [GENERAL] Thoughts on "Love Your Database"

> On May 20, 2016, at 1:43 PM, Guyren Howe wrote: > > On May 20, 2016, at 13:38 , Pierre Chevalier Géologue > wrote: >> >> Le 04/05/2016 18:29, Szymon Lipiński a écrit : >>> On the other hand, when I was trying to store all my logic in a >>>

Re: [GENERAL] Beta testers for database development tool wanted

> On May 11, 2016, at 11:24 PM, Martijn Tonies (Upscene Productions) > wrote: > > Hello everyone, > > I’ll just get at it right away -- > > We’re developing a database development tool called Database Workbench, it > currently supports MySQL, InterBase, Firebird,

Re: [GENERAL] CREATE EXTENSION without superuser access

> On Apr 28, 2016, at 6:44 AM, Vik Fearing <v...@2ndquadrant.fr> wrote: > > On 04/27/2016 10:22 PM, Steve Atkins wrote: >> Is there any way to install an extension either from a SQL connection or >> from a user-defined directory instead of .../extensions? >>

Re: [GENERAL] CREATE EXTENSION without superuser access

> On Apr 27, 2016, at 3:47 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > > On 04/27/2016 03:30 PM, Steve Atkins wrote: >> >>>> >>>> Is there any way to install an extension either from a SQL connection or >>>> from a user-d

Re: [GENERAL] CREATE EXTENSION without superuser access

> On Apr 27, 2016, at 2:47 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > > On 04/27/2016 01:22 PM, Steve Atkins wrote: >> I have an app that would benefit from being able to use pg_partman rather >> than doing it's own ad-hoc partition management.

[GENERAL] CREATE EXTENSION without superuser access

I have an app that would benefit from being able to use pg_partman rather than doing it's own ad-hoc partition management. Unfortunately, some of the places where the app needs to run don't have root access to the database server filesystem, so I can't install the extension in the postgresql

Re: [GENERAL] Moving Specific Data Across Schemas Including FKs

On Apr 23, 2015, at 10:09 AM, Cory Tucker cory.tuc...@gmail.com wrote: I have the need to move a specific set of data from one schema to another. These schemas are on the same database instance and have all of the same relations defined. The SQL to copy data from one table is relatively

Re: [GENERAL] Postgresql Development Options

On Apr 5, 2015, at 1:21 PM, Ray Madigan raymond.madi...@gmail.com wrote: I have been using postgresql in java off and on for many years. I now have an assignemtn where I have to build a very straight forward networked application that needs to be able to insert Array data types from a

Re: [GENERAL] The case of PostgreSQL on NFS Server (II)

On Apr 2, 2015, at 5:09 PM, Octavi Fors oct...@live.unc.edu wrote: And second, because I need the database to be accessible from two computers in the same LAN. If you do this, you will destroy your database[1]. Why not have the database running on one machine, all the time, potentially

Re: [GENERAL] Longest prefix matching CTE

On Feb 24, 2015, at 3:50 PM, Tim Smith randomdev4+postg...@gmail.com wrote: The goal being to match the longest prefix given a full phone number, e.g. 61234567890 would match australia proper 61 whilst 61134567890 would match Australia premium 6113 and 61894321010 would match

Re: [GENERAL] 4B row limit for CLOB tables

On Jan 29, 2015, at 9:53 AM, Roger Pack rogerdpa...@gmail.com wrote: On 1/29/15, Roger Pack rogerdpa...@gmail.com wrote: Hello. I see on this page a mention of basically a 4B row limit for tables that have BLOB's Oops I meant for BYTEA or TEXT columns, but it's possible the reasoning is

Re: [GENERAL] Blocking access by remote users for a specific time period

On Dec 13, 2014, at 10:38 PM, Michael Nolan htf...@gmail.com wrote: Yeah, a cron job to swap pg_hba.conf files is the best solution I've come up with so far. It's not one web app, it's closer to two dozen of them, on multiple sites. If they use persistent connections you'll also have

Re: [GENERAL] to_char(timestamp, format) is changing the year!

On Nov 30, 2014, at 1:05 PM, Stephen Woodbridge wood...@swoodbridge.com wrote: Hi, I am have a problem when I format a timestamp in that it is changing the year. This can't be right, so either I don't understand You're using IYYY which is the ISO year, which is based on Mondays or

Re: [GENERAL] Comparing results of regexp_matches

On Nov 16, 2014, at 3:52 PM, Seamus Abshere sea...@abshere.net wrote: hi, I want to check if two similar-looking addresses have the same numbered street, like 20th versus 21st. 2033 21st Ave S 2033 20th Ave S (they're different) I get an error: # select

Re: [GENERAL] installing on mac air development machine

On Oct 2, 2014, at 8:04 PM, John R Pierce pie...@hogranch.com wrote: On 10/2/2014 4:37 PM, Adrian Klaver wrote: On 10/02/2014 03:50 PM, john.tiger wrote: we've always installed on linux so need help with a new mac air running latest osx in the instructions it shows several methods: 1)

Re: [GENERAL] Async IO HTTP server frontend for PostgreSQL

On Sep 10, 2014, at 12:16 AM, Dmitriy Igrishin dmit...@gmail.com wrote: Hello, David 2014-09-10 4:31 GMT+04:00 David Boreham david_l...@boreham.org: Hi Dmitriy, are you able to say a little about what's driving your quest for async http-to-pg ? I'm curious as to the motivations, and

Re: [GENERAL] PostgreSQL Portable

On Sep 10, 2014, at 2:00 PM, Daniel Begin jfd...@hotmail.com wrote: First, I am a Newbie regarding PostgreSQL … I just started to look at PostgreSQL to implement a large GIS DB (1Tb). The data must reside in an external disk with eSATA connection and may be moved to different locations

Re: [GENERAL] Postgres 9.1 issues running data directory from VMware shared folder

On Aug 26, 2014, at 3:08 PM, Arze, Cesar ca...@som.umaryland.edu wrote: I probably should be posting to the VMware mailing list with this question but I wanted to see if anyone had any insight or suggestions here. I’ve seen many similar issues but none of the solutions proposed there

Re: [GENERAL] change the value of unix_socket_directories , must used -h /xx/xx to use the Unix domain socket

On Aug 16, 2014, at 8:49 AM, John R Pierce pie...@hogranch.com wrote: On 8/16/2014 8:41 AM, lin wrote: I change the value of unix_socket_directories in postgresql.conf , then restart the database, but it cannot connect the database used like this psql -d postgres -p 5432 , it must given the

Re: [GENERAL] change the value of unix_socket_directories , must used -h /xx/xx to use the Unix domain socket

On Aug 16, 2014, at 9:01 AM, Nick Guenther nguen...@uwaterloo.ca wrote: On August 16, 2014 11:41:02 AM EDT, lin jlu...@163.com wrote: Hi all, I change the value of unix_socket_directories in postgresql.conf , then restart the database, but it cannot connect the database used like this

Re: [GENERAL] Copying a database.

On Jul 20, 2014, at 11:09 AM, maillis...@gmail.com wrote: I send a nightly dump of my production database to a development server. A script drops the existing development database and replaces it with the current production copy. Each dev uses her own copy of the database. Is there a

Re: [GENERAL] Windows Installation User account - Correct database for us

On Jul 10, 2014, at 5:01 PM, Don Brown dbr...@msd.net.au wrote: Hello We are writing a small application and we are trying to determine if PostgreSQL is the right database for us. The application at this stage is only for a single user and commonly for persons with little computer

Re: [GENERAL] How is sorting work?

On May 30, 2014, at 5:13 PM, Quang Thoi quang_t...@symantec.com wrote: Any one knows how sorting works? I am using postgresql 9.3 and runs on Linux machines. I see different sorting order for the same set of return data. On linux machines, databases are configured the same. Database

Re: [GENERAL] Linux vs FreeBSD

On Apr 9, 2014, at 1:33 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell christofer.c.b...@gmail.com wrote: On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil franc...@teksol.info wrote: Hi all! Does PG perform that much better on

Re: [GENERAL] COPY v. java performance comparison

On Apr 2, 2014, at 12:37 PM, Rob Sargent robjsarg...@gmail.com wrote: I'm playing with various data models to compare performance and practicalities and not sure if I should be surprised by the numbers I'm getting. I hope this report isn't too wishy-washy for reasoned comment. One model

Re: [GENERAL] COPY v. java performance comparison

On Apr 2, 2014, at 1:14 PM, Rob Sargent robjsarg...@gmail.com wrote: On 04/02/2014 01:56 PM, Steve Atkins wrote: On Apr 2, 2014, at 12:37 PM, Rob Sargent robjsarg...@gmail.com wrote: Impatience got the better of me and I killed the second COPY. This time it had done 54% of the file

Re: [GENERAL] char array overhead

On Mar 31, 2014, at 8:08 AM, Rob Sargent robjsarg...@gmail.com wrote: I'm angling toward using a very wide char(1) array. Is the one-byte overhead for char(n126) applied to each element or to the array? Each element, it's a variable length type. There's probably a better way of storing

Re: [GENERAL] puzzling perl DBI vs psql problem

On Mar 13, 2014, at 12:18 PM, Susan Cassidy susan.cass...@decisionsciencescorp.com wrote: I have a weird issue that I can't figure out. If I run the exact same query through psql as through perl DBI, I get different results. I get far fewer results with DBI than through the psql

Re: [GENERAL] puzzling perl DBI vs psql problem

On Mar 13, 2014, at 1:20 PM, Susan Cassidy susan.cass...@decisionsciencescorp.com wrote: Yes, I am running with use strict. The statement I pasted in is after perl quoting, being written out by the same perl program. I just take that statement and paste it into the psql window.

Re: [GENERAL] log_statement per table

On Mar 4, 2014, at 2:19 AM, David Janssens davi...@almacom.co.th wrote: Hello, I would like to log statements that modify a small subset of tables in a databases. (not all tables, because the log files become too big in that case and I also worry about performance) I currently use

Re: [GENERAL] Replacing Ordinal Suffixes

On Mar 1, 2014, at 11:45 AM, George Weaver gwea...@shaw.ca wrote: Actually, I found that the double backslashes are required whether the E is used or not: You must be using a relatively old PG version then. Default behavior since around 9.1 has been that backslashes aren't special

Re: [GENERAL] Replacing Ordinal Suffixes

On Feb 28, 2014, at 2:04 PM, George Weaver gwea...@shaw.ca wrote: Hi list, I'm stumped. I am trying to use Regexp_Replace to replace ordinal suffixes in addresses (eg have '126th' want '126') for comparison purposes. So far no luck. I have found that SELECT

Re: [GENERAL] Replacing Ordinal Suffixes

On Feb 28, 2014, at 2:43 PM, George Weaver gwea...@shaw.ca wrote: From: Steve Atkins Maybe this? select regexp_replace('300 North 126th Street', '(\d+)(?:st|nd|rd|th)', '\1', 'gi'); Hi Steve, Thanks, but no luck: select regexp_replace('300 North 126th Street', E'(\d+)(?:st|nd

Re: [GENERAL] pgsql and asciidoc output

On Feb 11, 2014, at 2:56 PM, Bruce Momjian br...@momjian.us wrote: Someone suggested that 'asciidoc' (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format for psql, similar to the existing output formats of html, latex, and troff. Would this be useful? Less so than

Re: [GENERAL] tables ending with _copy appeared in the database

On Feb 5, 2014, at 12:50 PM, Eliott eliott...@gmail.com wrote: Dear community, I've just noticed that in one of our databases many duplicate tables had appeared all ending in _copy. These tables are owned by postgres not the db owner user, other than that they seem to be a replica from

Re: [GENERAL] PGSYSCONFDIR?

On Jan 14, 2014, at 10:58 AM, John Sutton johnericsut...@gmail.com wrote: Hi there Having spent about 2 hours trying to solve a simple problem, I think it might be worthwhile to record my efforts. Perhaps someone can point out how extremely silly I have been… or is the documentation

Re: [GENERAL] Question about memory usage

On Jan 10, 2014, at 8:35 AM, Preston Hagar prest...@gmail.com wrote: tl;dr: Moved from 8.3 to 9.3 and are now getting out of memory errors despite the server now having 32 GB instead of 4 GB of RAM and the workload and number of clients remaining the same. Details: We have been

Re: postgresql.org inconsistent (Re: [GENERAL] PG replication across DataCenters)

On Dec 10, 2013, at 8:47 AM, Wolfgang Keller felip...@gmx.net wrote: http://www.postgresql.org/docs/9.3/static/different-replication-solutions.html? Synchronous Multimaster Replication *snip* PostgreSQL does not offer this type of replication (...) Now I compare that statement with:

Re: [GENERAL] network protocol and compatibility question

On Dec 9, 2013, at 2:39 AM, Joek Hondius jhond...@rem.nl wrote: Hi All, We have been running our product on PostgreSQL for quite some time now. Started out with 7.0 I have this situation where i want to migrate my (many) PostgreSQL 8.3 databases to a new server running 9.2 In my case

Re: [GENERAL] [ADMIN] what's the efficient/safest way to convert database character set ?

On Oct 17, 2013, at 3:13 PM, Huang, Suya suya.hu...@au.experian.com wrote: Hi, I’ve got a question of converting database from ascii to UTF-8, what’s the best approach to do so if the database size is very large? Detailed procedure or experience sharing are much appreciated! The

Re: [GENERAL] Forms for entering data into postgresql

On Oct 11, 2013, at 8:57 AM, Bret Stern bret_st...@machinemanagement.com wrote: My interpretation of Forms these days are written in HTML means most interfaces are web front ends to the cloud. Not a GUI framework. Yup. But embedding an HTML renderer in your desktop app does allow you to

Re: [GENERAL] oids on disk not in pg_class

On Oct 7, 2013, at 2:48 PM, Guy Rouillier guy.rouill...@gmail.com wrote: We have a fairly large (1 TB) database we put on all SSDs because of a very high insert and update rate (). As our business has grown, we've been running into space constraints, so we went looking for files we might

Re: [GENERAL] Download specific Postgres.App version

On Sep 18, 2013, at 7:40 AM, Gordon Ross gr...@ucs.cam.ac.uk wrote: On the postgresapp.com you can only download the latest version of Postgres for the Mac. Is it possible to download a specific version? There are tagged builds on github - https://github.com/PostgresApp/PostgresApp/releases

Re: [GENERAL] Constraint exclusion and overlapping range checks

On Sep 7, 2013, at 7:20 AM, Tom Lane t...@sss.pgh.pa.us wrote: Alban Hertroys haram...@gmail.com writes: On Sep 7, 2013, at 6:54, Steve Atkins st...@blighty.com wrote: If I have a partitioned table that has some range constraints that look kinda like they're intended for constraint

[GENERAL] Constraint exclusion and overlapping range checks

If I have a partitioned table that has some range constraints that look kinda like they're intended for constraint exclusion, but aren't quite non-overlapping, will that break anything? e.g. create table jan ( …, check(created = '2013-01-01' and created '2013-02-01'), check(id =0 and id

Re: [GENERAL] Constraint exclusion and overlapping range checks

On Sep 6, 2013, at 9:37 PM, François Beausoleil franc...@teksol.info wrote: Le 2013-09-07 à 00:29, Steve Atkins a écrit : If I have a partitioned table that has some range constraints that look kinda like they're intended for constraint exclusion, but aren't quite non-overlapping

Re: [GENERAL] batch insertion

On Aug 24, 2013, at 5:15 PM, Korisk kor...@yandex.ru wrote: Hi! I want quick insert into db a lot of data (in form of triplets). Data is formed dynamical so COPY is not suitable. COPY works just fine for dynamically generated data, and it's probably the right thing to use if you're bulk

Re: [GENERAL] PostrgreSQL Commercial restrictions?

On Aug 7, 2013, at 8:23 AM, Eliseo Viola eliseo.vi...@vodemia.com wrote: Hello. I have been reading the -http://opensource.org/licenses/postgresql- to know if i can use PostgreSQL in a Privative Closed Commercial Software (The worst of the worst :P ). in the company where i work. Is

Re: [GENERAL] Sharing data directories between machines

On Aug 6, 2013, at 10:45 AM, JD Wong jdmsw...@gmail.com wrote: Hi all! I have two servers, which share a large mounted drive. I would like to share postgres databases between them dynamically so that when one makes changes, they are immediately available in the other. I tried

Re: [GENERAL] Why are stored procedures looked on so negatively?

On Jul 25, 2013, at 1:44 AM, Some Developer someukdevelo...@gmail.com wrote: When I was talking about improving speed I was talking about reducing load on the app servers by putting more of the work load on the database server. I know that it won't actually save CPU cycles (one of the

Re: [GENERAL] dataset lock

On Apr 16, 2013, at 7:50 AM, Philipp Kraus philipp.kr...@flashpixx.de wrote: Hello, I use a PG database on a HPC system (cluster). My processes get a dataset from the database and change the row, each process is independend. My table shows something like: id, status, data id = PK a

Re: [GENERAL] crash proof for semi-embedded system

On Apr 11, 2013, at 5:11 AM, David Welton davidnwel...@gmail.com wrote: Hi, I'm going to be deploying Postgres in a semi-embedded system where end users might simply power the thing off from one moment to the next. Or the disk might start to go wonky, or any number of other problems.

Re: [GENERAL] When did this behavior change (and where else might it bite me)?

On Mar 18, 2013, at 9:49 AM, Jeff Amiel becauseimj...@yahoo.com wrote: In prepping for an upgrade to 9.2.3, I stumbled across this: CREATE TABLE foo ( myint integer, string1 text, string2 text ) WITH ( OIDS=FALSE ); insert into foo values (12345,'Y','N'); select * from

Re: [GENERAL] Testing Technique when using a DB

On Mar 12, 2013, at 8:41 AM, Perry Smith pedz...@gmail.com wrote: One choice would be to create the database, use it, and then drop it for each test. I would create the database from a template that already has data taken from the production database (and probably trimmed down to a

Re: [GENERAL] Installing PostgreSQL on OSX Server

On Jan 28, 2013, at 6:45 AM, Stephen Cook scli...@gmail.com wrote: Hello! I have convinced a client to use PostgreSQL instead of MySQL (hooray), which means it falls on me to install and configure it. I'm planning on doing this from the command line (I have SSH access). I have

Re: [GENERAL] Installing PostgreSQL on OSX Server

On Jan 28, 2013, at 8:47 AM, Stephen Cook scli...@gmail.com wrote: On 1/28/2013 11:15 AM, Steve Atkins wrote: You're not planning on using this in production, I hope? OS X is a very solid desktop OS, but it's server variant is packed full of weird and plain broken behaviour. Ouch

Re: [GENERAL] Where Can I Find...

On Jan 25, 2013, at 8:21 AM, Gene Poole gene.po...@macys.com wrote: I'm looking for a detailed tutorial on how to move a Oracle 11gR2 database that consists on 4 instances with table spaces spread across multiple file systems to PostgreSQL. I need to do this because most of the open source

Re: [GENERAL] Best method to compare subdomains

On Jan 16, 2013, at 12:23 PM, Robert James srobertja...@gmail.com wrote: Is there a recommended, high performance method to check for subdomains? Something like: - www.google.com is subdomain of google.com - ilikegoogle.com is not subdomain of google.com There are many ways to do this

[GENERAL] VALUES() evaluation order

Is the order in which the expressions in a VALUES() clause defined? I'm doing this: INSERT INTO foo (a, b) VALUES (nextval('bar'), currval('bar')) It works fine, but I'm wondering whether it's guaranteed to work or whether I'm relying on an artifact of the implementation. Cheers, Steve --

Re: [GENERAL] VALUES() evaluation order

On Jan 13, 2013, at 2:36 PM, Tom Lane t...@sss.pgh.pa.us wrote: Steve Atkins st...@blighty.com writes: Is the order in which the expressions in a VALUES() clause defined? I'm doing this: INSERT INTO foo (a, b) VALUES (nextval('bar'), currval('bar')) It works fine, but I'm wondering

Re: [GENERAL] Linux Distribution Preferences?

On Jan 13, 2013, at 10:27 AM, Shaun Thomas stho...@optionshouse.com wrote: Hey guys, I'm not sure the last time I saw this discussion, but I was somewhat curious: what would be your ideal Linux distribution for a nice solid PostgreSQL installation? We've kinda bounced back and forth

Re: [GENERAL] Securing .pgpass File?

On Oct 1, 2012, at 10:26 AM, Shaun Thomas stho...@optionshouse.com wrote: On 10/01/2012 12:19 PM, Darren Duncan wrote: You should never put your passwords (or private keys) in source control; it would be better to use the puppet/bcfg option. That was kind of my point. Puppet / Bcfg2 have

Re: [GENERAL] Official C++ API for postgresql?

On Sep 17, 2012, at 11:58 AM, niXman i.nix...@gmail.com wrote: Hello, Tell me please, whether there is an official C++ API for postgresql? http://pqxx.org/development/libpqxx/ is the main C++ specific library. But you can also use libpq from C++, and for simpler work it's often easier than

Re: [GENERAL] Too far out of the mainstream

On Aug 31, 2012, at 12:45 PM, Scott Marlowe scott.marl...@gmail.com wrote: So do they ever go to a site that ends in .org or .info? Tell them to stop it right now, as they are relying on PostgreSQL for those sites to resolve, and PostgreSQL is too far out of the mainstream. Once they've

Re: [GENERAL] Too far out of the mainstream

On Aug 31, 2012, at 4:15 PM, Scott Marlowe scott.marl...@gmail.com wrote: Unless things have changed, Andrew Sullivan in this message http://archives.postgresql.org/pgsql-advocacy/2002-09/msg00012.php says: All interactions with the shared registry system, and any whois queries against

  1   2   3   4   5   >