<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Thanks for the hints! Checking the pg_hba file, all entries has md5 set; after changed them to trust, the command executes successfully. </span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><span>Regards</span></div><div><br></div> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Donovan Cameron <sault.don@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> PostGIS Users Discussion <postgis-users@lists.osgeo.org> <br>
<b><span style="font-weight: bold;">Sent:</span></b> Monday, January 21, 2013 5:43 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] access is denied in Windows 7<br> </font> </div> <br>
One thing to check is also what type of authentication the postgresql<br>database is using.<br><br>You can see that in the pg_hba.conf file.<br>Chances are, it's set to "ident" or "peer", which means that when<br>someone connects to the database, it uses their operating system<br>username and password to login.<br>If you want to login using peer/ident modes, then the user name and<br>password should exist on both the OS and the postgresql database (ie,<br>createuser command as postgres)<br><br>So, if you aren't logged in as the "postgres" user on the actual<br>Operating System, then it will probably fail.<br><br>If you want to login without using operating system users and<br>authenticate using the users/pass setup in the postgresql database,<br>then change the authentication method to MD5 (requires password) or<br>Trust (not recommended unless you are on a CLOSED/TRUSTED network).<br>Sometimes I use Trust just to see if I can connect
(ie,<br>troubleshooting only).<br><br><br><br><br>Donovan<br><br>On Mon, Jan 21, 2013 at 10:35 AM, Tumasgiu Rossini <<a ymailto="mailto:rossini.t@gmail.com" href="mailto:rossini.t@gmail.com">rossini.t@gmail.com</a>> wrote:<br>> Hi,<br>> are you running your console with admin privileges ? (Run as Administrator )<br>><br>><br>> 2013/1/21 James David Smith <<a ymailto="mailto:james.david.smith@gmail.com" href="mailto:james.david.smith@gmail.com">james.david.smith@gmail.com</a>><br>>><br>>> I'm not sure if this is the same issue, but I often have similar problems<br>>> when I am importing data. Have you tried to dump to the 'Data' folder within<br>>> the PostgreSQL installation folder? I think you may find that works ok. I<br>>> think it's permissions for writing to the folder that you are getting,<br>>> rather than accessing the database.<br>>><br>>><br>>> On 21 January 2013
15:01, Ulises F-Troche <<a ymailto="mailto:ufeliciano@yahoo.com" href="mailto:ufeliciano@yahoo.com">ufeliciano@yahoo.com</a>> wrote:<br>>>><br>>>> New to postgresql.<br>>>><br>>>> I'm using PostgreSQL 9.2 in Windows 7. First, to be able to use psql I<br>>>> added the installation path in the system's environment variables. I want to<br>>>> know mre about pg_dump, but when running the command<br>>>><br>>>> pg_dump -U postgres postgis > c:\myDump.sql<br>>>><br>>>> I received the error "Access is denied.". I have 3 databases in my<br>>>> machine: postgres, postgis, and template_postgis_20. User postgres is the<br>>>> only role and owner.<br>>>><br>>>> Any help on how to correctly configure this is appreciated.<br>>>><br>>>> Thanks<br>>>><br>>>>
_______________________________________________<br>>>> postgis-users mailing list<br>>>> <a ymailto="mailto:postgis-users@lists.osgeo.org" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br>>>><br>>><br>>><br>>> _______________________________________________<br>>> postgis-users mailing list<br>>> <a ymailto="mailto:postgis-users@lists.osgeo.org" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>>><br>><br>><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a ymailto="mailto:postgis-users@lists.osgeo.org"
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>><br>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@lists.osgeo.org" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br><br><br> </div> </div> </div></body></html>