Hi,
The cluster name is defined in the preamble.sk file like,
cluster name=TestCLuster;
node 1 admin conninfo = 'service=MasterSlonik host=10.2.26.53 port=5432
user=postgres password=* dbname=master11';
node 2 admin conninfo = 'service=SlaveSlonik1 host=10.2.26.54 port=5433
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 boolean);
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
*
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
On Wed, Oct 6, 2010 at 1:24 AM, Jutta Buschbom
jutta.busch...@vti.bund.de 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
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 listed for
On Wed, Oct 6, 2010 at 12:24 AM, Vishnu S. vishn...@nestgroup.net 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
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
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:
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
-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
On Wed, Oct 6, 2010 at 14:17, Greg Sabino Mullane g...@turnstep.com 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
On Wed, Oct 6, 2010 at 2:48 AM, Trigve trig...@gmail.com 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
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
Hi,
I have some issue where
SELECT * from pg_stat_activity WHERE current_query='IDLE';
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_dump suddenly stops working:
C:\myapp\pg_dumppg_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 server
On 06/10/2010 14:26, Georgi Ivanov wrote:
Hi,
I have some issue where
SELECT * from pg_stat_activity WHERE current_query='IDLE';
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
Magnus Hagander mag...@hagander.net writes:
On Wed, Oct 6, 2010 at 14:17, Greg Sabino Mullane g...@turnstep.com 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
On Wed, Oct 6, 2010 at 15:54, Tom Lane t...@sss.pgh.pa.us wrote:
Magnus Hagander mag...@hagander.net writes:
On Wed, Oct 6, 2010 at 14:17, Greg Sabino Mullane g...@turnstep.com wrote:
But that's build-time, not run-time.
Correct, not sure of your point. Is this a problem? Build-time is
what
On Wed, Oct 6, 2010 at 3:34 AM, Min Yin y...@ai.sri.com 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.*
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
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 some
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
What
On 6. Okt, 08:48 h., Trigve trig...@gmail.com 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
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
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
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
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
--
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
2010/10/6 Little, Douglas douglas.lit...@orbitz.com
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
Is there a good doc w/ examples that instructs how to set up, monitor,
maintain, etc... a replication DB?
On 6 October 2010 15:44, Georgi Ivanov georgi.r.iva...@gmail.com 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
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 PostgreSQL
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
On Wed, Oct 6, 2010 at 3:33 PM, Raymond O'Donnell r...@iol.ie wrote:
On 06/10/2010 14:26, Georgi Ivanov wrote:
Hi,
I have some issue where
SELECT * from pg_stat_activity WHERE current_query='IDLE';
returns too many rows .
Any ideas why is this happening ?
Are you using any kind of
On 06/10/2010 20:26, Mathieu De Zutter wrote:
On Wed, Oct 6, 2010 at 3:33 PM, Raymond O'Donnellr...@iol.ie wrote:
On 06/10/2010 14:26, Georgi Ivanov wrote:
Hi,
I have some issue where
SELECT * from pg_stat_activity WHERE current_query='IDLE';
returns too many rows .
Any ideas why is this
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:
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
On Wed, Oct 6, 2010 at 6:53 PM, Vorpal vorpalswords...@shaw.ca 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
On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen m...@kitchenpc.com 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
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
On Wed, Oct 6, 2010 at 6:25 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen m...@kitchenpc.com 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
On Wed, Oct 6, 2010 at 6:27 PM, Mike Christensen m...@kitchenpc.com wrote:
On Wed, Oct 6, 2010 at 6:25 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Wed, Oct 6, 2010 at 7:18 PM, Mike Christensen m...@kitchenpc.com wrote:
My production server is running Postgres 9.0 on Ubuntu Server, and
Mike Christensen m...@kitchenpc.com 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
On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com 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
Mike Christensen m...@kitchenpc.com writes:
On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane t...@sss.pgh.pa.us 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)
On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com writes:
On Wed, Oct 6, 2010 at 6:42 PM, Tom Lane t...@sss.pgh.pa.us wrote:
What does ldd /opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so
say?
# ldd
Mike Christensen m...@kitchenpc.com writes:
On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane t...@sss.pgh.pa.us 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
On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com writes:
On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane t...@sss.pgh.pa.us 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
Mike Christensen m...@kitchenpc.com 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
On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com 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
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/support
Mike Christensen m...@kitchenpc.com writes:
On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com 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#
On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote:
On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com writes:
On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane t...@sss.pgh.pa.us wrote:
So you don't have libuuid installed. Go forth
On Wed, Oct 6, 2010 at 7:15 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com writes:
On Wed, Oct 6, 2010 at 6:59 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com writes:
However, libuuid.so.16 is still not found..
So have you got
On Wed, Oct 6, 2010 at 7:21 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote:
On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com writes:
On Wed, Oct 6, 2010 at 6:48 PM, Tom Lane
On Wed, Oct 6, 2010 at 7:24 PM, Mike Christensen m...@kitchenpc.com wrote:
On Wed, Oct 6, 2010 at 7:21 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
On Wednesday 06 October 2010 6:56:22 pm Mike Christensen wrote:
On Wed, Oct 6, 2010 at 6:51 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike
Mike Christensen m...@kitchenpc.com 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,
On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com 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
Mike Christensen m...@kitchenpc.com writes:
On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane t...@sss.pgh.pa.us 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
On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com writes:
On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane t...@sss.pgh.pa.us wrote:
If you have a libossp-uuid.so.16, you might try symlinking libuuid.so.16
to that instead of carrying a separate
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
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
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
mark dvlh...@gmail.com 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
-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
On Thu, Oct 7, 2010 at 05:09, Mike Christensen m...@kitchenpc.com wrote:
On Wed, Oct 6, 2010 at 7:56 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Mike Christensen m...@kitchenpc.com writes:
On Wed, Oct 6, 2010 at 7:38 PM, Tom Lane t...@sss.pgh.pa.us wrote:
If you have a libossp-uuid.so.16, you might
67 matches
Mail list logo