On 12/27/10 11:00 PM, aaliya zarrin wrote:
Sorry, My application is using the postgres DB but the another
application is giving the command to run in standby or active mode.
I can't use gdb I beleive.
gdb just needs the PID of the process to attach to, you can get that
from ps or via other me
Sorry, My application is using the postgres DB but the another application
is giving the command to run in standby or active mode.
I can't use gdb I beleive.
Can you suggest any other way.
On Tue, Dec 28, 2010 at 12:18 PM, Fujii Masao wrote:
> On Tue, Dec 28, 2010 at 3:07 PM, aaliya zarrin
> wr
On Tue, Dec 28, 2010 at 3:07 PM, aaliya zarrin wrote:
> I didn't get? Do you want the syslog files or some more information?
Yeah, I want more information. You can get the backtrace by using gdb.
In detail, please see the following:
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_runni
I didn't get? Do you want the syslog files or some more information?
On Tue, Dec 28, 2010 at 11:32 AM, Fujii Masao wrote:
> On Tue, Dec 28, 2010 at 2:24 PM, aaliya zarrin
> wrote:
> > I am new to postgres. I am using 9.0.1 of postgres.
> > I am using Switch over functionality of Postgres and wa
On Tue, Dec 28, 2010 at 2:24 PM, aaliya zarrin wrote:
> I am new to postgres. I am using 9.0.1 of postgres.
> I am using Switch over functionality of Postgres and want to reduce the
> switch over time.
> I have implemented this using Signaling. After signaling the postmaster
> (startup process) on
On 12/27/10 6:21 PM, Tsutomu Nakajima wrote:
> <>
> PostGreSQL: 7.4.30 the postgres-installer ( postgresql-7.4.30.tar.gz)
> OS: AIXv5.2 TL09 (POWER5)
> Machine: 9119-590(1LPAR)
as others have said, 7.4 is really really old and completely at end of
life, and should certainly not be used for
Hi All,
I am new to postgres. I am using 9.0.1 of postgres.
I am using Switch over functionality of Postgres and want to reduce the
switch over time.
I have implemented this using Signaling. After signaling the postmaster
(startup process) once the trigger file is created and making PG to check
fo
On Mon, Dec 27, 2010 at 11:05 PM, Fujii Masao wrote:
> On Tue, Dec 28, 2010 at 11:21 AM, Tsutomu Nakajima
> wrote:
> > I add the information of freeze status in creating a database cluster.
> > The info is that the following process exists.
> >
> > postgres 1331432 708812 0 11:08:31 pts/10 0
On Tue, Dec 28, 2010 at 11:21 AM, Tsutomu Nakajima wrote:
> I add the information of freeze status in creating a database cluster.
> The info is that the following process exists.
>
> postgres 1331432 708812 0 11:08:31 pts/10 0:00 /bin/sh
> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
I add the information of freeze status in creating a database cluster.
The info is that the following process exists.
postgres 1331432 708812 0 11:08:31 pts/10 0:00 /bin/sh
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data -d
postgres 1347694 1331432 120 11:08:32 pts/10 0:05
/usr/local/pgs
Michael Satterwhite writes:
> On Monday, December 27, 2010 12:58:40 pm Guillaume Lelarge wrote:
>> Le 27/12/2010 18:57, Michael Satterwhite a écrit :
>>> I'm obviously missing something ... and probably something obvious. Why
>>> is date2 still null?
>>
>> I'm not sure it'll help you. I copy/past
Le 27/12/2010 22:16, Michael Satterwhite a écrit :
> On Monday, December 27, 2010 12:58:40 pm Guillaume Lelarge wrote:
>> Le 27/12/2010 18:57, Michael Satterwhite a écrit :
>>> I'm new to PostgreSQL, but have worked with other databases. I'm trying
>>> to write a trigger to default a timestamp colu
Michael,
I'm new to PostgreSQL, but have worked with other databases. I'm trying
to write a trigger to default a timestamp column to a fixed interval
before another. The test setup is as follows:
Try this pg_dump of a working example:
CREATE FUNCTION t_listing_startdate() RETURNS trigger
On 12/27/10 11:44 AM, Tom Lane wrote:
Right, but the key word in that sentence is "forwards". Dumping from an
8.3 database with 9.0 pg_dump will likely produce SQL that doesn't
reload into an 8.3 server, only into 9.0.
heh, thats what I was trying to say, before my first cup of coffee :)
sorry
On Mon, Dec 27, 2010 at 1:14 PM, Michael Satterwhite
wrote:
> I've *GOT* to be missing something in this post. You start by quoting the
> "Create Trigger" that attaches the trigger to the table. Then you tell me that
> I've got to do what you showed that I did.
Oops, your right, I miss-read you
Le 27/12/2010 22:02, Richard Broersma a écrit :
> On Mon, Dec 27, 2010 at 12:50 PM, InterRob wrote:
>> pgsql Command "\d test" produces the following:
>>Table "public.test"
>>Column | Type | Modifiers
>> +-+---
>> object_id | integer |
>> subject_id
Richard Broersma writes:
> On Mon, Dec 27, 2010 at 12:50 PM, InterRob wrote:
>> pgsql Command "\d test" produces the following:
>>Table "public.test"
>>Column | Type | Modifiers
>> +-+---
>> object_id | integer |
>> subject_id | integer |
>> Indexes
On Mon, Dec 27, 2010 at 12:50 PM, InterRob wrote:
> pgsql Command "\d test" produces the following:
> Table "public.test"
> Column | Type | Modifiers
> +-+---
> object_id | integer |
> subject_id | integer |
> Indexes:
> "EXCL_double_combi" EXCLUDE
Sorry: that is because the major part of my E-mail got chopped off...
Herewith I am resending it:
---
Dear list,
To rule out any double combination of two identifiers, in any order, I
applied the following constraint to a table:
CREATE TABLE test(
o
On Mon, Dec 27, 2010 at 8:31 AM, Rob Marjot wrote:
> Dear list,
> To rule out any double combination of two identifiers, in any order, I
> applied the following constraint to a table:
> CREATE TABLE test(object_id INTEGER, subject_id INTEGER, CONSTRAINT
I don't see the definition of your constrai
Patience is my friend. No transactions so no archiving. Waiting long enough
produced results. Sorry for the noise.
--
Later, Geoffrey
Sent from my iPhone
On Dec 27, 2010, at 3:18 PM, Geoffrey Myers wrote:
> Set up wal shipping on postgresql 8.3.9 and rhel 5.5. When I start the
> postmaster
On Mon, Dec 27, 2010 at 9:57 AM, Michael Satterwhite
wrote:
> CREATE TRIGGER t_listing_startdate before insert or update on test
> for each row execute procedure t_listing_startdate();
Now that you've created a trigger function, you need to attached to your table:
http://www.postgresql.o
Set up wal shipping on postgresql 8.3.9 and rhel 5.5. When I start the
postmaster on the primary, there is no reference to archiving in the log and
files do not get shipped. Had this working earlier, but the ssh keys were
accidentally over written breaking the shipping. Any clues?
--
Later, Geo
Le 27/12/2010 20:38, John R Pierce a écrit :
> On 12/27/10 11:00 AM, Guillaume Lelarge wrote:
>> Le 27/12/2010 18:27, Gauthier, Dave a écrit :
>>> Hi:
>>>
>>> I'm working with 2 different PG installs on 2 different linux
>>> servers, one running v9.0.1 and the other v8.3.4. The older install
>>> i
John R Pierce writes:
> On 12/27/10 11:00 AM, Guillaume Lelarge wrote:
>> psql should work the same, apart from new metacommands. I don't think
>> you'll experience issues with pg_ctl. I would not recommend you to user
>> pg_dump and pg_restore. They are pretty sensitive to the PostgreSQL release.
On 12/27/10 11:00 AM, Guillaume Lelarge wrote:
Le 27/12/2010 18:27, Gauthier, Dave a écrit :
Hi:
I'm working with 2 different PG installs on 2 different linux servers, one running v9.0.1
and the other v8.3.4. The older install is "frozen" for the project (which is
nearing completion) for env
Le 27/12/2010 18:27, Gauthier, Dave a écrit :
> Hi:
>
> I'm working with 2 different PG installs on 2 different linux servers, one
> running v9.0.1 and the other v8.3.4. The older install is "frozen" for the
> project (which is nearing completion) for environment stability reasons.
> This is
Le 27/12/2010 18:57, Michael Satterwhite a écrit :
> I'm new to PostgreSQL, but have worked with other databases. I'm trying to
> write a trigger to default a timestamp column to a fixed interval before
> another. The test setup is as follows:
>
> create table test
> ( date1 timestamp,
>
Michael,
I'm new to PostgreSQL, but have worked with other databases. I'm trying to
write a trigger to default a timestamp column to a fixed interval before
another. The test setup is as follows:
create table test
( date1 timestamp,
date2 timestamp
);
create or replace function t
hi,
this mail will be relatively long, because I need to explain in details
what/how I do.
Simple summary:
when restoring from hot backup, with out xlogs in pg_xlog/, but instead
using recovery.conf to get xlogs from wal archive, I get "WAL ends
before consistent recovery point" in case it should
But then a) because you can't guarantee this design won't 'improve' and
b) you would like to look in one place for all addresses, normalize now.
Thomas Kellerer wrote:
gvim wrote on 27.12.2010 02:47:
If a table representing contact details can have 2 but no more than 2
email addresses is it re
Hi:
I'm working with 2 different PG installs on 2 different linux servers, one
running v9.0.1 and the other v8.3.4. The older install is "frozen" for the
project (which is nearing completion) for environment stability reasons. This
is out of my control. I cannot upgrade v8.3.4 on that server
Hi,
In this particular case it isn't worth to add separate table just for
additional e-mail.
gvim Monday 27 December 2010 02:47:29
> If a table representing contact details can have 2 but no more than 2 email
> addresses is it really worth factoring-out email addresses to a separate
> table.
Dear list,
To rule out any double combination of two identifiers, in any order, I
applied the following constraint to a table:
CREATE TABLE test(object_id INTEGER, subject_id INTEGER, CONSTRAINT
Dear list,
To rule out any double combination of two identifiers, in any order, I
applied the following constraint to a table:
CREATE TABLE test(
object_id INTEGER,
subject_id INTEGER,
CONSTRAINT "EXCL_double_combi" EXCLUDE USING btree (imm_LEAST(subject_id,
object_id) WITH =, imm_GREATEST(
Merlin Moncure Monday 27 December 2010 15:30:27
> On Mon, Dec 27, 2010 at 4:00 AM, Radosław Smogura
>
> wrote:
> > Hi,
> >
> > Can I ask for implementing binary in / out at least for following types:
> >
> > void - usefull when using binary and procudre returns void
>
> yeah -- this is pretty
AI Rumman writes:
> I have very strange problem with my application, upon occasions I get
> following error when connecting to postgres. This happens without any
> pattern, often happens when I run some extensive tests in my application.
> Unable to connect to PostgreSQL server: server closed the
On Mon, Dec 27, 2010 at 4:00 AM, Radosław Smogura
wrote:
> Hi,
>
> Can I ask for implementing binary in / out at least for following types:
>
> void - usefull when using binary and procudre returns void
yeah -- this is pretty annoying/
> acl - in this way that role's/user's name will be visible
gvim wrote on 27.12.2010 02:47:
If a table representing contact details can have 2 but no more than 2
email addresses is it really worth factoring-out email addresses to a
separate table.
If you are absolutely sure you will never have more than two, then I agree, you
don't need to create a 1:N
Hi,
Can I ask for implementing binary in / out at least for following
types:
void - usefull when using binary and procudre returns void
acl - in this way that role's/user's name will be visible in binary
stream, so
there will be no need to requerying for user's name by the oid.
Kind regards
On 2010-12-26, sunpeng wrote:
> First I wondered whether the write speed on pc is lower than laptop, so i
> use a cp command to test a write speed:
that is often a test of read speed only.
as the writes will be cached.
--
⚂⚃ 100% natural
--
Sent via pgsql-general mailing list (pgsql-general@
41 matches
Mail list logo
