Re: [GENERAL] mild modification to pg_dump

2017-11-17 Thread John R Pierce
ch do 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-ge

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

2017-11-15 Thread John R Pierce
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-gener

Re: [GENERAL] jsonb

2017-11-14 Thread John R Pierce
onb never heard of your ORM... does it even know what postgres 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-ge

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
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
update 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

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

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

2017-11-06 Thread John R Pierce
pgsql/9.3/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 bit

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

Re: [GENERAL] How to access a second database

2017-10-31 Thread John R Pierce
ed 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/mai

Re: [GENERAL] pg_audit to mask literal sql

2017-10-30 Thread John R Pierce
thin 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
context outside 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
standalone, 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
said 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 (pgs

Re: [GENERAL] Multiple Schemas vs. Multiple Databases

2017-10-13 Thread John R Pierce
ases 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

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

2017-10-10 Thread John R Pierce
r whatever, 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/mail

Re: [GENERAL] Function to return per-column counts?

2017-09-28 Thread John McKown
part of your application code. > > cheers > > -- > Tomas Vondra http://www.2ndQuadrant.com > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > -- I just child proofed my house. But the kids still manage to get in. Maranatha! <>< John McKown

Re: [GENERAL] WAL Archive command.

2017-09-28 Thread John Britto
R}"/"${PG_XLOG_FILENAME}" NEW_COUNT=`expr $OLD_COUNT + 1` if [ "$NEW_COUNT" -ge "100" ]; then echo -e "${D}""\n""Rsync could not transfer the WAL file from Master to slave." | mail -s "ALERT - WAL Arc

[GENERAL] WAL Archive command.

2017-09-27 Thread John Britto
c? I wonder how PostgreSQL knows the changes because it maintains info in archive_status with extension as .ready and .done. Please assist. Thanks, John Britto

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-22 Thread John R Pierce
EMA fred=> 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
t way. 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
MMAND_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
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

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

2017-09-19 Thread John R Pierce
my 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

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
rface 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 -- joh

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:

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 -

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

2017-09-13 Thread John R Pierce
expensive 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 chang

Re: [GENERAL] B-tree index on a VARCHAR(4000) column

2017-09-10 Thread John Turner
On Sun, Sep 10, 2017 at 1:24 PM Tom Lane wrote: > > For every other purpose, PG just pays attention to the actual column > values' lengths. > > Thanks for elaborating, Tom. This would appear to be a(nother) case where PG represents the voice of sanity as compared with 'the other guys' : ) John

Re: [GENERAL] B-tree index on a VARCHAR(4000) column

2017-09-10 Thread John Turner
On Sun, Sep 10, 2017 at 10:42 AM Merlin Moncure wrote: > On Friday, September 8, 2017, John Turner wrote: > >> >> >> On Fri, Sep 8, 2017 at 6:57 AM Tom Lane wrote: >> >>> Ron Johnson writes: >>> > Based on LENGTH(offending_column), none

Re: [GENERAL] B-tree index on a VARCHAR(4000) column

2017-09-08 Thread John Turner
On Fri, Sep 8, 2017 at 6:57 AM Tom Lane wrote: > Ron Johnson writes: > > Based on LENGTH(offending_column), none of the values are more than 144 > > bytes in this 44.2M row table. Even though VARCHAR is, by definition, > > variable length, are there any internal design issues which would make >

Re: [GENERAL] SAP Application deployment on PostgreSQL

2017-09-08 Thread John R Pierce
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
umber. 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] Create Action for psql when NOTIFY Recieved

2017-08-29 Thread John McKown
ur custom > action. > ​Sounds like a job for "expect". https://www.tcl.tk/man/expect5.31/expect.1.html​ > > > Best regards, > -- > Daniel Vérité > -- Caution! The OP is an hyperpolysyllabicsesquipedalianist and this email may cause stress to those with hippopotomonstrosesquipedaliophobia. Maranatha! <>< John McKown

[GENERAL] Installing 9.5 doesn't create 'postgres' unix account on Cent OS 7

2017-08-28 Thread John Lawlor
tgres' user normally created by installing postgres: su - postgres su: user postgres does not exist If I install the bundled postgres that comes with Cent OS, the postgres linux account is always created. Not sure why it's not created for 9.5 Regards, John This email and any files tran

Re: [GENERAL] PG and database encryption

2017-08-22 Thread John McKown
On Tue, Aug 22, 2017 at 3:27 PM, rakeshkumar464 wrote: > Thanks John and JD. > > John: Are you telling that the backup of a database has no protection? If you use LUKS to encrypt a filesystem and then copy any file data on that filesystem to another file on an unencrypted filesystem,

Re: [GENERAL] PG and database encryption

