[ADMIN] answer my question, please!!!

2008-07-18 Thread ria ulfa
i want to copy table from file with command: COPY log FROM '/tmp/logfile.txt'; but there is error: ERROR: could not open file /tmp/logfile.txt for reading: Permission denied what can i do for repair this error?? thanks for the answer..

Re: [ADMIN] answer my question, please!!!

2008-07-18 Thread Ewald Geschwinde
2008/7/18 ria ulfa [EMAIL PROTECTED]: i want to copy table from file with command: COPY log FROM '/tmp/logfile.txt'; but there is error: ERROR: could not open file /tmp/logfile.txt for reading: Permission denied what can i do for repair this error?? thanks for the answer.. you

Re: [ADMIN] answer my question, please!!!

2008-07-18 Thread Tino Schwarze
On Fri, Jul 18, 2008 at 04:29:42PM +0700, ria ulfa wrote: i want to copy table from file with command: COPY log FROM '/tmp/logfile.txt'; but there is error: ERROR: could not open file /tmp/logfile.txt for reading: Permission denied what can i do for repair this error?? thanks for

[ADMIN] unrecognized data type on dblink

2008-07-18 Thread Aynur SANCAKLI
Hi all, I have a problem with dblink from oracle to postgresql. I cannot read varchar colums from postgresql db, in the trace file the message is in the trace file is : unrecognized data type. How can I solve this problem Oracle version is 10.2.0.1 on windows 2003 machine and postgresql is

Re: [ADMIN] unrecognized data type on dblink

2008-07-18 Thread Jonah H. Harris
On Fri, Jul 18, 2008 at 9:24 AM, Aynur SANCAKLI [EMAIL PROTECTED] wrote: Hi all, I have a problem with dblink from oracle to postgresql. I cannot read varchar colums from postgresql db, in the trace file the message is in the trace file is : unrecognized data type. Which Postgres ODBC driver

[ADMIN] Stop connections to a specific database

2008-07-18 Thread Scott Whitney
I'm migrating a pg server (v 8.1.4) this weekend, and I have 2 dbs left on it. One cannot be shut down until tomorrow. The last remaining one, I can migrate today. However, the software that talks to it is somewhat hinky and has several places that connect -- there is no overall consolidated

Re: [ADMIN] Stop connections to a specific database

2008-07-18 Thread Kevin Grittner
Scott Whitney [EMAIL PROTECTED] wrote: I just want to stop connections to this one particular database. Is there a simple, preferred method for doing so? It sounds like pg_hba.conf might be your ticket: http://www.postgresql.org/docs/8.2/interactive/auth-pg-hba-conf.html -Kevin --

[ADMIN] Questions on pg_dump

2008-07-18 Thread Chris Hoover
We are doing some additional testing of our backup strategy with the goal of moving from the text dump to the custom format and have some questions about pg_dump -Fc. Question 1. Why would the custom format be larger? pg_dump -Fc -Z 0 this morning was 88GB while the normal pg_dump last night

Re: [ADMIN] Stop connections to a specific database

2008-07-18 Thread Rex Mabry
You can update your pg_hba.conf file.  Change the database column to list the one database.   # DATABASE can be all, sameuser, samerole, a database name, or # a comma-separated list thereof.   Assuming you database is called mydb and you enter the connecting from IP, it should look like this. #

Re: [ADMIN] Questions on pg_dump

2008-07-18 Thread Chris Hoover
We understand that. The question is why is an uncompressed Fc format so much larger than a straight dump? Is the so bad it takes almost 5% extra space? On Fri, Jul 18, 2008 at 2:36 PM, Scott Mead [EMAIL PROTECTED] wrote: Chris, Sorry I'm not responding to the list, I am not allowed to