I'm attempting to get warm standby up and running with a pair of servers
running ubuntu 8.04 and postgresql 8.3. Been following the docs:
http://www.postgresql.org/docs/8.3/static/warm-standby.html
http://www.postgresql.org/docs/current/static/pgstandby.html
Also, basically following the ideas
hi,lee
CIDR is only accept ipv4 but not ip range such as 192.168.1.0/24.
INET type is what I need,but I don't know how to create index.
does anyone have ideas?
2009/2/27 Lee Azzarello
> On Thu, Feb 26, 2009 at 5:33 AM, Tony Liao wrote:
> > hello,everybody
> > I
During the compilation of PostgreSQL 8.3.6 on Solaris 10 1/06
s10a_u1wos_19a, I received the following error:
Undefined symbol ldap_start_tls_s first referenced in file libpq/SUBSYS.o
Using the nm command against the /usr/lib/libldap.so file did not locate
the ldap_start_tls_s object.
I had u
Thank you, but my problem is : psql can't make use of readline cmd line
history. I don't have a .psql_history file in my .~/ dir.
I installed/upgrade PG 8.3.6 from tarball as user postgress, psql will
conect to db but not history cmd line so far...any tips ?
OS: RHEL 5-64 bits
ldd /opt/pgsq
On Thu, 2009-02-26 at 01:08 +0300, Vladimir Rusinov wrote:
> First of all, you might want to use yum overlay for RHEL/CentOS:
> http://yum.postgresqlrpms.org/
http://yum.pgsqlrpms.org is a better URL (the other one is also valid,
but still...)
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~Post
Hi All,
I have installed Postgres 8.3.3 and Pgpool 2.2RC2 on two machines and* Both
*servers have the identical copy of the database running.
I have started postgres server on both machines and I have started pgpool on
both machines.
But for some reasons i am not able to connect to database throu
>>> "Scott Whitney" wrote:
> So, I got pretty close to my max_connections setting, and I had to
> up it last night. I did so, and I issued a pg_ctl reload. Everything
> _seems_ happy.
It's not. Note the comment:
# (change requires restart)
> However, the script I use to monitor this has th
Hi,
On Fri, Feb 27, 2009 at 3:17 AM, Scott Whitney wrote:
> So, I got pretty close to my max_connections setting, and I had to up it
> last night. I did so, and I issued a pg_ctl reload. Everything _seems_
> happy.
max_connections can only be set at server start.
Regards,
--
Fujii Masao
NIPPO
On Thu, 2009-02-26 at 12:17 -0600, Scott Whitney wrote:
> So, I got pretty close to my max_connections setting, and I had to up it
> last night. I did so, and I issued a pg_ctl reload. Everything _seems_
> happy.
>
> However, the script I use to monitor this has the number hard-coded in it
> (well
So, I got pretty close to my max_connections setting, and I had to up it
last night. I did so, and I issued a pg_ctl reload. Everything _seems_
happy.
However, the script I use to monitor this has the number hard-coded in it
(well, it looks it up from the conf file, anyway), and I'd rather get the
Hi Tom,
As per your advise I removed the old PG 8.3.6 installation and run again
configure and compiled the pg src.
here is my configure settings , mentioned the psql behavior have not
changed , I''m still not able to use history line from readline.
./configure --prefix=/opt/pgsql/ --with-inc
On Wed, Feb 25, 2009 at 3:05 AM, Lentes, Bernd
wrote:
> Hello ML,
>
> I'm very new to Postgres.
> In the log, i got messages concerning transaction ID wraparound.
What exact message did you get?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscripti
On Thu, Feb 26, 2009 at 5:33 AM, Tony Liao wrote:
> hello,everybody
> I want to create index for column ip1 and ip2.I know there is a
> contrib name ip4r.but the column ip1(ip2) would be a ip address or ip range.
> The query would do select ... where ip1>>='96.168.65.84' or
On Thu, Feb 26, 2009 at 7:02 AM, Nagalingam, Karthikeyan
wrote:
> Hi,
>
> I have some basic query in postgresql with storage, Please help me for the
> following
>
> 1. What is the best practice to use postgresql with storage.
Depends on your workload. My workload has a high number of DELETE
state
Amit Jain wrote :
Its a log analyzer tool through which you can trap the running
queries and have reports about update/delete/insterts which are
executing at database system.
http://pgfouine.projects.postgresql.org/
Lentes, Bernd wrote:
Its a log analyzer tool through which you can trap the running queries
and have reports about update/delete/insterts which are executing at
database system.
http://pgfouine.projects.postgresql.org/
Lentes, Bernd wrote:
Lee Azzarello wrote:
Sometimes the number grows by 5 in one second.
I
Lee Azzarello wrote:
> > Sometimes the number grows by 5 in one second.
> > I'm also astonished about the fact that all databases grow
> by the same amount.
> > Do you have any explanations for this behaviour ?
> > Why are the numbers growing so quickly ?
>
> What kind of work load is on the da
On Wed, Feb 25, 2009 at 5:05 AM, Lentes, Bernd
wrote:
> Hello ML,
>
> I'm very new to Postgres.
> In the log, i got messages concerning transaction ID wraparound.
> I red the documentation and made a vaccum on that database.
> In the documentation i also found the hint to look in the database with
Mónica, thanks for reply
I didn't install client, and i don't know how to check if it's instant or
complete. What I can do is:
[CODE]
tols...@heman:/opt/oracle> sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 26 14:40:01 2009
Copyright (c) 1982, 2005, Oracle. All rights reser
Daniel J. Summers wrote:
> Andrzej Zawadzki wrote:
>> Daniel J. Summers wrote:
>>
>>> Tony Liao wrote:
>>>
I try to explain analyze,but it doesn't work ,it use seq scan.
>>> Generally speaking, LIKE doesn't use indexes.
>>>
>> ?! That's not true at all!!
>>
[...]
> Po
Tom Lane schrieb:
> Peter Hinse writes:
>> More info: the statement is an INSERT with some huge subselects, running
>> every night on a PGSQL 8.3.6 on CentOS 4.7 x86_64. In 97% of all
>> occasions, the job terminates in about 1-2 minutes - however, sometimes
>> it just hangs. If terminated with ki
Hi,
I have some basic query in postgresql with storage, Please help me for
the following
1. What is the best practice to use postgresql with storage.
2. Which are the files and folders we can keep it in storage.
Regards
Karthikeyan.N
hello,everybody
I want to create index for column ip1 and ip2.I know there is a
contrib name ip4r.but the column ip1(ip2) would be a ip address or ip range.
The query would do select ... where ip1>>='96.168.65.84' or
ip2>>='96.168.65.84'.
does anyone have ideas?
thanks,Julius.
2009/2/26 Julius Tuskenis
> Hi Tony,
>
> Its not a bug - automatic casting was removed in 8.3. You should cast( a as
> text)||cast(b ... = cast(123456 as text). Other option is to define your own
> operators which is to be used only in case you can not fix clients of your
> datab
Hi Tony,
Its not a bug - automatic casting was removed in 8.3. You should cast( a
as text)||cast(b ... = cast(123456 as text). Other option is to define
your own operators which is to be used only in case you can not fix
clients of your database...
Tony Liao rašė:
hi,all
for example t
hi,all
for example tableA
create table tableA (
id serial,
a integer,
b integer,
c integer
);
insert into tableA (a,b,c) values (12,34,56);
then,
select id from tableA where (a||b||c)=123456;
in postgresql version 8.2.11,it works.
26 matches
Mail list logo
