Re: [GENERAL] mild modification to pg_dump

2017-11-17 Thread John R Pierce
that, and his password. (My apps are using that same data, of course, encripted to the common users). I would just fork pg_dump to do the actual dump rather than try and incorporate its source code into your app. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general

Re: [GENERAL] Setting up replication slave on remote high latency host

2017-11-15 Thread John R Pierce
to start. you can't use pg_dump to create a slave, as it won't have the same timeline. I would use pg_basebackup, but in general streaming replication over a high latency erratic link will never work real well. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing

Re: [GENERAL] jsonb

2017-11-14 Thread John R Pierce
s jsonb is ?   do you know what actual SQL query that piece of ORMism generates ? -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Migrating plattaform

2017-11-12 Thread John R Pierce
can't copy binary database files between architectures, as various data structures have different binary representations. sure, pg_dump  -Fc | pg_restore, that works fine across architectures. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] OpeSSL - PostgreSQL

2017-11-09 Thread John R Pierce
On 11/9/2017 1:59 PM, chiru r wrote: How to configure the PostgreSQL to allow specif cipher suites from different client applications? see https://www.postgresql.org/docs/9.5/static/ssl-tcp.html -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] database size changed after restoring using pg_restore

2017-11-08 Thread John R Pierce
.   databases that get updates (or inserts/deletes) tend to bloat. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Because PostgreSQL is compiling in old versions of OS?

2017-11-08 Thread John R Pierce
un on RHEL7/CentOS7 if you install the corresponding -compat libraries, but thats about as good as it gets. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Incremental refresh - Materialized view

2017-11-07 Thread John R Pierce
the table underlying a given materialized view. I'm sure i'm not thinking of major aspects complicating this. [1] https://www.postgresql.org/docs/current/static/logicaldecoding-explanation.html -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Incremental refresh - Materialized view

2017-11-06 Thread John R Pierce
refresh a materialized view with REFRESH MATERIALIZED VIEW name;    There's no 'incremental' methods, as views can be quite complex. I do not know what you mean by 'materialized view log', is this a feature of some other database server ? -- john r pierce, recycling bits in santa cruz -- Sent

Re: [GENERAL] Postgresql 9.3 service doesn't start on RedHat Linux 6.8

2017-11-06 Thread John R Pierce
data/(latest).log  ? -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [HACKERS] SSL and Encryption

2017-11-02 Thread John R Pierce
On 11/2/2017 10:12 PM, Jeff Janes wrote: https://wiki.postgresql.org/wiki/List_of_drivers What is 'python native'?  psycopg works as long you update your libpq. I thought pythonistas preferred using a native driver that didn't use libpq ? -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] [HACKERS] SSL and Encryption

2017-11-02 Thread John R Pierce
that says...  ... [scram-sha-256] is the most secure of the currently provided methods, but it is not supported by older client libraries whats the state of the more popular bindings now?   jdbc, python native, etc ? -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] How to access a second database

2017-10-31 Thread John R Pierce
On 10/31/2017 12:41 AM, John R Pierce wrote: if you're doing a lot of this, why not use two schema in the same database?  then its just ...schema.table... otherwise, you need to use FDW and foreign tables. see https://www.postgresql.org/docs/current/static/postgres-fdw.html oh, I

Re: [GENERAL] How to access a second database

2017-10-31 Thread John R Pierce
to use FDW and foreign tables. see https://www.postgresql.org/docs/current/static/postgres-fdw.html -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] pg_audit to mask literal sql

2017-10-30 Thread John R Pierce
their domain.   QA should be working on development or staging databases. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Can't build ODBC -- odbc_config not found

2017-10-27 Thread John R Pierce
ODBC build) You need to install unixODBC package (or equivalent in your distro) for this command. and on a RHEL style system, you probably also need unixODBC-devel  to compile the psqlodbc driver. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] using conda environment for plpython3u?

2017-10-23 Thread John R Pierce
the DB server. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)

2017-10-19 Thread John R Pierce
, and managed by SQL statements. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Is it OK to create a directory in PGDATA dir

2017-10-19 Thread John R Pierce
PGDATA. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)

2017-10-19 Thread John R Pierce
On 10/19/2017 3:15 PM, Juliano wrote: Omnidb looks nice, but, I guess doesn't support pgAgent as well, any suggestions? pgAgent isn't part of postgres, its part of pgAdmin. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Multiple Schemas vs. Multiple Databases

2017-10-13 Thread John R Pierce
atabases onto separate servers for performance reasons.   Of course, to access the 'other' database, you'd need to use postgres_fdw or dblink. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

