Re: Foreign Data Wrapper

uld be used to do an update. this updated fork, https://github.com/CartoDB/odbc_fdw  runs on newer postgres, but also is based on a select statement, you can't UPDATE a resultset... -- john r pierce, recycling bits in santa cruz

Re: [weewx-user] Re: Acurite (ugh), and weewx ona RasbPi.

On 12/16/2017 3:26 AM, John Pierce wrote: ah, I moved it about 2 feet to the bookshelf, and wow, got this in the past 24 hours.   much much better! he

Re: pgbench

ats totally configurable with commandline parameters, from a few dozen kilobytes to many gigabytes. -- john r pierce, recycling bits in santa cruz

Re: Can postgresql ignore DST ?

ll input time values to UTC, and store it in an internal representation, and on output, they are converted to the client's current TIMEZONE. -- john r pierce, recycling bits in santa cruz

Re: [weewx-user] Re: Acurite (ugh), and weewx ona RasbPi.

On 12/13/2017 9:03 AM, Andy wrote: I switched to the USB SDR receiver so no longer using the USB console connection. This driver <%20%20https://github.com/matthewwall/weewx-sdr> and a $10 receiver from aliexpress like this

Re: PostgreSQL Client on SUSE Enterprise Linux Server 11.

package, and includes/depends on postgresdql-libs which are the runtime libaries. -- john r pierce, recycling bits in santa cruz

Re: [CentOS] LUKS question

k encryption in general is an admin headache with severe penalty for error. -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos

Re: PG Schema to be used as log and monitoring store

On 12/9/2017 5:46 PM, Stefan Keller wrote: Below I re-modeled it to a relational schema as you suggested and also tried to utilize the INHERITS feature. Does that look better? I believe I would use boolean, not bit. -- john r pierce, recycling bits in santa cruz

Re: Windows XP to Win 10 migration issue

. -- john r pierce, recycling bits in santa cruz

Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??

iness logic in appserver modules outside the database and only used plpgsql for things where performance mattered significantly. the more heavily your apps use Oracle specific features, the more work the conversion will be. -- john r pierce, recycling bits in santa cruz

Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??

olume to /var/lib/pgsql before I initialize the database.    reason I do the pgsql dir and not the version specific data directory is so pg_upgrade can use link mode to upgrade a cluster. -- john r pierce, recycling bits in santa cruz

Re: Does Postgresql 10 query partitions in parallel?

On 12/6/2017 11:33 AM, Andres Freund wrote: PostgreSQL 10 does indeed have a parallel query feature that will use multiple cores.  you have to explicity invoke it. "you have to explicitly invoke it" - huh? oops, I meant, enable. -- john r pierce, recycling bits in santa cruz

Re: Does Postgresql 10 query partitions in parallel?

as to the sorts of queries that can be parallized, but this will be enhanced in future versions. https://www.postgresql.org/docs/current/static/parallel-query.html (read the whole chapter) -- john r pierce, recycling bits in santa cruz

Re: a back up question

.    restores have to create indexes.   creating indexes on multi-million-row tables can take awhile.  (hint, be sure to set maintenance_work_mem to 1GB before doing this!) -- john r pierce, recycling bits in santa cruz

Re: Feature idea: Dynamic Data Making

that: on SELECT RULEs VIEWs column GRANTs RLS yeah, but its so much cooler if you invent a bunch of proprietary methods of doing the same thing, and give it new marketing buzzwords !!! -- john r pierce, recycling bits in santa cruz

Re: transaction wrap around

On 12/4/2017 2:21 PM, chris kim wrote: How would I investigate if my database is nearing a transaction wrap around. it would be screaming bloody murder in the log, for one. -- john r pierce, recycling bits in santa cruz

Re: [CentOS] Broadcom BCM4360

sfers -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos

Re: [CentOS] Broadcom BCM4360

91-_-Product The above adaptor is based on the Realtek RTL8188CUS chipset and uses the rtl8192cu kernel driver. those are only 11N adapters, the OP asked about a 11AC card. -- john r pierce, recycling bits in santa cruz ___ CentOS mailing li

Re: [CentOS] Broadcom BCM4360

potentionally helpful http://elrepo.org/tiki/wl-kmod it appears those are closed source drivers with funky licenses, so they can't just be redistributed without assumption of liability. -- john r pierce, recycling bits in santa cruz ___ CentOS mailing

