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@
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
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
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
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
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
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(
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
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.
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
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,
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
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
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,
>
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
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
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.
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
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
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
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 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
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 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
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
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
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
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
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
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 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
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
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
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
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 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
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
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 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
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 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
41 matches
Mail list logo