Re: [GENERAL] core system is getting unresponsive because over 300 cpu load

2017-10-10 Thread John R Pierce
, then thats another story, but generally doing that sort of thing does NOT use 1000 connections. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Adding Cyrillic support

2017-09-23 Thread John R Pierce
On 9/23/2017 1:44 AM, Job wrote: how can i add more character support to PostgreSql 9.6? I need to also store some information in Cyrillic, for Russian users. Can more characters coexist in the same database? utf-8 should be able to store just about any character. -- john r pierce

Re: [GENERAL] Why can't the database owner create schemas and how can I enable that?

2017-09-23 Thread John R Pierce
gt; create table xyzzy.abc (id serial, dat text); CREATE TABLE fred=> \q . -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] libpq confusion

2017-09-20 Thread John R Pierce
nds that can never return rows (INSERT,UPDATE, etc.). A response ofPGRES_EMPTY_QUERYmight indicate a bug in the client software. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

2017-09-20 Thread John R Pierce
. for web apps?   how does a web browser do kerberos over http ? -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] libpq confusion

2017-09-20 Thread John R Pierce
y curious - isn't it what "PGRES_COMMAND_OK" for? IIUC, this constant indicates successful query run, but no records was generated. Or am I missing something and I will have to check PQntuples()? a query that returns zero rows is still successful. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

2017-09-19 Thread John R Pierce
? the user isn't accessing the database, the application itself is accessing the database.   a web app might have 10s of 1000s of unique users, but a web app typically only uses a single application account to access the database. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql

Re: [GENERAL] [HACKERS] USER Profiles for PostgreSQL

2017-09-19 Thread John R Pierce
database servers, the only 'users' connecting to them directly are the database administrators...  the applications connect with application accounts, and if more security is required, these use certificates, or they use unix 'ident' local connections. -- john r pierce, recycling bits in santa

Re: [GENERAL] advisory locks namespace?

2017-09-17 Thread John R Pierce
On 9/17/2017 1:33 PM, Rob Nikander wrote: Am I right if two applications use advisory locks in the same database, they need to know which lock numbers are used to by the other application, to avoid conflicts? indeed.   it also depends if they want to honor each others locks. -- john r

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

2017-09-15 Thread John R Pierce
frameworks to hang a SQL library/driver on. the fact that its a heavily concurrent/parallel language would likely mean there's many boobytraps en route to successfully using SQL, as you need to ensure that one PG connection is only ever used by the thread that created it -- john r pierce

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

2017-09-14 Thread John R Pierce
. guarantees persistence of value across database backup/restore/upgrade. isn't that the problem that GUID are supposed to answer ? -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Postgres DB is failed due to pg_Xlog is continues full.

2017-09-13 Thread John R Pierce
If any command is require to execute please let me know. you're going to need an experienced postgres admin who understands low level disk recovery.    there's a variety of postgres businesses who offer such services for hire. -- john r pierce, recycling bits in santa cruz -- Sent via

Re: [GENERAL] Postgres DB is failed due to pg_Xlog is continues full.

2017-09-13 Thread John R Pierce
proposition. before doing anything, you should make a complete backup of the $PGDATA directory (and other tablespace directories, if you use any). -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] SAP Application deployment on PostgreSQL

2017-09-08 Thread John R Pierce
of SAP application deployment on PostgreSQL? Does SAP support PostgreSQL ? -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] column names query

2017-09-07 Thread John R Pierce
. there are equivalent functions in most other APIs. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Corrupt index

2017-08-15 Thread John R Pierce
On 8/15/2017 1:07 PM, Andreas Kretschmer wrote: I only wanted to exclude it. Anyway, you should install the latest patches. he can't, with RDS, he's at the mercy of Amazon for all sysadmin duties. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] pglogical repo

2017-08-10 Thread John R Pierce
[ ] pglogical-rhel-1.0-3.noarch.rpm 1.0-3 is for Postgres 9.6 ? Or can it be used on 9.5 as well ? I am on 9.5 That is clearly answered here, https://www.2ndquadrant.com/en/resources/pglogical/pglogical-installation-instructions/ -- john r pierce, recycling bits in santa cruz -- Sent via pgsql

Re: [GENERAL] Audit based on role

2017-08-07 Thread John R Pierce
/wiki/Audit_trigger, but I am not sure on how to integrate "user whose has module_dml role granted" into the function. Instead of trigger is there any better way to achieve this? DML as in select/insert/update/delete ? or did you mean DDL as in CREATE/ALTER TABLE, etc ? -- joh

