CROSSTAB( .. only one column has values... )

2021-01-05 Thread Adam Tauno Williams
(null) (null) (null) 2013-03 3512 (null) (null) (null) 2013-03 5366 (null) (null) (null) ... Only the first column has values, all the rest are NULL. I assume I am missing something stupid. -- Adam Tauno Williams <mailto:awill...@whitemice.org> GPG D95ED383 Systems Administrator, Python Developer, LPI / NCLA

Re: Microsoft buys GitHub, is this a threat to open-source

2018-06-07 Thread Adam Tauno Williams
On Thu, 2018-06-07 at 16:04 +0200, Thiemo Kellner, NHC Barhufpflege wrote: > Zitat von Vik Fearing : > > For many people, this is why sourceforge died: > > https://en.wikipedia.org/wiki/SourceForge#Project_hijackings_and_bu > > ndled_malware > Wow! I missed that completely. This is grave. That was

Re: Microsoft buys GitHub, is this a threat to open-source

2018-06-07 Thread Adam Tauno Williams
uot;official" repository+branch]. The tool-set mania has certainly diminished my level participation; there are so many barriers before getting to the point. I am grateful that Sourceforge has been there, steadily making improvements. Their current platform is very nice. -- Adam Tauno Wi

Re: Microsoft buys GitHub, is this a threat to open-source

2018-06-07 Thread Adam Tauno Williams
On Thu, 2018-06-07 at 11:54 +0100, Paul Linehan wrote: > Only to the extent that GitHub was a threat before this. They never > embraced Open Source! > They cynically portrayed themselves as the developer's best pal when, > in fact, they are/were nothing more and nothing less than another > commeric

Re: Asynchronous Trigger?

2018-04-27 Thread Adam Tauno Williams
On Fri, 2018-04-27 at 11:25 -0600, Michael Loftis wrote: > As suggested, note in ToDo table, also maybe look at LISTEN and > NOTIFY and have a job runner process LISTENing We use a simple python process to listen with a PostgreSQL cursor for NOTIFY events, and push them into RabbitMQ (message bro

Re: Asynchronous Trigger?

2018-03-30 Thread Adam Tauno Williams
and do whatever is necessary. See the "LISTEN" documentation. -- Adam Tauno Williams <mailto:awill...@whitemice.org> GPG D95ED383 OpenGroupware Developer <http://www.opengroupware.us/>

Re: Information on savepoint requirement within transctions

2018-01-29 Thread Adam Tauno Williams
>  * Why are they required in combination with failing statements (when > every other database does an "automatic savepoint and rollback" for a > failed statement)? It this statement true?  I very much feel *not*.  This depends on how you have set AUTO_COMMIT - and it certainly is not true for tra

Re: PGSQL 10, many Random named DB

2018-01-24 Thread Adam Tauno Williams
> 1.) PGAdmin IV bug? > 2.) Their server is hacked/cracked from outside? > 3.) A wrong configured tool, or an automation? > 4.) "Alien invasion", etc. > Did you see same thing anywhere? Are their connections to the server?  What does "netstat" tell you? -- Meetings Coordinator, Michigan Associat

Re: How to know if a database has changed

2017-12-12 Thread Adam Tauno Williams
> The next day, that backup will be copied to the cloud. What does this mean?  If it is rsync of a local dump to a remote use the directory dump format - disable compression - then each table which didn't change will 'copy' almost instantly. -- Meetings Coordinator, Michigan Association of Railr

Re: Secured ldap connectivity between PostgreSQL and LDAPs server

2017-12-08 Thread Adam Tauno Williams
On Fri, 2017-12-08 at 07:40 -0500, chiru r wrote: > We are using LDAP authentication for authenticating users in > PostgreSQL on Linux server and we are able to authenticate > successfully.  Then one presumes you are using PAM (?) for password authentication - this question is really about pam_lda

Re: a question about oddities in the data directory

2017-11-27 Thread Adam Tauno Williams
On Mon, 2017-11-27 at 15:19 +, Martin Mueller wrote: >  Apologies if I asked this question before. > Is this normal behavior?  Yes. >  Where in the postgres documentation do I read up on this? Start here - https://www.postgresql.org/docs/10/static/admin.html > string functions and regular

Re: How clear the cache on postgresql?

2017-11-25 Thread Adam Tauno Williams
On Fri, 2017-11-24 at 11:58 -0800, John R Pierce wrote: > On 11/24/2017 11:43 AM, Michael Nolan wrote: > > There are so many different levels of caching going on--within  > > Postgresql, within the OS, within a disk array or SAN, and at the  > > individual drive--that there may no longer be a meani