Hi All,
I have recently moved postgres from one server to another (a newer
server) and have encounter a problem I cant figure out. I have a table
(roughly 7.5GB) that gets re-created every night with fresh data, to
insert the data I run the following procedure.
Drop all indexes
Truncate Table
I
On Sun, 2009-07-26 at 18:57 +0200, Andreas Wenk wrote:
> Ubuntu has 8.4 allready, Debian will have it hopefully soon in
> backports. I don't know when it will be available in CentOS ...
CentOS/Red Hat/Fedora has (development snapshots of) 8.4 since Sep 3,
2008. :)
http://archives.postgresql.org/
On Wed, 2009-07-22 at 13:10 +0430, rahimeh khodadadi wrote:
> " checking for SSL_library_init in -lssl... no
> configure: error: library 'ssl' is required for OpenSSL"
Do you have redhat-rpm-config package installed?
Also, as Tom pointed out, you can use Red Hat or PGDG RPMs on CentOS:
http://yu
Devrim GÜNDÜZ schrieb:
CentOS/Red Hat/Fedora has (development snapshots of) 8.4 since Sep 3,
2008. :)
http://archives.postgresql.org/pgsql-hackers/2008-09/msg00208.php
good to know - thanks ;-)
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscript
"Thorne, Francis" writes:
> The problem I have is that it takes around 15 mins to insert the data
> into the table which is a massive improvement from the old server but it
> then takes 40 mins to create two indexes one 1GB index and another that
> is a 2GB index this is considerably slower than o
Hey,
I've got a problem on my new Sun server. I want to you compile postgresql8.4.0
with sunstudio. I try it by
./configure CC='/opt/SUNWspro/bin/cc -xtarget=native64' --enable-dtrace
DTRACEFLAGS='-64'--with-includes=/opt/sfw/include/ --with-libs=/opt/sfw/lib/
--prefix=/opt/postgresql/8.4.0
writes:
> when I compile without Sunstudio, everythings goes well:
> ...
> How can I compile with SunStudio using readline???
IOW, readline is there and gcc finds it, but SunStudio doesn't.
I'd bet a nickel it's in /usr/local/. gcc is customarily configured
to search /usr/local/include and /usr/
Hi Tom
Thanks for the quick response and useful information, having looked at
the current postgresql.conf file the locale settings are as follow
# These settings are initialized by initdb, but they can be changed.
lc_messages = 'en_US.UTF-8' # locale for system
error message
"Thorne, Francis" writes:
> How can I go about changing these to the C locale,
dump, initdb --no-locale, reload :-(. Note that the settings you
actually mentioned are not performance critical; it's lo_collate and
lc_ctype that count ... and those can only be set by initdb.
TRAN THI NGOC MAI wrote:
> Stopping postgresql service: [ OK ]
> Starting postgresql service: [ OK ]
So it appears that PostgreSQL is working OK. Right?
> 2009-07-26 11:58:49,037 ERROR service.ReliableFileTransferImpl
> [main
"Kevin Grittner" writes:
> TRAN THI NGOC MAI wrote:
>> 2009-07-26 11:58:49,037 ERROR service.ReliableFileTransferImpl
>> [main,:68] Unable to setup database driver with
>> pooling.Backend start-up failed: FATAL: database "rftDatabase", OID
>> 17142, has disappeared from pg_database
> If not,
Problem solved. I don't know why!
Nothing in the pg_hba.conf file or the postgresql.conf file appeared
to be a problem. I was still getting password authorization
failures. I thought the password had changed, perhaps, without my
knowing it. I changed the password to what it was original
Why does the following statement take very long
create table child_table_2009_08_01(check (datefield >= '2009-08-01
00:00:00' and datefield < '2009-08-02 00:00:00')) inherits
(parent_table)
Note that this is the first partition for the month of August.
Subsequent partitions are created very quic
Can I use a check constraint, or something other than a function to force a
column to be lowercase only?
Thx in advance
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
14 matches
Mail list logo
