Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-19 Thread Michael Paquier 
On Tue, Sep 17, 2013 at 1:52 AM, Saravanan Nagarajan
 wrote:
> In pglog_txt,
>
> LOG:  could not bind IPv6 socket: No error
> HINT:  Is another postmaster already running on port 33307? If not, wait a
> few seconds and retry.
> LOG:  could not bind IPv4 socket: No error
> HINT:  Is another postmaster already running on port 33307? If not, wait a
> few seconds and retry.
> WARNING:  could not create listen socket for "localhost"
> FATAL:  could not create any TCP/IP sockets
>
> But already, i set ipv6&4 in pg_hba.conf file.
> My PostgreSQL Version : 9.2.1
This might be caused by something that changed on your Windows
environment like the addition of a new software (Anti-virus)? Also,
are you sure that your server is not running? Is there any process
Postgres.exe listed if you run a simple command tasklist?
-- 
Michael


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Postgis extension bug w/ OpenBSD

2013-09-19 Thread Michael Paquier 
On Tue, Sep 17, 2013 at 4:48 PM, Marcelo Bacha  wrote:
> I have an OpenBSD 5.3 server, with PostgreSQL 9.3.0, which seems to work
> fine. I´m trying to install  on it, which always worked fine.
Postgres is working fine as you mention, and only PostGIS development
failed. Based on the information above which looks to be a library
linking problem for your PostGIS installation, this problem is not
related to PG.

> When I try to install the extension for Postgis 2.1.0, I get this error on
> psql:
>
>   postgres=# CREATE EXTENSION postgis;
>   ERROR:  could not load library "/usr/local/pgsql/lib/rtpostgis-2.2.so":
> dlopen (/usr/local/pgsql/lib/rtpostgis-2.2.so) failed: Cannot load specified
> object
You mention that you are trying to install postgis 2.1, but
rtpostgis-2.2.so is part of the PostGIS 2.2 bundle (version currently
in development). So which one are you trying to install?

>
> The paths seems all to be OK:
>
>   # ls -l /usr/local/pgsql/lib/*post*
>   -rwxr-xr-x  1 root  wheel  1276039 Jul  1 16:50
> /usr/local/pgsql/lib/postgis-2.2.so
>   -rwxr-xr-x  1 root  wheel  1208861 Jul  1 16:50
> /usr/local/pgsql/lib/rtpostgis-2.2.so
>
> When I try to preload the rtpostgis shared object setting the LD_PRELOAD
> environment variable, I get this info on psql:
>
>   $ psql
> (...)
>   psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol
> 'CurrentMemoryContext'
>   psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol
> 'SPI_tuptable'
>   psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol 'SPI_result'
>   psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol
> 'InterruptPending'
>   psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol
> 'SPI_processed'
>   psql (9.2.4)
> (...)
>
> In fact, I´ve been trying to solve this since a long time ago, and with many
> previous versions of both Postgresql and Postgis, but I´m really stuck
Also, what is the output of this command? => ldd
/usr/local/pgsql/lib/rtpostgis-2.2.so
Are you sure that rtpostgis is linked to the necessary PG libs?
-- 
Michael


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #8452: COPY command pgadmin

2013-09-19 Thread Michael Paquier 
On Sat, Sep 14, 2013 at 4:15 PM,   wrote:
> in short, for pgadmin...
This feature request is related to PGAdmin and not Postgres core. You
should send such requests to the PGAdmin mailing lists which are
listed here:
http://www.pgadmin.org/support/list.php

Regards,
-- 
Michael


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #8449: ODBC Failure with Access 10

2013-09-19 Thread Michael Paquier 
On Thu, Sep 12, 2013 at 10:21 AM,   wrote:
> Bug reference:  8449
> I'm not able to link in Access to the table "map". I get an ODBC error and
> in the table fields are no data, it returns "#Name?".
>
> Any idea what is wrong ?
You should be more precise here:
- What is the version of ODBC driver used?
- Could you provide a more complete test case or some code that can
reproduce this error? Configuration used perhaps? It is going to be
difficult to guess what are your problems with such a vague
description.
Also, this is a problem related to ODBC. So you should send such
reports to pgsql-o...@postgresql.org and not this mailing list.
Regards,
-- 
Michael


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-19 Thread Saravanan Nagarajan 
Hi Michael & Team,

No anti-virus is running on that machine. I started the DB using Windows
service. Its working fine. I am trying to start the DB with different user
credentials using command prompt, the DB is not started. I provided full
permission for everyone to postgres folder and its sub folder.


On 19 September 2013 13:00, Michael Paquier wrote:

> On Tue, Sep 17, 2013 at 1:52 AM, Saravanan Nagarajan
>  wrote:
> > In pglog_txt,
> >
> > LOG:  could not bind IPv6 socket: No error
> > HINT:  Is another postmaster already running on port 33307? If not, wait
> a
> > few seconds and retry.
> > LOG:  could not bind IPv4 socket: No error
> > HINT:  Is another postmaster already running on port 33307? If not, wait
> a
> > few seconds and retry.
> > WARNING:  could not create listen socket for "localhost"
> > FATAL:  could not create any TCP/IP sockets
> >
> > But already, i set ipv6&4 in pg_hba.conf file.
> > My PostgreSQL Version : 9.2.1
> This might be caused by something that changed on your Windows
> environment like the addition of a new software (Anti-virus)? Also,
> are you sure that your server is not running? Is there any process
> Postgres.exe listed if you run a simple command tasklist?
> --
> Michael
>



-- 
Regards
  Saravanan.N.
  Ph: +91-9965003321
  Twitter : 
twitter.com/#!/Saravanan221186/

"First, be unique. Second, remember that 21st century India requires you to
‘work with integrity and succeed with integrity’. Third, the spirit of
‘What Can I Give’ shall replace the attitude of ‘What Can I Take’ — which
is what causes greed, leading to problems like corruption, environmental
degradation and moral turpitude." - Dr.A.P.J.Abdul Kalam

[BUGS] tablefunc extension

2013-09-19 Thread Carl Clemens 
Hi Folks,

The following query appears to be correct but fails to execute.

\set VERBOSITY verbose

select * from crosstab('select claim_id::bigint, patient_id::integer, 
code_id::text from diagnosis') as dg_list(claim_id bigint, patient_id integer, 
code_id text);

ERROR:  42601: return and sql tuple descriptions are incompatible
LOCATION:  crosstab, tablefunc.c:445

The above query works if patient_id is cast to text.  The claim_id as bigint 
works too.

postgres   9.2.4
openSUSE 12.3 (x86_64)
VERSION = 12.3


diagnosis
--+--+---
id| integer  | not null default 
nextval('diagnosis_id_seq'::regclass)
patient_id| integer  | not null
code_id   | text | not null
claim_id  | bigint   |
 seq_num   | smallint |
 poa_indicator | character(1) |



Thanks for your time and help.

Carl Clemens




The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this 
message, please contact the sender and delete this material from this computer.