Lists: | pgsql-general |
---|
From: | kmohan <krishnamohan(at)dsmsoft(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Export to shape file |
Date: | 2007-01-10 06:39:05 |
Message-ID: | 8252869.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hi,
I am trying to export my spatial data from postgres to shae using pgsql2shp
command.
When i keyed in the syntax pgsql2shp -f pl dcmms plss
It is showing fe_sendauth: no password supplied
Please can some one help me on how to import it to shape file.
Thanks and Regards,
Krishna Mohan
--
View this message in context: http://www.nabble.com/Export-to-shape-file-tf2950904.html#a8252869
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | kmohan <krishnamohan(at)dsmsoft(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Export to shape file |
Date: | 2007-01-10 21:43:46 |
Message-ID: | 20070110214346.GC7663@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Tue, Jan 09, 2007 at 10:39:05PM -0800, kmohan wrote:
>
> Hi,
>
> I am trying to export my spatial data from postgres to shae using pgsql2shp
> command.
> When i keyed in the syntax pgsql2shp -f pl dcmms plss
> It is showing fe_sendauth: no password supplied
> Please can some one help me on how to import it to shape file.
I can't find any docs on that program quickly, but it's evidently
looking for a password. You could:
- Find a way to give it the password or
- Setup your system so it does not need a password.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | kmohan <krishnamohan(at)dsmsoft(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Export to shape file |
Date: | 2007-01-14 16:55:43 |
Message-ID: | 20070114165543.GA4520@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Wed, Jan 10, 2007 at 10:43:46PM +0100, Martijn van Oosterhout wrote:
> On Tue, Jan 09, 2007 at 10:39:05PM -0800, kmohan wrote:
> > I am trying to export my spatial data from postgres to shae using pgsql2shp
> > command.
> > When i keyed in the syntax pgsql2shp -f pl dcmms plss
> > It is showing fe_sendauth: no password supplied
> > Please can some one help me on how to import it to shape file.
>
> I can't find any docs on that program quickly, but it's evidently
> looking for a password. You could:
pgsql2shp is part of PostGIS. Running pgsql2shp with no arguments
gives a help message; see also "Using the Dumper" in the PostGIS
documentation.
http://postgis.refractions.net/docs/ch04.html
> - Find a way to give it the password or
You can use the -P option for this, although providing a password
on the command line has security implications and should usually
be avoided.
pgsql2shp -P yourpassword -f pl dcmms plss
> - Setup your system so it does not need a password.
See the "Client Authentication" and "libpq - C Library" chapters
in the PostgreSQL documentation to learn more about authentication
(adjust the following links for whatever version of PostgreSQL
you're running).
http://www.postgresql.org/docs/8.2/interactive/client-authentication.html
http://www.postgresql.org/docs/8.2/interactive/libpq.html
--
Michael Fuhr