Re: [GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n

2017-07-30 Thread John R Pierce
rows) for instance, all my databases are UTF8 on that server. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Invalid byte sequence for encoding UTF-8 0xc3\n

2017-07-30 Thread John R Pierce
in what encoding? in ISO 8859-1, -15, beta aka sharp S is code 223 (U+00DF), not 225. in UTF-8, its C3,9F. ... Both the database and the table are created with default encoding. what encodings are default on your system ?`\l+` in psql should show the encodings. -- john r pierce, re

Re: [GENERAL] Question about paritioning

2017-07-27 Thread John R Pierce
the planner can't guess correctly. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Question about paritioning

2017-07-26 Thread John R Pierce
typically do it by the week, as we're doing 6 month data retention. IIRC, we're using DATE_TRUNC('week', timestamp)::DATE for use as the partition label and key. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] ODBC driver issue

2017-07-26 Thread John R Pierce
On 7/26/2017 9:06 PM, Igor Korot wrote: With the char(), is there a "Standard SQL" way to do trimming? trim(trailing from fieldname) but really, if you want a variable length string without padding, don't use CHAR() as a data type. use VARCHAR or TEXT. -- john r pierce, recy

Re: [GENERAL] ODBC driver issue

2017-07-26 Thread John R Pierce
e? Maybe its already fixed with the latest ODBC driver? a char(129) field is 129 characters long, and will always be padded with spaces to that length. maybe you wanted a varchar (aka char varying) ? these are variable length and return just what you put in them. -- john r pierce, recyclin

Re: [GENERAL] Logging at schema level

2017-07-21 Thread John R Pierce
schemas. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Logging at schema level

2017-07-20 Thread John R Pierce
would that get logged? -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Backward compatibility

2017-07-20 Thread John R Pierce
100100 if its 10.1, or 11 ? -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Backward compatibility