Re: JSON out of memory error on PostgreSQL 9.6.x

? how many rows does 'blah' match ? what is... SELECT pg_column_size(json_array_elements(json_rmq -> 'orders'::text))   FROM table_name   WHERE blah; ? -- john r pierce, recycling bits in santa cruz

Re: JSON out of memory error on PostgreSQL 9.6.x

On 12/3/2017 3:18 PM, Yuri Budilov wrote: Posted on Stack Overflow, sadly no replies, so trying here ... ,,, why did you email me personally ? -- john r pierce, recycling bits in santa cruz

Re: building a server

x27;ve put pieces in place to mitigate that issue. a single connection will only ever use more than one core if its explicitly doing concurrent query. -- john r pierce, recycling bits in santa cruz

Re: building a server

server not an advocacy for more cores. well, if you have significant concurrency with high CPU usage, you want both more AND faster cores -- john r pierce, recycling bits in santa cruz

Re: pg data backup from vps

will take quite a bit of space -- john r pierce, recycling bits in santa cruz

Re: [CentOS] time foo

he db server just has a single SATA disk, you're doing 9 million committed writes combined to the two tables?    20 minutes for 9 million inserts, thats 7500 per second. -- john r pierce, recycling bits in santa cruz ___ CentOS mailing l

Re: equalant of msdb in sql server

On 11/26/2017 8:10 PM, chandra sekhar wrote: What is the query to get list of the archive log files  to capture start date and time of each archive log ls -l nfsserver:/path/to/archive -- john r pierce, recycling bits in santa cruz

Re: Roles and security

tatic/user-manag.html https://www.postgresql.org/docs/current/static/sql-grant.html https://www.postgresql.org/docs/current/static/sql-revoke.html https://www.postgresql.org/docs/current/static/sql-alterdefaultprivileges.html -- john r pierce, recycling bits in santa cruz

Re: How clear the cache on postgresql?

the server will flush all the hardware caches AND the OS cache. -- john r pierce, recycling bits in santa cruz

Re: migrations (was Re: To all who wish to unsubscribe)

On 11/21/2017 11:42 AM, Joshua D. Drake wrote: I am not sure if that is sarcasm but I think the reason is pretty self explanatory. -Hackers have all the people that understand how all this works, -general has all the people that don't. rotfl, and ain't that the truth. -- joh

Re: migrations (was Re: To all who wish to unsubscribe)

noticed it. -- john r pierce, recycling bits in santa cruz

Re: To all who wish to unsubscribe

P any DKIM out of the original messages, and continue to munge headers and footers like mail list reflectors have been doing for decades. -- john r pierce, recycling bits in santa cruz

Re: unsubscribe

u next to the 'Reply' button. -- john r pierce, recycling bits in santa cruz

Re: [MESSAGE PUBLICITAIRE- VIGILANCE] RE: Unsubscribe

essage, and find the List-Unsubscribe:  header, copy/paste that link to your browser, and voila, away you go. -- john r pierce, recycling bits in santa cruz

Re: To all who wish to unsubscribe

On 11/20/2017 12:49 PM, John R Pierce wrote: Sigh, not surprised about gmail, its amazing how many .com's and .org's use it now.  I'm not at ALL a fan of how the web client handles a bunch of stuff like replies, & hiding your own messages from yourself. oh and my biggest

Re: To all who wish to unsubscribe

on my monitor. Sigh, not surprised about gmail, its amazing how many .com's and .org's use it now.  I'm not at ALL a fan of how the web client handles a bunch of stuff like replies, & hiding your own messages from yourself.    I mostly prefer to use gmail as an imap server w/

Re: To all who wish to unsubscribe

ve to copy/paste them to a browser. -- john r pierce, recycling bits in santa cruz

Re: To all who wish to unsubscribe

thats a feature of many email list SERVERS, not the email clients.  Mailman in particular looks for the major command keywords in the first few lines of the email, and will respond to them, even if they are sent to the regular list address instead of the command address. -- john r pierce, recy

Re: To all who wish to unsubscribe

majority of users never see the full headers, they just see From, To, Date, Subject, and everything else is hidden.  on a phone or a web mail system like gmail, its very hard to see that stuff. -- john r pierce, recycling bits in santa cruz

Re: Migration to PGLister - After

where I want it. I realize why this was done, and yada yada, what a mess. -- john r pierce, recycling bits in santa cruz

