Re: [BUGS] BUG #8458: Missing Fedora RPMs

2013-09-17 Thread Devrim GÜNDÜZ

Hi,

On Mon, 2013-09-16 at 16:51 +, l...@cert.org wrote:

> 
> The 9.3 non-RC1 RPMs are missing for Fedora 17 and 18 for i386.

My bad, uploaded.

> 
> If those will not be made available, I'd be happy to rebuild from source
> once you release the SRPM for 9.3

There are some build issues in Fedora 17&18 i686, but SRPM is there, if
you want to give it a try.

Regards,



-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part


Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-17 Thread Saravanan Nagarajan
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

-- Saravanan .
On 11 September 2013 18:31, Michael Paquier wrote:

> On Wed, Sep 11, 2013 at 4:00 AM, Saravanan Nagarajan
>  wrote:
> > Hi,
> >
> > I am using PostgreSQL. If am starting the db with System Account/ any
> domain
> > account using wrapper, the DB is starting fine.
> >
> > If i am trying to start the PostgreSQL DB using command prompt, [Normal
> mode
> > or Run as administrator.], It wont start. I provided full permission for
> > everyone in Postgres DB Folder.
> >
> > I didn't find any error in pg_log file. I installed DB in 2008 R2 windows
> > machine.
> >
> > My command : pg_ctl -D "..\data" -o -p3306 --log "D:\logs\pglog.txt"
> start &
> What is exactly the version of Postgres you are trying to use?
> What is the output of D:\logs\pglog.txt?
> --
> Michael
>


[BUGS] Problem with updating hstore extension from 9.2 to 9.3

2013-09-17 Thread Murat Kabilov
Hello,

I've just upgraded my database from 9.2.2 to 9.3.0 using pg_upgrade.
Besides I've updated hstore extension ("alter extension hstore update").
But I can't find new to 9.2 hstore functions such as "hstore_to_json" in my
database.

I found out that file "contrib/hstore/hstore.control" of pg 9.3 is
identical to 9.2 one. And there is no file like "hstore--1.1--1.2.sql".

Is there a miss of update files for hstore?


Thanks in advance.

--
Regards
Murat Kabilov


[BUGS] Postgis extension bug w/ OpenBSD

2013-09-17 Thread Marcelo Bacha
Hi,

I´ve sent this to the Postgis bug list before, but I was told that this is
probably a PostgreSQL problem.

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.
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*

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

Thanks in advance,
Marcelo




-- 
Editio Princeps
http://www.editioprinceps.com


[BUGS] BUG #8460: Stack Builder fails to parse http://www.postgresql.org/applications-v2.xml

2013-09-17 Thread sstewart . fr
The following bug has been logged on the website:

Bug reference:  8460
Logged by:  Stephen Stewart
Email address:  sstewart...@gmail.com
PostgreSQL version: 9.3.0
Operating system:   Windows XP SP3
Description:

I have a fresh install of WinXP running in a VirtualBox VM. I downloaded and
install PostgreSQL 9.3. 


The install went fine until Application Stack Builder 3.1.1 runs and gives
the error: "17:11:52: XML parsing error: 'syntax error' at line 1
17:11:52: Failed to parse the application list:
http://www.postgresql.org/applications-v2.xml";


I am able to download the file http://www.postgresql.org/applications-v2.xml
manually via my browser and it appears to be valid.




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