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..
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
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
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
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
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
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
--
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
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.
#
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
10 matches
Mail list logo