Re: [GENERAL] [SQL] encrypt psql password in unix script

2015-07-08 Thread Xavier Stevens
I use envcrypt for things like this locally. Just encrypt the file with your own PGP key. https://github.com/whilp/envcrypt On Wed, Jul 8, 2015 at 12:01 PM, Steve Midgley wrote: > My suggestion is to put it in an environment variable and set that > variable from a shell startup script that is s

Re: [GENERAL] Logical Decoding Callbacks

2015-02-10 Thread Xavier Stevens
There was no reason I needed to run full statements in this case. I just didn't know I could get the type ids like that. Thanks for all of your help Andres! On Tue, Feb 10, 2015 at 1:23 PM, Andres Freund wrote: > On 2015-02-10 10:33:41 -0800, Xavier Stevens wrote: > > Sorr

Re: [GENERAL] Logical Decoding Callbacks

2015-02-10 Thread Xavier Stevens
Sorry to raise the issue on startup_cb. I added a whole bunch of logging statements and I was only running the section of code I wanted when the startup callback had options. This now gets me to the next issue I encounter. In my output plugin, I'm trying to use the SPI interface to query about Pos

[GENERAL] Logical Decoding Callbacks

2015-02-09 Thread Xavier Stevens
I'm trying to write a logical decoding plugin and I'm seeing some interesting behavior around the startup callback. When I use psql and the built-in SQL functions (like pg_logical_slot_peek_changes) to use my module I see the startup_cb get called. I have written my own streaming replication client