Re: [GENERAL] Dump Database

2014-03-20 Thread José Pedro Santos
-0500 What does the shell command: pwd show when run immediately after you issue a su postgres command? You may want to try su - postgres to ensure you are in the postgres users home directory. From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of José

[GENERAL] Dump Database

2014-03-17 Thread José Pedro Santos
Dear all, I'm trying to dump my database using the following command after I enter as su postgres: pg_dump - U postgres mydb -f mydb.sql ... but I'm always having the following message: pg_dump [archiver] Could not open output file "mydb.sql" : Permission denied I try to use the same state

[GENERAL] Import raster file with 3 bands

2012-12-10 Thread José Pedro Santos
Dear all, I import with sucess a 3 band image to PostgreSQL 9.1 with the raster2pgsql in Ubuntu 12.04LTS. But when I try to visualize in another software I can't see the image and it looks like the values from the other bands glue only in the first band. Do you know if there’s any problem wit

Re: [GENERAL] pg_wrapper error

2012-10-26 Thread José Pedro Santos
Fri, 26 Oct 2012 06:56:46 -0700 > From: adrian.kla...@gmail.com > To: zpsant...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] pg_wrapper error > > On 10/26/2012 06:33 AM, José Pedro Santos wrote: > > Postgres 9.1 in Ubuntu Distribution (12.04 LTS)

FW: [GENERAL] pg_wrapper error

2012-10-26 Thread José Pedro Santos
0 > From: adrian.kla...@gmail.com > To: zpsant...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] pg_wrapper error > > On 10/26/2012 06:16 AM, José Pedro Santos wrote: > > Dear all, > > > > When I try to use the command line tool

Re: [GENERAL] pg_wrapper error

2012-10-26 Thread José Pedro Santos
0 > From: adrian.kla...@gmail.com > To: zpsant...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] pg_wrapper error > > On 10/26/2012 06:16 AM, José Pedro Santos wrote: > > Dear all, > > > > When I try to use the command line tool

[GENERAL] pg_wrapper error

2012-10-26 Thread José Pedro Santos
Dear all, When I try to use the command line tool shp2pgsql in the shell I have this error: Error: pg_wrapper: invalid command name I already read some information in the Debian lists but I don't understand the problem/relation with PostgreSQL. If anyone can help me with this problem plea

[GENERAL] PostgreSQL and WMS

2012-10-12 Thread José Pedro Santos
Dear all, I would like to know if is possible set up a service (WMS/WFS) for a layer stored within Postgres. I have one WEBGIS application that can't connect to PostgreSQL but if I use the data inside Postgres I can get the URL from WMS and add the maps. Best Regards, José Santos

[GENERAL] PostgreSQL and WMS/WFS Service

2012-10-09 Thread José Pedro Santos
Dear all, How can I set up a service for a layer stored within postgres like WMS or WFS? I have one WEBGIS Framework that only allow data with that input. Many thanks. Best Regards, José Santos

Re: [GENERAL] Postgresql Error ask for password

2012-08-31 Thread José Pedro Santos
d > > On 08/31/2012 08:03 AM, José Pedro Santos wrote: > > I install the FGS distribution of MapServer, after, the plugin Postgres > > - Server. When I go to root and put in bash SU also ask for password... > > > Here is an answer from the FGS mailing list: > > ht

Re: [GENERAL] Postgresql Error ask for password

2012-08-31 Thread José Pedro Santos
stgresql.org > Subject: Re: [GENERAL] Postgresql Error ask for password > > On 08/31/2012 07:29 AM, José Pedro Santos wrote: > > Dear all, > > > > Im trying to install one application in my Linux but when I try to use > > the expression SU postgresql it ask for pass

[GENERAL] Postgresql Error ask for password

2012-08-31 Thread José Pedro Santos
Dear all, Im trying to install one application in my Linux but when I try to use the expression SU postgresql it ask for password, what is the password? I try my root password but dont work. Thanks for your time Ciao Jose Santos

Re: [GENERAL] FGS - Postgresql server install

2012-08-28 Thread José Pedro Santos
Hi again, I already fix the problem, thanks. Regards José Santos > Date: Tue, 28 Aug 2012 21:44:00 +0800 > From: ring...@ringerc.id.au > To: zpsant...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] FGS - Postgresql server install > > On 08/28/2012

[GENERAL] FGS - Postgresql server install

2012-08-28 Thread José Pedro Santos
Hi all, I'm trying to install the fgs-postgresql-server-8.4.2-linux-i386.tar.gz in FGS MAPSERVER distribution but I can't, I'm using the Linux Centos version. Anyone know the command line to install the module? Is because when I install the FGS version the module postgresql server don't came

Re: [GENERAL] Add Metadata to Postgre SQL

2012-08-14 Thread José Pedro Santos
] Add Metadata to Postgre SQL > > On 08/14/12 4:32 AM, José Pedro Santos wrote: > > With the files should came metadata to describe what is inside the > > file. I can't put in the comment options because is not ISO standart > > that allow to produce metadata. >

Re: [GENERAL] Add Metadata to Postgre SQL

2012-08-14 Thread José Pedro Santos
Postgre SQL > > On 08/14/12 2:55 AM, José Pedro Santos wrote: > > Not comments. In comments i can't use the ISO that rules Metadata XML. > > Basically put XML Metadata files inside the schemas. Is possible? > > not sure what the International Standards Organization ha

Re: [GENERAL] Add Metadata to Postgre SQL

2012-08-14 Thread José Pedro Santos
ql.org; zpsant...@hotmail.com > Subject: Re: [GENERAL] Add Metadata to Postgre SQL > > > > "José Pedro Santos" hat am 14. August 2012 um 11:15 > geschrieben: > > > > Dear Postgre Community, > > > > I would like to know if is possible to add metadata

[GENERAL] Add Metadata to Postgre SQL

2012-08-14 Thread José Pedro Santos
Dear Postgre Community, I would like to know if is possible to add metadata to Schemas. I have shemas with raster layers and I would like to add to them matadata. Is possbile in Postgre? If not how can I solve this problem? Many thanks in advance. Best Regards, José Santos

Re: [GENERAL] Visualize database schema

2012-08-14 Thread José Pedro Santos
Hi, I use to visualize a database schema Quantum GIS or UDIG. Both are open source software and very esay to add a database schema. Best Regards, José Santos Date: Tue, 14 Aug 2012 09:54:34 +0100 Subject: [GENERAL] Visualize database schema From: dario.bera...@gmail.com To: pgsql-general@postg