Disable unix-domain sockets?

Murray Cumming <murrayc@murrayc.com> writes:

I hoped that if I didn't use "local" in my pg_hba.conf file, instead
using just "host", then postgresql might not allow unix socket
connections at all, so it wouldn't need to create that .lock file.
http://www.postgresql.org/docs/9.2/static/auth-pg-hba-conf.html

But postgres still tries to create the .lock file, failing here on
Fedora because it defaults not to /tmp but to /var/run/postgresql, which
the local user can't write to.

If you are using a version that defaults to /var/run/postgresql, then
it is new enough to have the unix_socket_directories parameter. Setting
that to empty should do the trick. pg_hba.conf is not the place to
configure which ports/sockets PG listens on.

regards, tom lane

Hi all,

I'm working with same db schema in PostgreSQL and Oracle,
We mainly work in PostgreSQL but sometimes we need to copy schema and
data from pg to oracle
because some our customers want to use oracle instead of pg.

Thus I'm looking for some linux script to migrate from pg to oracle.
At the moment, I dump data from pg using pg_dump in the format:
INSERT INTO table (columns) (values)
then I load it into the Oracle db using cx_Oracle
this procedure is so slow, and sometimes I have to edit and modify
data manually, because some INSERT format aren't compatible.
Is there any interesting linux script to do this more easily? something
like the ora2pg script.

thanks

j

On 25 October 2012 15:50, jo <jose.soares@sferacarta.com> wrote:

Hi all,

I'm working with same db schema in PostgreSQL and Oracle,
We mainly work in PostgreSQL but sometimes we need to copy schema and data
from pg to oracle
because some our customers want to use oracle instead of pg.

That sounds like a job for an ETL tool, for example Pentaho.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

squirrel

http://www.squirrelsql.org/index.php?page=plugins

Saludos desde EEUU
Martin
______________________________________________
Porfavor ..no altere o interrumptir esta communicacion

You can try this one:

http://code.google.com/p/hisql/
then JMyETL1.0.6

------------------
Thanks&Regards,
Xiong He

------------------ Original ------------------
From: "Martin Gainty"<mgainty@hotmail.com>;
Date: Thu, Oct 25, 2012 10:18 PM
To: "jose.soares"<jose.soares@sferacarta.com>; "pgsql-general@postgresql.org"<pgsql-general@postgresql.org>;

Subject: Re: [GENERAL] migrate from PostgreSQL to Oracle

squirrel

http://www.squirrelsql.org/index.php?page=plugins

Saludos desde EEUU
Martin
______________________________________________
Porfavor ..no altere o interrumptir esta communicacion