2017-07-20 Thread John R Pierce
, and version 8.2 will be returned as 80200 (leading zeroes are not shown). Zero is returned if the connection is bad. Actually invokes `show server_version_num;' -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Backward compatibility

2017-07-20 Thread John R Pierce
On 7/20/2017 7:46 PM, Igor Korot wrote: ALso, I presume there is no special libpg function, right? libpq would only be able to return the libpq version, which might not be the same as the server version. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing

Re: [GENERAL] What is exactly a schema?

2017-07-14 Thread John R Pierce
, and have all your common tables in PUBLIC, then it will just fall out. you'll need to be careful with permissions, of course. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Postgresql - commercial version

2017-07-07 Thread John R Pierce
in. also, see what path postgres's tools are installed in, the RPM versions install everything in /usr/pgsql-9.x/bin while EDB typically installs to /opt or something. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Is PL-PGSQL interpreted or complied?

2017-07-05 Thread John R Pierce
that? the interpreter *IS* SQL, which is the whole database server. I don't think a standalone plpgsql without SQL would be of much use. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Function with limit and offset - PostgreSQL 9.3

2017-06-08 Thread John R Pierce
RETURNING id) UPDATE tablea a SET a.migrated=TRUE WHERE a.id = ids.id RETURNING COUNT(a.id); I'm not 100% sure you can do UPDATE RETURNING COUNT(...), worse case the UPDATE RETURNING would be a subquery of a SELECT COUNT()... -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Function with limit and offset - PostgreSQL 9.3

2017-06-08 Thread John R Pierce
you're doing, why not do it all at once, instead of row at a time? BEGIN; insert into tableb (id) select id from tablea; update tablea set migrated=true; COMMIT; thats far more efficient that the row-at-a-time iterative solution you showed. -- john r pierce, recycling bits in santa

Re: [GENERAL] Db backup

2017-06-08 Thread John R Pierce
On 6/8/2017 12:29 PM, John R Pierce wrote: On 6/8/2017 12:10 PM, Jimmy Lunceford wrote: A windows 7 computer went bad but the hdd is still operable. Is there a way to transfer the db data directories to another computer or does it require a dump and restore? the data directories should work

Re: [GENERAL] Db backup

2017-06-08 Thread John R Pierce
, etc etc). -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)

2017-06-05 Thread John R Pierce
On 6/5/2017 5:49 PM, David G. Johnston wrote: On Mon, Jun 5, 2017 at 5:40 PM, John R Pierce <pie...@hogranch.com <mailto:pie...@hogranch.com>>wrote: ​i​ ndeed, any sort of constraint that invokes a function call which looks at other tables could later be invalidated if

Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)

2017-06-05 Thread John R Pierce
r tables change, and postgres would be none the smarter. the same goes for trigger based checks. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)

2017-06-05 Thread John R Pierce
it know what order to check things in ? -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Access Management question

2017-05-30 Thread John R Pierce
like SUPERUSER, CREATEDB. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Installing module for 9.6, not 9.2, on Centos?

2017-05-24 Thread John R Pierce
that runs pg 9.3, 9.4, 9.5, and 9.6, all on seperate ports. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Have just libpg installer

2017-05-23 Thread John R Pierce
for Mac OSX should install libpq.dylib and the appropriate .h files etc. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Installing module for 9.6, not 9.2, on Centos?

2017-05-23 Thread John R Pierce
/pgsql96/bin ? does /usr/pgsql-9.6/bin/pg_config output a whole pile of directory assignments that make sense ? or does /usr/local/pgsql96/bin/pg_config do that? -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Weird periodical pg log

2017-05-19 Thread John R Pierce
as OmniBack. That comprehensive backup system includes database backup capabilities, I'm guessing thats what you're seeing here. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Call for users to talk about table partitioning

2017-05-18 Thread John R Pierce
expect from a GUI management tool would be to allow me to create partitioned tables and its partitions, and display their attributes appropriately. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Error that shouldn't happen?

2017-05-18 Thread John R Pierce
? +1 we create new partitions in advance of their being needed as part of a maintenance process that's strictly single threaded. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] PostgrSQL server : CPU and Memory

2017-05-17 Thread John R Pierce
work on non-Linux systems, even other Unix systems like BSD don't have the same /proc stuff, and other OS's like Windows don't have /proc at all. if you don't know whether that's what you need, I'm not sure how we could know what you need. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] column names and dollar sign

2017-05-17 Thread John R Pierce
, SYS$BLAHBLAH or whatever. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] storing large files in database - performance

2017-05-16 Thread John R Pierce
On 5/16/2017 5:25 AM, Eric Hill wrote: I do have the Sequelize ORM and the pg driver in between my code and the database. Can you try a similar test without the ORM, just going straight from node.js to sql ? -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general

Re: [GENERAL] storing large files in database - performance

2017-05-16 Thread John R Pierce
On 5/16/2017 7:35 AM, Thomas Kellerer wrote: When my (JDBC based) SQL client and the database server are on the same computer... node.js is Javascript, not java w/ jdbc -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread John R Pierce
On 5/14/2017 2:20 PM, Joshua D. Drake wrote: A bit outdated but: http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.html the advice on that page to unlink a library in /lib64 on an RPM managed system makes me very leery of the rest of the article. -- john r pierce

Re: [GENERAL] How to recover my postgres database ?

2017-05-11 Thread John R Pierce
for each day of the week, so you have 7 days backup history, change the parameter of the d=`date... line if you want a different backup rotation scheme, and of course, dst is the destination -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (

Re: [GENERAL] How to recover my postgres database ?

2017-05-11 Thread John R Pierce
the default? psql template1 -c "drop database postgres; create database postgres with template template0" should restore it to a virgin stock empty 'postgres' -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To ma

Re: [GENERAL]

2017-05-10 Thread John R Pierce
['r'::"char", 'v'::"char", 'f'::"char"])) AND (pg_has_ role(c.relowner, 'USAGE'::text) OR has_column_privilege(c.oid, a.attnum, 'SELECT, INSERT, UPDATE, REFERENCES'::text)); -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Python versus Other Languages using PostgreSQL

2017-05-10 Thread John R Pierce
, largest web SITES by traffic, usage. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

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

2017-05-05 Thread John R Pierce
ing I'd do on that server (or even at work) this is easily fast enough. S3 is often used for terabyte to petabyte file collections. I would not want to burden my relational database with this. -- john r pierce, recycling bits in santa cruz

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

2017-05-04 Thread John R Pierce
On 5/4/2017 2:50 PM, John R Pierce wrote: But there's an extension - pg_cron: https://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/ there's also pg_agent which is a cron-like extension, usually bundled with pg_admin but also available standalone https

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

2017-05-04 Thread John R Pierce
://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/ 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 bits in santa cruz

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

2017-05-04 Thread John R Pierce
On 5/4/2017 2:28 PM, Alan Hodgson wrote: On Thursday 04 May 2017 14:21:00 John R Pierce wrote: or EBS, and I've heard from more than a few people that EBS can be something of a sand trap. Sorry for following up off-topic, but EBS has actually improved considerably in the last few years. You

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

