Is there any tutorials or detailed instructions on how to set up HA postgresql
& failover? The documentation
(http://www.postgresql.org/docs/9.0/interactive/warm-standby-failover.html) on
this topics is pretty scarce.
The scenario I'm most interested in is this:
2 servers - a master and a hot
no, simple dedicated server with Linux Fedora 13 x86_64
kernel-2.6.33.6-147.2.4.fc13.x86_64
2010/10/6 Alvaro Herrera :
> Excerpts from Timon's message of mié oct 06 07:35:44 -0400 2010:
>> today I found in logs:
>>
>> WARNING: pgstat wait timeout
>> WARNING: pgstat wait timeout
>> PANIC: stuck
Vorpal, 07.10.2010 02:53:
PostgreSQL was installed as part of other software.
The data folder is a subfolder of D:\Program Files\
Specifically:
"D:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N
"pgsql-8.3" -D "D:\Program Files\PostgreSQL\8.3\data\"
For various reasons I would li
On Thu, Oct 7, 2010 at 05:09, Mike Christensen wrote:
> On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane wrote:
>> Mike Christensen writes:
>>> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote:
If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
to that instead of carrying
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, October 06, 2010 11:14 PM
To: mark
Cc: r...@iol.ie; 'Mathieu De Zutter'; 'Georgi Ivanov';
pgsql-general@postgresql.org
Subject: Re: [GENERAL] Idle connections
>What you're describing sounds a lot like the k
"mark" writes:
> If you get to many persistent or otherwise idle connections you might be
> inducing a "thundering herd" condition. Seems like on our servers we hit a
> wall with just having a lot of persistent connections from various apps. I
> don't really understand everything involved here but
both servers are on same gigabit switch.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Dear List ,
We have setup primary/slave in HS & SR mode. We are diverting a part of
read only queries to the slave.
The problem is that we are intermittently getting errors
ERROR: canceling statement due to conflict with recovery
on slave. We know that the tables which are participating in th
Just something I have observed recently and I don't know how accurate my
findings are. They might relate to your 'overloaded with idle connection'
issues.
If you get to many persistent or otherwise idle connections you might be
inducing a "thundering herd" condition. Seems like on our servers we
On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane wrote:
> Mike Christensen writes:
>> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote:
>>> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
>>> to that instead of carrying a separate file.
>
>> So now what you're saying is if it's no
Mike Christensen writes:
> On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote:
>> If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
>> to that instead of carrying a separate file.
> So now what you're saying is if it's not broke, fix it till it is :)
Well, it's hard to argue
On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane wrote:
> Mike Christensen writes:
>> Yup that's exactly what I did.. I'm on 10.04, which doesn't have
>> libuuid 1.6 in the software repository, go figure..
>
> Oh ... we're in package-naming hell, is where we are. Poking around
> some more on my Fedora
Mike Christensen writes:
> Yup that's exactly what I did.. I'm on 10.04, which doesn't have
> libuuid 1.6 in the software repository, go figure..
Oh ... we're in package-naming hell, is where we are. Poking around
some more on my Fedora 13 box, I find I have two different, similarly
named packa
On Wed, Oct 6, 2010 at 7:24 PM, Mike Christensen wrote:
> On Wed, Oct 6, 2010 at 7:21 PM, Adrian Klaver wrote:
>> On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote:
>>> On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane wrote:
>>> > Mike Christensen writes:
>>> >> On Wed, Oct 6, 2010 at 6:
On Wed, Oct 6, 2010 at 7:21 PM, Adrian Klaver wrote:
> On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote:
>> On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane wrote:
>> > Mike Christensen writes:
>> >> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane wrote:
>> >>> So you don't have libuuid installe
On Wed, Oct 6, 2010 at 7:15 PM, Tom Lane wrote:
> Mike Christensen writes:
>> On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane wrote:
>>> Mike Christensen writes:
However, libuuid.so.16 is still "not found"..
>>>
>>> So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case
>>> may b
On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote:
> On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane wrote:
> > Mike Christensen writes:
> >> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane wrote:
> >>> So you don't have libuuid installed. Go forth and get it ...
> >>
> >> What's the easiest way
Mike Christensen writes:
> On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane wrote:
>> Mike Christensen writes:
>>> However, libuuid.so.16 is still "not found"..
>>
>> So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case
>> may be)?
> /usr/lib# ls -l libuuid*
> -rw-r--r-- 1 root root
On 05/10/10 16:08, Mike Christensen wrote:
>at Npgsql.NpgsqlCommand.CheckConnectionState() at
> Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) at
It looks like nobody reading -GENERAL really speaks npgsql/.NET/C#.
Perhaps you should try on the npgsql list instead?
Try filing a bug/suppor
On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane wrote:
> Mike Christensen writes:
>> However, libuuid.so.16 is still "not found"..
>
> So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case
> may be)?
>
> regards, tom lane
>
/usr/lib# ls -l libuuid*
-rw-r--r-- 1
Mike Christensen writes:
> However, libuuid.so.16 is still "not found"..
So have you got libuuid.anything in /usr/lib (or /usr/lib64 as the case
may be)?
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane wrote:
> Mike Christensen writes:
>> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane wrote:
>>> So you don't have libuuid installed. Go forth and get it ...
>
>> What's the easiest way to do that? Is there a .bin file I can run?
>> Or a URL I can wget? Thanks
Mike Christensen writes:
> On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane wrote:
>> So you don't have libuuid installed. Go forth and get it ...
> What's the easiest way to do that? Is there a .bin file I can run?
> Or a URL I can wget? Thanks!
I'd expect it'd be available as a standard package fo
On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane wrote:
> Mike Christensen writes:
>> On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane wrote:
>>> What does "ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so"
>>> say?
>
>> # ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
>> linux-vdso.so.1 => (0x00
Mike Christensen writes:
> On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane wrote:
>> What does "ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so"
>> say?
> # ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
> linux-vdso.so.1 => (0x7fff5a5ff000)
> libuuid.so.16 => not found
>
On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane wrote:
> Mike Christensen writes:
>> Oh btw, the file does actually exist.. Maybe it's missing some
>> permission or something?
>
>> ls -l /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
>> -rwxr-xr-x 1 root daemon 12648 Oct 3 20:03
>> /opt/PostgreSQL/9.
Mike Christensen writes:
> Oh btw, the file does actually exist.. Maybe it's missing some
> permission or something?
> ls -l /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
> -rwxr-xr-x 1 root daemon 12648 Oct 3 20:03
> /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
What does "ldd /opt/Postgr
On Wed, Oct 6, 2010 at 6:27 PM, Mike Christensen wrote:
> On Wed, Oct 6, 2010 at 6:25 PM, Scott Marlowe wrote:
>> On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen wrote:
>>> My production server is running Postgres 9.0 on Ubuntu Server, and I'm
>>> getting some errors in sprocs that call uuid_ge
On Wed, Oct 6, 2010 at 6:25 PM, Scott Marlowe wrote:
> On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen wrote:
>> My production server is running Postgres 9.0 on Ubuntu Server, and I'm
>> getting some errors in sprocs that call uuid_generate_v1().. This is
>> because the function is missing.
>>
Vorpal wrote:
PostgreSQL was installed as part of other software.
The data folder is a subfolder of D:\Program Files\
Specifically:
"D:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N
"pgsql-8.3" -D "D:\Program Files\PostgreSQL\8.3\data\"
For various reasons I would like the data d
On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen wrote:
> My production server is running Postgres 9.0 on Ubuntu Server, and I'm
> getting some errors in sprocs that call uuid_generate_v1().. This is
> because the function is missing.
>
> On my Windows box, this function would automatically be in
On Wed, Oct 6, 2010 at 6:53 PM, Vorpal wrote:
>
> PostgreSQL was installed as part of other software.
> The data folder is a subfolder of D:\Program Files\
> Specifically:
> "D:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N
> "pgsql-8.3" -D "D:\Program Files\PostgreSQL\8.3\data\"
>
My production server is running Postgres 9.0 on Ubuntu Server, and I'm
getting some errors in sprocs that call uuid_generate_v1().. This is
because the function is missing.
On my Windows box, this function would automatically be installed as
part of the database.. If I try to create the function
PostgreSQL was installed as part of other software.
The data folder is a subfolder of D:\Program Files\
Specifically:
"D:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N
"pgsql-8.3" -D "D:\Program Files\PostgreSQL\8.3\data\"
For various reasons I would like the data directory to be:
On 06/10/2010 20:26, Mathieu De Zutter wrote:
On Wed, Oct 6, 2010 at 3:33 PM, Raymond O'Donnell wrote:
On 06/10/2010 14:26, Georgi Ivanov wrote:
Hi,
I have some issue where
SELECT * from pg_stat_activity WHERE current_query='';
returns too many rows .
Any ideas why is this happening ?
Are y
On Wed, Oct 6, 2010 at 3:33 PM, Raymond O'Donnell wrote:
> On 06/10/2010 14:26, Georgi Ivanov wrote:
>>
>> Hi,
>> I have some issue where
>> SELECT * from pg_stat_activity WHERE current_query='';
>> returns too many rows .
>> Any ideas why is this happening ?
>
> Are you using any kind of connecti
On 06/10/2010 18:53, Massa, Harald Armin wrote:
Peter,
This is normal. Postgres is said to have a multi-process architecture
(which is often contrasted with a multi threaded architecture). The
number of processes isn't very predictable.
you are right, it is normal.
But the number o
Peter,
> This is normal. Postgres is said to have a multi-process architecture
> (which is often contrasted with a multi threaded architecture). The
> number of processes isn't very predictable.
>
> you are right, it is normal.
But the number of processes is quite predictable:
on default Postgr
On 6 October 2010 15:44, Georgi Ivanov wrote:
> Hi,
> I wander why i see several postgres server processes with different PIDs
> I don't mean those normal query processes. I see several of these:
> /usr/lib/postgresql/8.4/bin/postgres -D /database/postgresql/8.4/main -c
> config_file=/etc/postgres
Is there a good doc w/ examples that instructs how to set up, monitor,
maintain, etc... a replication DB?
2010/10/6 Little, Douglas
>
>
>
>
> Unfortunately the variable doesn’t get replaced due to the quotes.
>
> COMMENT ON INDEX mdm_mart_tbls.mdm_gotoastcampaignevt_pk IS 'created by
> dwda-1618 on :currtime';
>
>
>
> I’ve tried various options, 2,3,4 quotes. Concatenation, Building the
> entire st
All,
Is there a way to do this other than using the backup feature?
__
I am trying to create two databases in two different machines connected
over the lan. Both the databases have similar tables and fields in them.
I will be upda
Greetings
I have a customized search_path for my database. When I backup (pgdump) the
database and restore it to another server, the search_path must be reset,
since it reverts to $User, public upon restore.
Why is the search_path info not being retained in the backup?
Thank you!
Jonathan
--
Se
Yes that works. Thanks a lot!
Now what if I want to get not only user_id, but the full record of the
user, which is in another table called users. The following query
doesn't seem to work
select users.id, users.*, max(orders.order_time) from users join orders
on users.id=orders.user_id grou
I'm trying to generate a comment on all my changes - so I know when they were
completed.
Does anybody have anything that does this.
I think the psql script is something like
d1gp1=> \set currtime `date '+20%y-%m-%d %H:%M:%S'`
d1gp1=> \echo :currtime
2010-10-06 10:01:51
d1gp1=> comment on index
Hi Yes that works too. Many Thanks!
Now as you have probably , what I really want to get the full record of
the user, which is in another table called users. The following query
doesn't seem to work
select users.id, users.* from users join orders on
users.id=orders.user_id group by users.id
On 6. Okt, 08:48 h., Trigve wrote:
> Hi,
> I'm trying to make a custom composite type and use it as a PK and FK.
> When adding FK to table I've got trhis error: operator is not unique:
> "BigintRef" pg_catalog.= "BigintRef" (see below). Here is my type
> definition with operator:
>
> CREATE TYPE "
Excerpts from Timon's message of mié oct 06 07:35:44 -0400 2010:
> today I found in logs:
>
> WARNING: pgstat wait timeout
> WARNING: pgstat wait timeout
> PANIC: stuck spinlock (0x7fd877761af8) detected at dynahash.c:981
> PANIC: stuck spinlock (0x7fd877761af8) detected at dynahash.c:981
Wha
Excerpts from Thom Brown's message of lun oct 04 14:40:23 -0400 2010:
> Hi all,
>
> We're currently testing a new javascript change on the PostgreSQL
> docs. This is to make sure monospaced fonts still appear at a
> reasonable size between browsers. I'd appreciate it if some of you
> could do so
Hi,
I wander why i see several postgres server processes with different PIDs
I don't mean those normal query processes. I see several of these:
/usr/lib/postgresql/8.4/bin/postgres -D /database/postgresql/8.4/main -c
config_file=/etc/postgresql/8.4/main/postgresql.conf
With different pids. Is this
On Wed, Oct 6, 2010 at 3:34 AM, Min Yin wrote:
> Hi Yes that works too. Many Thanks!
>
> Now as you have probably , what I really want to get the full record of the
> user, which is in another table called users. The following query doesn't
> seem to work
>
> select users.id, users.* from users j
On Wed, Oct 6, 2010 at 15:54, Tom Lane wrote:
> Magnus Hagander writes:
>> On Wed, Oct 6, 2010 at 14:17, Greg Sabino Mullane wrote:
But that's build-time, not run-time.
>>>
>>> Correct, not sure of your point. Is this a problem? Build-time is
>>> what we want here (determining the libpq we
Magnus Hagander writes:
> On Wed, Oct 6, 2010 at 14:17, Greg Sabino Mullane wrote:
>>> But that's build-time, not run-time.
>>
>> Correct, not sure of your point. Is this a problem? Build-time is
>> what we want here (determining the libpq we were built with)
> The original question was how to
On 06/10/2010 14:26, Georgi Ivanov wrote:
Hi,
I have some issue where
SELECT * from pg_stat_activity WHERE current_query='';
returns too many rows .
What do you mean by "too many"?
What is the meaning of IDLE ?
It means a client is keeping a connection open, but not executing any
queries.
pg_dump suddenly stops working:
C:\myapp\pg_dump>pg_dump -i -Z6 -b -v -f "E:\backup\mybackup.backup" -F c -h
localhost -U postgres mydb
pg_dump: [archiver (db)] connection to database "mydb" failed: could not
connect
to server: No buffer space available (0x2747/10055)
Is the serve
Hi,
I have some issue where
SELECT * from pg_stat_activity WHERE current_query='';
returns too many rows .
What is the meaning of IDLE ?
I suspect that the server is overloaded with idle connections, but i don't
know why .
Sometimes i am forced to do
SELECT pg_terminate_backend(procpid) from pg_s
Hallo Craig,
I found the repository and am considering switching to rpms. Compiling
from source actually was more straightforward for me initially, but in
the long run rpms probably are the better option. Thanks for the suggestion.
Jutta
On 06.10.2010 10:17, Craig Ringer wrote:
On 06/10/10
On Wed, Oct 6, 2010 at 2:48 AM, Trigve wrote:
> Hi,
> I'm trying to make a custom composite type and use it as a PK and FK.
> When adding FK to table I've got trhis error: operator is not unique:
> "BigintRef" pg_catalog.= "BigintRef" (see below). Here is my type
> definition with operator:
>
> CR
On Wed, Oct 6, 2010 at 14:17, Greg Sabino Mullane wrote:
>
>
>> Not sure what you mean. pg_config *drives* the compilation and linking,
>> we don't blindly compile and simply take pg_config's word for it.
>> pg_config --libdir and pg_config --includedir.
>
>> But that's build-time, not run-time.
>
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Not sure what you mean. pg_config *drives* the compilation and linking,
> we don't blindly compile and simply take pg_config's word for it.
> pg_config --libdir and pg_config --includedir.
> But that's build-time, not run-time.
Correct, not
This is reassuring. Thank you, Scott. Jutta
You can install them later. The only things you can't change without
a dump and reload are architectural, like integer datestamps and 32
versus 64 bit.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
today I found in logs:
WARNING: pgstat wait timeout
WARNING: pgstat wait timeout
PANIC: stuck spinlock (0x7fd877761af8) detected at dynahash.c:981
PANIC: stuck spinlock (0x7fd877761af8) detected at dynahash.c:981
...
LOG: server process (PID 8078) was terminated by signal 6: Aborted
LOG: ter
Tom,
I found the next system header files:
/usr/include/sys/ioctl.h
/usr/include/net/if.h
/usr/include/net/if6.h
/usr/include/sys/ioctl.h
#define SIOCGLIFCONF_IOWR('I',20, struct if_laddrconf) /*get l_addr
list */
Lifreq is declared in if.h While if_laddrconf is declared in if6.h
So a
On Wed, Oct 6, 2010 at 12:24 AM, Vishnu S. wrote:
> Hi,
>
> I have some doubts. Whether Replication will work if Master database server
> and slave database server are on the same machine?
I've set this up for testing, and it worked just fine.
> Is the communication is
> via services ? Is it req
On 06/10/10 15:24, Jutta Buschbom wrote:
> At our institute we decided to use PostGreSQL as our new server-based
> database system. The installation of PostGreSQL 9.0.0 on SLES 10 x64
> went fine.
>
> [snip]
>
> Thus, my question: using “./configure –help” quite a lot of optional
> packages are lis
On Wed, Oct 6, 2010 at 1:24 AM, Jutta Buschbom
wrote:
> Hallo,
>
> At our institute we decided to use PostGreSQL as our new server-based
> database system. The installation of PostGreSQL 9.0.0 on SLES 10 x64 went
> fine. However, before I start configuring the system and start creating
> databases
Hallo,
At our institute we decided to use PostGreSQL as our new server-based
database system. The installation of PostGreSQL 9.0.0 on SLES 10 x64
went fine. However, before I start configuring the system and start
creating databases, users etc. I am wondering, which functionality I
need to gi
Hi,
I have some doubts. Whether Replication will work if Master database
server and slave database server are on the same machine? Is the
communication is via services ? Is it required that both Master and
Slave must have same slony service name?
Thanks & Regards,
Vishnu S
*
Hi,
I'm trying to make a custom composite type and use it as a PK and FK.
When adding FK to table I've got trhis error: operator is not unique:
"BigintRef" pg_catalog.= "BigintRef" (see below). Here is my type
definition with operator:
CREATE TYPE "BigintRef" AS
("Value" bigint,
"Null" bool
69 matches
Mail list logo