Posted
by thuanvh
on Stack Overflow
See other posts from Stack Overflow
or by thuanvh
Published on 2010-05-29T04:56:48Z
Indexed on
2010/05/29
5:02 UTC
Read the original article
Hit count: 87
Error of text2ltree I can't use text2ltree. Any suggestion?
SELECT text2ltree(to_char(243, '09999999'))
*** Error ***
ERROR: syntax error at position 0 SQL state: 42601
© Stack Overflow or respective owner
as seen on Ask Ubuntu
- Search for 'Ask Ubuntu'
I installed postgresql 9.2 from add-apt-repository ppa:pitti/postgresql using apt-get install postgresql-9.2
At the end of the install and every time I try to launch postgresql by using the following command
/etc/init.d/postgresql start
or
service postgresql start
I get this error:
Error:…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I tried install psycopg2 via pip in my virtual env, but got this error:
ld: library not found for -lpq
(full log here: http://pastebin.com/XdmGyJ4u )
I tried install postgres 9.1 from .dmg and via port,
(gksks)iMac-Alexander:~ lorddaedra$ locate libpq
/Developer/SDKs/MacOSX10.7.sdk/usr/include/libpq
/Developer/SDKs/MacOSX10…
>>> More
as seen on Super User
- Search for 'Super User'
On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by:
The following packages have unmet dependencies:
postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going to be instal
led
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a so
lution)…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hey everyone, I am trying to install (using ports) PostgreSQL on a virtual server, running FreeBSD. My one question is this:
Which of the following should I install?
postgresql-contrib
postgresql-docs
postgresql-jdbc
postgresql-libpgeasy
postgresql-libpq++
postgresql-libpqxx
postgresql-odbc
…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
A freshly installed PostgreSQL (with configuration overwritten) won't start:
$ sudo service postgresql start
* Starting PostgreSQL 9.1 database server
* Error: could not read /etc/postgresql/9.1/main/postgresql.conf: Permission denied
Looks like it should be able to read it though:
$ ls -l postgresql…
>>> More