Re: [GENERAL] mild modification to pg_dump

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: [CentOS] semi-OT:apcupsd

r/slave sort of network control of power management. here's the project site for an overview... http://networkupstools.org/ nut is in EPEL -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.

Re: [CentOS] HP laptops with CentOS 7?

On 11/16/2017 10:34 PM, Sorin Srbu wrote: It is, thank you! Real life experiences are worth a lot to me, thanks again. the problem is, a couple year old model is probably core gen 5... a new one will be core gen 7, Kaby Lake, and thats where there are more likely problems. -- john r

Re: [CentOS] Issues with Virtualbox

elate to CentOS Linux ? -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos

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

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: [CentOS] Samba help

idmap config * : backend = tdb These are what I added when upgrading from C5's Samba 3 to C7's Samba 4. if you're coming from C6, I do believe I'd add these one at a time, as C5 was *way* older. in particular, I suspect 'max protocol = SMB2' isn't going to

Re: [GENERAL] jsonb

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

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

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

.   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?

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: [CentOS] Intermittently unresponsive mouse

reasonably well at like 20-30 feet.    if there's active nearby wifi on 2.4Ghz, forget it, much closer. -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos

Re: [GENERAL] Incremental refresh - Materialized view

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

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

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: [CentOS] HP laptops with CentOS 7?

is still a sketchy, thats Core gen 7. (i-7xxx). I'm not sure what the state of Skylake is (gen 6) Broadwell should be very solid at this point (5th gen), that was new in early 2015. -- john r pierce, recycling bits in santa cruz ___ CentOS mail

Re: [CentOS] low end file server with h/w RAID - recommendations

ng but dedicated windows servers. -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos

Re: [CentOS] low end file server with h/w RAID - recommendations

25 x 2.5" drives (and x5660 and more ram), they are workhorses. A couple years ago, yes.  Now, not anymore. https://www.ebay.com/i/253122917302?chn=ps&dispItem=1 -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list Cen

Re: [CentOS] low end file server with h/w RAID - recommendations

  on a nearline bulk system, files tend to get written sequentially, and stored for a long time. -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos

Re: [CentOS] low end file server with h/w RAID - recommendations

4 HP trays, dual X5650.   its a personal/charity server sitting at a coloc here in town.   I have several of the same model server at work with 25 x 2.5" drives (and x5660 and more ram), they are workhorses. -- john r pierce, recycling bit

Re: [CentOS] low end file server with h/w RAID - recommendations

e something else and enjoy the disadvantages, but why would you. rack servers tend to be rather noisy, if they are being used in a SMB or SOHO environment you're probably looking at a tower server. -- john r pierce, recycling bits in santa cruz __

Re: [GENERAL] [HACKERS] SSL and Encryption

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

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: [CentOS] low end file server with h/w RAID - recommendations

On 11/2/2017 2:35 PM, m.r...@5-cent.us wrote: John R Pierce wrote: On 11/2/2017 2:18 PM,m.r...@5-cent.us wrote: We have a fair number of SAS 3.5" drives, and yes, 10k or 15k speeds. those are internally 2.5" disks in a 3.5" frame.   you can't spin a 3.5" disk

Re: [CentOS] low end file server with h/w RAID - recommendations

aynumber)         while arrayid < arraynumber:             cmd = '/opt/MegaRAID/MegaCli/MegaCli64 ldinfo l'+str(arrayid)+' a'+str(controllerid)+' nolog' #           print 'DEBUG: running '+str(cmd)             output = getOutput(cmd) #           print &

Re: [CentOS] low end file server with h/w RAID - recommendations

On 11/2/2017 2:18 PM, m.r...@5-cent.us wrote: We have a fair number of SAS 3.5" drives, and yes, 10k or 15k speeds. those are internally 2.5" disks in a 3.5" frame.   you can't spin a 3.5" disk much faster than 7200 rpm without it coming apart. -- john r pierce

Re: [CentOS] low end file server with h/w RAID - recommendations

choice for large capacity bulk 'nearline' storage which is typically sequentially written once -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos

Re: [CentOS] HP laptops with CentOS 7?

ork well. Dell also have the XPS 13 "developer edition" for those looking for a smaller footprint. i forget the distro offhand, but someone has a latest-and-greatest kernel for CentOS 6 & 7 which greatly helps with modern hardware support. -- john r pi

Re: [GENERAL] How to access a second database

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

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

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: [CentOS] Problems with kernel-3.10.0-693.5.2.el7.x86_64