2017-08-22 Thread John McKown
ny off-filesystem backups, which would need to be separately encrypted. LUKS is a good method, IMO, to protect the data if the media is stolen, but not for protecting the individual files from improper access. SELinux is pretty good at that. -- If you look around the poker table & don't se

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 l

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] About using IMCS moldule

2017-08-10 Thread John McKown
look at IMCS. Just one day ago (9 Aug 2017), someone put in a new file which says that it addresses the LWLocks in 9.6.3 . Perhaps if you got this newest version, this is fixed?​ -- If you look around the poker table & don't see an obvious sucker, it's you. Maranatha! <>< John McKown

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] bidirectional mapping?

2017-08-02 Thread John McKown
On Wed, Aug 2, 2017 at 10:55 AM, Chris Travers wrote: > > > On Wed, Aug 2, 2017 at 5:44 PM, John McKown > wrote: > >> Is there a simple way to do bidirectional mapping of a table with itself? >> I am thinking of a "spousal" type relationship, where it is tru

[GENERAL] bidirectional mapping?

2017-08-02 Thread John McKown
-- Veni, Vidi, VISA: I came, I saw, I did a little shopping. Maranatha! <>< John McKown

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
ing? 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, recycling bits

Re: [GENERAL] Question about paritioning

2017-07-27 Thread John R Pierce
cause 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@pos

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,

Re: [GENERAL] ODBC driver issue

2017-07-26 Thread John R Pierce
issue? 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, rec

Re: [GENERAL] Backward compatibility

2017-07-22 Thread John McKown
4-redhat-linux-gnu, co mpiled by gcc (GCC) 6.3.1 20161221 (Red Hat 6.3.1-1), 64-bit (1 row) ​ -- Veni, Vidi, VISA: I came, I saw, I did a little shopping. Maranatha! <>< John McKown

Re: [GENERAL] Logging at schema level

2017-07-20 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
like 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
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:

Re: [GENERAL] Postgresql - commercial version

2017-07-07 Thread John R Pierce
e you 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@postgres

Re: [GENERAL] Postgresql - commercial version

2017-07-07 Thread John McKown
html you might try: SELECT * FROM PRODUCT_COMPONENT_VERSION; This table does not exist in the version which I have, and so I am guessing that it would be a decent test. -- Veni, Vidi, VISA: I came, I saw, I did a little shopping. Maranatha! <>< John McKown

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

2017-07-05 Thread John R Pierce
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 subscrip

Re: [GENERAL] Imperative Query Languages

2017-07-04 Thread John Turner
iki/DATATRIEVE -John On Wed, Jul 5, 2017 at 12:22 AM, Jason Dusek wrote: > Hi All, > > This more of a general interest than specifically Postgres question. Are > there any “semi-imperative” query languages that have been tried in the > past? I’m imagining a language where something l

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

2017-06-08 Thread John R Pierce
DER BY id LIMIT 2000 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
27;s really all 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, rec

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
./configure options, 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 <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 those other tables ch

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

2017-06-05 Thread John R Pierce
bles 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
alling functions, how would 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
les inherit special attributes 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
ev box at work 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
s 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
/usr/local/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] libpg sources

2017-05-23 Thread John McKown
oesn't let you see anything. Maranatha! <>< John McKown

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 subscrip

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

2017-05-18 Thread John R Pierce
x27;d 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

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:

Re: [GENERAL] PostgrSQL server : CPU and Memory

2017-05-17 Thread John R Pierce
won't 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. -- joh

Re: [GENERAL] column names and dollar sign

2017-05-17 Thread John R Pierce
mes for system stuff, 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) To

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] Top posting....

2017-05-11 Thread John McKown
phone!​ > > Regards. > Francisco Olarte. > -- Advertising is a valuable economic factor because it is the cheapest way of selling goods, particularly if the goods are worthless. -- Sinclair Lewis Maranatha! <>< John McKown

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

2017-05-11 Thread John R Pierce
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

Re: [GENERAL]

2017-05-10 Thread John R Pierce
ON a.attcollation = co.oid AND (nco.nspname <> 'pg_catalog'::name OR co.collname <> 'default'::name) WHERE NOT pg_is_other_temp_schema(nc.oid) AND a.attnum > 0 AND NOT a.attisdropped AND (c.relkind = ANY (ARRAY['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
ne business. Sure, 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
thing 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 standalo

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

2017-05-04 Thread John R Pierce
ron: 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://www.pgadmin.org/docs4/dev/pgagent.html -- john r pierce, recycling bit

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

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

2017-05-04 Thread John R Pierce
res, I would be very 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 <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 from Postgres 10, so it

  1   2   3   4   5   6   7   8   9   10   >