2017-05-04 Thread John R Pierce
hesitant to storage LARGE amounts of bulk data directly in postgres -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Compatibility of libpg

2017-05-04 Thread John R Pierce
On 5/4/2017 2:19 AM, Magnus Hagander wrote: On Wed, May 3, 2017 at 11:31 PM, John R Pierce <pie...@hogranch.com <mailto:pie...@hogranch.com>> wrote: On 5/3/2017 2:20 PM, Magnus Hagander wrote: Please note that this method of building libpq has been removed f

Re: [GENERAL] Compatibility of libpg

2017-05-03 Thread John R Pierce
be updated then. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Language support of postgresql

2017-05-02 Thread John R Pierce
On 5/2/2017 11:41 AM, Tom Lane wrote: John R Pierce<pie...@hogranch.com> writes: I thought Postgres supported client_encodings of BIG5, GB18030, and GBK, all of which can be stored in the server using either UTF8 or MULE_INTERNAL (MultiLingual EMACS) encodings for internal storage

Re: [GENERAL] Language support of postgresql

2017-05-02 Thread John R Pierce
without incurring big cost. I thought Postgres supported client_encodings of BIG5, GB18030, and GBK, all of which can be stored in the server using either UTF8 or MULE_INTERNAL (MultiLingual EMACS) encodings for internal storage ? -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Compatibility of libpg

2017-05-01 Thread John R Pierce
as outlined in 17.1.1 ... 17.1.3 discusses a mkvcbuild.pl which makes a pgsql.sln project(?) for Visual Studio -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Compatibility of libpg

2017-05-01 Thread John R Pierce
. static linking to runtime libraries like this is strongly discouraged. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Compatibility of libpg

2017-05-01 Thread John R Pierce
directly calling libpq functions, libpq.dll and libpq-fe.h should be all you need, along with the couple .h files libpq-fe references, afaik, thats just pg_config_ext.h and postgres_ext.h -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread John R Pierce
should not need commit. the one big thing I don't see mentioned in your list above is monitoring replication -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Questions regarding JSON processing

2017-04-25 Thread John R Pierce
ns as well as data, I'd be rather cautious of letting a remote client send that directly to the database server unless you can ensure that nothing hostile can be done with it, or completely trust all clients. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing l

Re: [GENERAL] Total ram size study

2017-04-22 Thread John R Pierce
.* entirely dependent on your data set and workload.if the working set fits in 2GB, then more memory likely won't do that much. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] pg_basebackup issue

2017-04-22 Thread John R Pierce
membership only inherits object rights, like grant . on table ... to role. it doesn't inherit role attributes like SUPERUSER, or REPLICATION. you need to ALTER ROLE to add these to each role. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-21 Thread John R Pierce
On 4/21/2017 2:13 PM, Edson Lidorio wrote: Apr 21 18:11:41 localhost postgresql96-check-db-dir: "/var/lib/pgsql/9.6/data/" is missing or empty. whats there? ls -la /var/lib/pgsql/9.6/data -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-21 Thread John R Pierce
postgres.postgres /path/to/data -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-21 Thread John R Pierce
//PG_VERSION in particular the // Is that really the case? unix/linux seems quite happy to ignore extra /'s ... # ls -l /var/lib/pgsql/9.3/data//PG_VERSION -rw---. 1 postgres postgres 4 May 22 2014 /var/lib/pgsql/9.3/data//PG_VERSION -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] Recover corrupted data

2017-04-19 Thread John R Pierce
you can turn this behavior off, depending on the brand and model drive, but do note it will slow your system down a fair bit. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Large data and slow queries

2017-04-19 Thread John R Pierce
if the planner can figure out which partitions to use in advance, otherwise it ends up having to scan all the partitions. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Large data and slow queries

2017-04-18 Thread John R Pierce
r if you use the native POINT type, and compared it like mypoint <@ BOX '((174.6307139779924,-37.03079375089291),(175.0805140220076,-36.67086424910709 ))' with a gist index on mypoint... but, it all hinges on which clauses in your query are most selective, thats where you want an index. -

Re: [GENERAL] Error During PostGIS Build From Source on Linux

2017-04-15 Thread John R Pierce
the packages that refer to these libraries. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Error During PostGIS Build From Source on Linux

2017-04-12 Thread John R Pierce
{,-server,-devel,-contrib} postgis2_95{,-devel,-utils} -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

  1   2   3   4   5   6   7   8   9   10   >