Re: import .sql file into PostgreSQL database

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: rod(at)iol(dot)ie
Cc: Gaurav Jindal <gaurjin(at)gmail(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: import .sql file into PostgreSQL database
Date: 2014-04-09 23:32:44
Message-ID: CAB7nPqTZxsoUPNz63uP1gNS09NXi7mmz2myYGSZJdHrz7AD1FA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 10, 2014 at 1:02 AM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
> I think that message is coming from the OS; messages from Postgres are
> usual more specific, for example, "Permission denied for relation....".
>
> It looks as if you haven't the OS permissions to read the SQL file.
On Windows, you need either to play with icacls to set some read
permissions or you can change it directly using the properties menu
findable by right-clicking on the culprit file.
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Kehlet 2014-04-10 00:39:12 Re: is there a way to firmly cap postgres worker memory consumption?
Previous Message Alberto Cabello Sánchez 2014-04-09 23:04:36 Capture the SQL statement text with libpq [was: Re: Help]