is coming from the CPU itself. -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos

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

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: [CentOS] [OT]: scp setup jailed chroot on Centos7

esource separation (which I'm used to have control over in case of FreeBSD jail). Am I wrong, and what am I wrong about? while I've never used them, my understanding is, lxcontainers are at the level of a jail, network isolation as well as file system. -- john r p

Re: [GENERAL] using conda environment for plpython3u?

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)

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

said PGDATA. -- john r pierce, recycling bits in santa cruz

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

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: [CentOS] systemctl reboot -- server not accessible after reboot

to the graphic screen with the blue startup bar or whatever, I believe you can hit ESC to get the console messages. -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo

Re: [GENERAL] Multiple Schemas vs. Multiple Databases

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: [CentOS] [External] /boot partition too small

, and whatever else lvm stuff, then copy the file systems across with dump or xfsdump or whatever, swap the devices and boot.   this way the old disk is a safe backup.   heck, /boot can be a SD card or USB stick :-p -- john r pierce, recycling bits in santa cruz

Re: [CentOS] /boot partition too small

On 10/10/2017 6:50 PM, John R Pierce wrote: Your root filesystem is in an LVM volume. CentOS 6 is still using GRUB legacy, which does not support /boot in LVM. says up there, /boot is /dev/sda1, this is almost exactly the config of my C6 servers. never mind, I realized after I sent this

Re: [CentOS] /boot partition too small

-lv_home    861G  371G  447G  46% /home Your root filesystem is in an LVM volume. CentOS 6 is still using GRUB legacy, which does not support /boot in LVM. says up there, /boot is /dev/sda1, this is almost exactly the config of my C6 servers. -- john r pierce, recycling bits

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

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: Perl DBI libraries for connecting 12c

racle. You do need to have the oracle client libraries and headers (which you have to get from Oracle). or you could install the perl from sunfreeware/unix packages or opencsw. -- john r pierce, recycling bits in santa cruz

Re: Perl DBI libraries for connecting 12c

unch of stuff unless I'm confusing this with Pro*C, something else our old stack required. -- john r pierce, recycling bits in santa cruz

Re: [CentOS] NUMA split mode?

of the article is that they got at best 2-4% improvements with RHEL 6/SLES 6 on dual nehalem/westmere  Xeon's when NUMA was enabled.  I see no mention of NUMA Split mode -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list C

Re: [CentOS] NUMA split mode?

On 10/1/2017 9:39 AM, John R Pierce wrote: I believe Linux, even RHEL 6, does support NUMA configurations, but its very questionable if a random typical workload would actually gain much from it, and it adds significant overhead in keeping track of all this. a technical paper examining

Re: [CentOS] NUMA split mode?

very questionable if a random typical workload would actually gain much from it, and it adds significant overhead in keeping track of all this. -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos

Re: [CentOS] yum repo issue

On 9/30/2017 3:09 AM, Stijn De Weirdt wrote: in case someone else runs into it, it is the opfed-scripts rpm that has a postinstall and postuninstall script that changes the yum.conf (bad, mellanox, bad) i hate the side effects of hacks like that. -- john r pierce, recycling bits in santa

Re: [GENERAL] Adding Cyrillic support

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?

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

[CentOS] weird wordpress/php/pecl/ssh problem

rect' (php directly writes the .php files to update the app, eek).    they think I should contain php in php-fpm, something thing I've not looked at before. -- john r pierce, recycling bits in santa cruz ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos

Re: [GENERAL] libpq confusion

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

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

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

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

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: [CentOS] update to 7.4

el I get a kernel fault. So going back one level on teh boot screen solves that - I just need to start the update again. How is that? I think I'd try     yum remove kernel-(broken version)     yum update -- john r pierce, recycling bit

Re: [CentOS] Block internet access for some users on the LAN ?

fore the students, mostly, and so when a student tries to spoof the MAC, they get refused, since the real system already has the IP address. that presumes all the reserved systems are on 24/7. -- john r pierce, recycling bits in santa cruz ___ C

Re: [CentOS] Block internet access for some users on the LAN ?

nnections should be kept physically secure so noone unauthorized can plug/unplug anything into the ethernet. THEN you'd use iptables to enforce access restrictions on this guest subnet. -- john r pierce, recycling bits in santa cruz ___ CentOS mailin

  1   2   3   4   5   6   7   8   9   10   >