[postgis-users] access is denied in Windows 7

[Ulises F-Troche]

Thanks for the hints!  Checking the pg_hba file, all entries has md5 set;  after changed them to trust, the command executes successfully. 
Regards


________________________________
 From: Donovan Cameron <sault.don at gmail.com>
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org> 
Sent: Monday, January 21, 2013 5:43 PM
Subject: Re: [postgis-users] access is denied in Windows 7
 
One thing to check is also what type of authentication the postgresql
database is using.

You can see that in the pg_hba.conf file.
Chances are, it's set to "ident" or "peer", which means that when
someone connects to the database, it uses their operating system
username and password to login.
If you want to login using peer/ident modes, then the user name and
password should exist on both the OS and the postgresql database (ie,
createuser command as postgres)

So, if you aren't logged in as the "postgres" user on the actual
Operating System, then it will probably fail.

If you want to login without using operating system users and
authenticate using the users/pass setup in the postgresql database,
then change the authentication method to MD5 (requires password) or
Trust (not recommended unless you are on a CLOSED/TRUSTED network).
Sometimes I use Trust just to see if I can connect (ie,
troubleshooting only).




Donovan

On Mon, Jan 21, 2013 at 10:35 AM, Tumasgiu Rossini <rossini.t at gmail.com> wrote:
> Hi,
> are you running your console with admin privileges ? (Run as Administrator )
>
>
> 2013/1/21 James David Smith <james.david.smith at gmail.com>
>>
>> I'm not sure if this is the same issue, but I often have similar problems
>> when I am importing data. Have you tried to dump to the 'Data' folder within
>> the PostgreSQL installation folder? I think you may find that works ok. I
>> think it's permissions for writing to the folder that you are getting,
>> rather than accessing the database.
>>
>>
>> On 21 January 2013 15:01, Ulises F-Troche <ufeliciano at yahoo.com> wrote:
>>>
>>> New to postgresql.
>>>
>>> I'm using PostgreSQL 9.2 in Windows 7.  First, to be able to use psql I
>>> added the installation path in the system's environment variables. I want to
>>> know mre about pg_dump, but when running the command
>>>
>>> pg_dump -U postgres postgis > c:\myDump.sql
>>>
>>> I received the error "Access is denied.".  I have 3 databases in my
>>> machine: postgres, postgis, and template_postgis_20.  User postgres is the
>>> only role and owner.
>>>
>>> Any help on how to correctly configure this is appreciated.
>>>
>>> Thanks
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130121/32dc95ae/attachment.html>