On Thu, Dec 22, 2011 at 3:28 PM, Clemens Eisserer wrote:
> Hi,
>
> I try to run postgresql on my mips based openwrt router.
> Although openwrt provides precompiled packages, I have troubles
> initializing postgresql's file system:
>
> # creating template1 database in /var/postgresql/data/base/1 ..
Hi,
I try to run postgresql on my mips based openwrt router.
Although openwrt provides precompiled packages, I have troubles
initializing postgresql's file system:
# creating template1 database in /var/postgresql/data/base/1 ...
FATAL: could not write to file "pg_xlog/xlogtemp.1791": No space le
Actually the interesting part would be what locale
locale
LANG=et_EE.UTF-8
LC_CTYPE="et_EE.UTF-8"
LC_NUMERIC="et_EE.UTF-8"
LC_TIME="et_EE.UTF-8"
LC_COLLATE="et_EE.UTF-8"
LC_MONETARY="et_EE.UTF-8"
LC_MESSAGES="et_EE.UTF-8"
LC_PAPER="et_EE.UTF-8"
LC_NAME="et_EE.UTF-8"
LC_ADDRESS="et_EE.UTF-8"
LC_
Hi!!! can1 here tell me that how can i configuare pgrouting extension
with QuantumGIS???
This message was sent using IMP, the Internet Messaging Program.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
hi!!! can any1 hee tell me that how can i configuare PGrouting
extention in QuantumGIS??
This message was sent using IMP, the Internet Messaging Program.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Hi!!! how can i cofigure pgrouting extension with my quantum gis?
This message was sent using IMP, the Internet Messaging Program.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Thu, Dec 22, 2011 at 10:14 AM, Tom Lane wrote:
> Hanns Hartman writes:
>> On Thu, Dec 22, 2011 at 7:29 AM, Tom Lane wrote:
>>> Best guess is that something sent the background writer process a
>>> SIGUSR2 signal.
>
>> One other thought, my current setup mainly interacts with postgresql
>> via
Hanns Hartman writes:
> On Thu, Dec 22, 2011 at 7:29 AM, Tom Lane wrote:
>> Best guess is that something sent the background writer process a
>> SIGUSR2 signal.
> One other thought, my current setup mainly interacts with postgresql
> via libpq and very rarely via psql. I have four connections o
On 12/22/11 1:31 AM, Shankar Palaniappan wrote:
I am getting the following error when I try to connect from PHP with
PostgreSQL server.
Operating System is HP-UX and I was able to connect through PostgreSQL
server from psql,
what postgres connection parameters are you passing to the php
connec
On Thu, Dec 22, 2011 at 7:29 AM, Tom Lane wrote:
> Hanns Hartman writes:
>> I'm running postgres 8.3.17 on a redhat linux mips derivative and I've
>> observed a postgres crash and the subsequent messages in my postgres
>> debug log.
>
>> 2011-12-21 19:08:49 UTC - LOG: shutting down
>> 2011-12-21
On Thursday, December 22, 2011 9:45:16 am Andrus wrote:
>
> dpkg-reconfigure locales
> Generating locales (this might take a while)...
> en_US.UTF-8... done
> et_EE.UTF-8... done
> Generation complete.
> *** update-locale: Warning: LANGUAGE ("en_US:en") is not compatible with
> LANG (et_EE.UT
On Wed, Dec 21, 2011 at 8:57 PM, Scott Marlowe wrote:
> On Wed, Dec 21, 2011 at 5:48 PM, Hanns Hartman wrote:
>> Hi,
>>
>> I'm running postgres 8.3.17 on a redhat linux mips derivative and I've
>> observed a postgres crash and the subsequent messages in my postgres
>> debug log.
>>
>> 2011-12-21
What application?
My application.
Well you would use template0 as the TEMPLATE only if you wanted to CREATE a
database with different collation than that in template1(the default
template for
the CREATE DATABASE command). So the question then is, why is the database
cluster being created wit
Hello everyone!
I have a next question:
Is there some rule, that sets default value in
the information_schema.COLUMNS.column_default ?
Because for integer is - 777, and for character varying is - 'Hello
world'::character varying
I don't find description of this rule.
I need to know it, to clea
Hi!
> using template1 requires exclusive access to cluster.
> I cannot force all users to log out while creating new db.
> So using template1 is not possible.
>
IMHO you really misunderstood the manual. The exclusive access is NOT to
the entire cluster, but to the template. Which in turn means t
>
> Is it reasonable to use commands
>
> export LC_COLLATE='et_EE.UTF-8'
> export LC_CTYPE='et_EE.UTF-8'
>
> apt-get -t squeeze-backports install postgresql-9.1 postgresql-common
> postgresql-contrib
>
Hmmm no, not really. If your problem is that the system locale is wrong for
your needs, you're g
http://www.postgresql.org/docs/8.1/interactive/manage-ag-templatedbs.html
(see last comment), I haven't checked it myself as I usually have a mix of
locales in my installs (often even in a single db) and never really used
any "default", but it should still work.
using template1 requires exclus
Is it reasonable to use commands
export LC_COLLATE='et_EE.UTF-8'
export LC_CTYPE='et_EE.UTF-8'
apt-get -t squeeze-backports install postgresql-9.1 postgresql-common
postgresql-contrib
Will this force et_EE.UTF-8 locale ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgr
On Thursday, December 22, 2011 8:29:11 am Andrus wrote:
> Adrian and Bèrto,
>
> Thank you very much for quick and excellent replies. Locale names are
> different in every Linux distro.
> Postgresql does not provide any way to retrieve them (ssh access is reqired
> to retireve them using locale -a)
>
> Hi!
>
> How to force command
>
> CREATE DATABASE TEMPLATE = template0
>
> to use et_EE.UTF-8 locale by default ?
>
http://www.postgresql.org/docs/8.1/interactive/manage-ag-templatedbs.html (see
last comment), I haven't checked it myself as I usually have a mix of
locales in my installs (of
select version()
"PostgreSQL 9.0.1 on x86_64-unknown-linux-gnu,
compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit"
I ran the [check_bloat] query from check_postgres.pl (v 2.18.0) twice, doing a
VACUUM FULL in between:
-- the RS
db, schemaname, tablename, tups, pages, otta, tbloa
Hi,
Unable to connect to PostgreSQL server : Could not get socket error
status: No such file or directory in index.php on line 5
Can any one help me on this ?
I am getting the following error when I try to connect from PHP with
PostgreSQL server.
Operating System is HP-UX and I was able to conne
Hi, I have 2 cluster databases, running on the same host, Linux with redHat. My
fist database port is set to default, 5432, but my second database port is set
to 5436 in the postgresql.conf file. While everything is ok with local
connections, I cannot connect remotely using any of my tools to th
Adrian and Bèrto,
Thank you very much for quick and excellent replies. Locale names are
different in every Linux distro.
Postgresql does not provide any way to retrieve them (ssh access is reqired
to retireve them using locale -a)
Thus suggection using hard coded locale names is not possible.
Hanns Hartman writes:
> I'm running postgres 8.3.17 on a redhat linux mips derivative and I've
> observed a postgres crash and the subsequent messages in my postgres
> debug log.
> 2011-12-21 19:08:49 UTC - LOG: shutting down
> 2011-12-21 19:08:49 UTC - PANIC: concurrent transaction log activit
I have run fsync_test on this partition, and I got 2500+ for all kind of
sync method.
dmesg says:
blkfront: xvde: barriers enabled
blkfront: xvda: barriers enabled
One thing I haven't mentioned yet, that this a VM virtualized with Xen.
Perhaps this has some effect.
Thanks,
Otto
2011/12/20 Gre
26 matches
Mail list logo
