Re: [GENERAL] [ADMIN] $libdir/mysql_fdw

Hi Devrim, I have already installed that: "Package mysql_fdw_94-2.0.1-1.rhel6.x86_64 already installed and latest version..." We're looking into some other options though. Thanks though. Ryan King Internet Dissemination Group, Kansas City Shared Infrastructure Services Branch N

[GENERAL] $libdir/mysql_fdw

When attempting to create the required functions and extensions for the MySQL FDW, I get the following errors: dbname=# CREATE FUNCTION mysql_fdw_handler() RETURNS fdw_handler AS '$libdir/mysql_fdw' LANGUAGE C STRICT; ERROR: could not access file "$libdir/mysql_fdw": No such file or directory d

Re: [GENERAL] could not create shared memory segment: Invalid argument

I tried that too - same result. I updated another box w/ the same issue to 9.4.4, and all is well there. Thanks for your reply. On Tue, Jul 14, 2015 at 8:59 AM, Andy Colson wrote: > On 7/13/2015 7:08 PM, Ryan King - NOAA Affiliate wrote: > >> Apologies ahead of time for not knowing

Re: [GENERAL] could not create shared memory segment: Invalid argument

Apologies ahead of time for not knowing which group to send to, but I wanted to see if anyone has encountered and resolved this type of error. I'm setting up postgresql 9.2 streaming replication on RH and after copying the master data directory over to the slave, the psql service refuses start and

Re: [GENERAL] Copy Data between different databases

Have you considered using dblink() or foreign data wrappers to transfer the data? You can do a select from source, insert into target using one of these methods. RC > On Mar 3, 2015, at 12:09 PM, Francisco Olarte wrote: > > Hi Adrian: > > On Tue, Mar 3, 2015 at 4:44 PM, Adrian Klaver

Re: [GENERAL] Regarding "Point-in-time Recovery" feature

I have archiving enabled for PITR but it has been causing problems. So I changed the archive_command to ‘cd .’ to disable for now. However, I’m currently looking for a script/process that will rotate the logs every week or so, and also ensure archived wal files don’t pile up. I > On Feb 27, 2015