Hi all.
As I need to maintain a rather large set of PgSQL scripts, I'd like to
use something like make in order to track changes and apply the
proper variations to the database.
Scripts have been named so that the lexicographical order of filenames brings
the information about dependencies.
I've
On 30.05.2007 23:31, Kevin Kempter wrote:
per considering DRDB as a replication solution in a failed master node
scenario, is there a risk of loosing not only in-flight transactions but alos
un-sync'd buffer-pool dirty pages?
If so, how might I minimize this risk ?
If you have DRBD using
On Thursday 31 May 2007 09:01, Vincenzo Romano wrote:
| As I need to maintain a rather large set of PgSQL scripts, I'd like to
| use something like make in order to track changes and apply the
| proper variations to the database.
|
| Scripts have been named so that the lexicographical order of
Thank you, Michael! I'm looking some examples and doing tests to find the
best search solution.
Best,
On 5/30/07, Michael Glaesemann [EMAIL PROTECTED] wrote:
On May 30, 2007, at 13:59 , Gabriel Laet wrote:
I'm developing an application where basically I need to store cars.
Every car has a
Hi all.
Can functions whose effect is to create functions (yep!)
be labelled as stable?
Thanks.
--
Vincenzo Romano
--
Maybe Computer will never become as intelligent as Humans.
For sure they won't ever become so stupid. [VR-1988]
---(end of
Hello list,
I have a problem regarding running a warm standby server as described in
the postgresql 8.2 documentation.
I set up two servers. Both running PostgreSQL 8.2.3-1PGDG on Fedora Core
6 (x86_64). (Master driven by AMD Opteron / Slave running on Intel Xeon)
The master server copys its
2007/5/31, Vincenzo Romano [EMAIL PROTECTED]:
Hi all.
Can functions whose effect is to create functions (yep!)
be labelled as stable?
According to the docs, no.
STABLE indicates that the function cannot modify the database (...)
any function that has side-effects must be classified volatile
Hi all,
I installed TSEARCH2 on Postgres8.1 (Debian).
It runs all fine.
I have 2 tables indexed, and created triggers to keep the vectorcolumns
up
to date.
However, the text I indexed is a mix of Dutch and English and German.
The default stemmingprocess is an annoyance for me.
I would
On Thursday 31 May 2007 13:23:36 Filip Rembiałkowski wrote:
2007/5/31, Vincenzo Romano [EMAIL PROTECTED]:
Hi all.
Can functions whose effect is to create functions (yep!)
be labelled as stable?
According to the docs, no.
STABLE indicates that the function cannot modify the database
On May 30, 6:48 am, Rodrigo De León [EMAIL PROTECTED] wrote:
You might want to add:
AND a.attnum =1
to remove tableoid and friends from the output.
Now I know why I did not get tableoid friends: because I am querying
a view which does not yield these fields. But to be on the save
2007/5/31, Vincenzo Romano [EMAIL PROTECTED]:
Nonetheless your remark makes a lot of sense and I'm still in dubt.
In my case the creatorfunc has no parameters and returns void as it reads
data from configuration tables.
And it should be OK if ti were run only once.
AFAIK, the only practical
Ok,
I confirmed that I'm editing the right pg_hba.conf file. I made sure
that there are no other postmasters running. I made sure that there is
a user called 'brakesh'. I restart the postmaster everytime I make any
changes to pg_hba.conf file. But still same results!
[EMAIL PROTECTED]
What is listen_addresses set to in postgresql.conf?
'*' corresponds to all available IP interfaces. Maybe
you are not listening on localhost.
On Thu, May 31, 2007 at 08:57:41AM -0400, Bhavana.Rakesh wrote:
Ok,
I confirmed that I'm editing the right pg_hba.conf file. I made sure
that
Hi,
Here's what happens when I specify the port number
[EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
psql: could not connect to server: Connection refused
Is the server running on host 127.0.0.1 and accepting
TCP/IP connections on port 5000?
I have the
On 5/31/07, Bhavana.Rakesh [EMAIL PROTECTED] wrote:
Ok,
I confirmed that I'm editing the right pg_hba.conf file. I made sure that
there are no other postmasters running. I made sure that there is a user
called 'brakesh'. I restart the postmaster everytime I make any changes to
pg_hba.conf
On Thu, 2007-05-31 at 09:01 +0200, Vincenzo Romano wrote:
Scripts have been named so that the lexicographical order of filenames
brings
the information about dependencies.
I've been playing with the GNU Make itself but it's quite hard to keep
track
of changes and to re-load a single SQL
Good points: I was struggling this very direction.
I think that the really good point to encode the dependencies
as comments into the SQL files themselves.
The hard parto is to let make follow the dependencies.
If I change a single SQL script I'd need to:
1. drop all objects that are in that
W/out specifying a -h switch, postgres defaults to using a UNIX domain
socket, meaning AF_UNIX and not AF_INET. There is a big difference.
Using -h 127.0.0.1 is the localhost not necessarily 'local' from the
context of postgres. W/out looking into the details, I think 'local' is
referring to
Frank Wittig [EMAIL PROTECTED] writes:
The problem is that the slave server stops checkpointing after some
hours of working (about 24 to 48 hours of conitued log replay).
Hm ... look at RecoveryRestartPoint() in xlog.c. Could there be
something wrong with this logic?
/*
* Do nothing
What does netstat -l tell us about that?
On Thu, May 31, 2007 at 02:50:50PM +0100, Oliver Elphick wrote:
On Thu, 2007-05-31 at 09:38 -0400, Bhavana.Rakesh wrote:
Hi,
Here's what happens when I specify the port number
[EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d
The manual say:
The operator name is a sequence of up to NAMEDATALEN-1 (63 by default)
characters from the following list:
+ - * / = ~ ! @ # % ^ | ` ?
So, how I could create a operator with word ( i.e. LIKE ) ?
---(end of broadcast)---
TIP 6:
Vincenzo Romano [EMAIL PROTECTED] writes:
quote
STABLE indicates that the function cannot modify the database,
They talk about table scans which should not involce the information schema
tables, the only tables that get modified by a fubction whose sole effect it
to create other
Thiago Ventura escribió:
The manual say:
The operator name is a sequence of up to NAMEDATALEN-1 (63 by default)
characters from the following list:
+ - * / = ~ ! @ # % ^ | ` ?
So, how I could create a operator with word ( i.e. LIKE ) ?
You can't. (Unless you hack Postgres' source
Tom Lane schrieb:
Are you sure the master is checkpointing?
Yes. I double checked using pg_controldata on the master.
On both servers checkpoint_segments is set to 16 and checkpoint_timeout
is 300 seconds default.
There were two messages in the logs of the master that checkpointing
happened too
On Thu, 2007-05-31 at 09:38 -0400, Bhavana.Rakesh wrote:
Hi,
Here's what happens when I specify the port number
[EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
psql: could not connect to server: Connection refused
Is the server running on host 127.0.0.1 and
Bhavana.Rakesh escribió:
Hi,
Here's what happens when I specify the port number
[EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
psql: could not connect to server: Connection refused
Is the server running on host 127.0.0.1 and accepting
TCP/IP
Hi all.
I'd like to know whether there is any real world evaluation (aka test) on
performances of the NUMERIC data type when compared to FLOAT8 and FLOAT4.
The documentation simply says that the former is much slower than the latter
ones.
I'd also be interested into data storage evaluations.
--
tsearch indexes have to reside in the table where the data is, for the
automagical functions that come with it to work. You can define a
view that joins the tables, then search each of the index columns for
the values you are looking for.
In my experience, the LIKE searches are fast for
Vincenzo Romano escribió:
Hi all.
I'd like to know whether there is any real world evaluation (aka test) on
performances of the NUMERIC data type when compared to FLOAT8 and FLOAT4.
The documentation simply says that the former is much slower than the latter
ones.
It is. But why do you
Ian Harding wrote:
tsearch indexes have to reside in the table where the data is, for the
automagical functions that come with it to work. You can define a
view that joins the tables, then search each of the index columns for
the values you are looking for.
No they don't.
Joshua D. Drake
On Thu, 31 May 2007, Erwin Moller wrote:
Hi all,
I installed TSEARCH2 on Postgres8.1 (Debian).
It runs all fine.
I have 2 tables indexed, and created triggers to keep the vectorcolumns
up
to date.
However, the text I indexed is a mix of Dutch and English and German.
The default
I found out that using 'simple' instead of 'default' when using
to_tsvector() does excactly that, but I don't know how to change my
triggers and indexes to keep doing the same (using 'simple').
Suppose, your database is initialized with C locale. So, just mark
simple configuration as
Hi.
I want to use array for store some values (bytes_in and bytes_out) and
use array index as id. But I got an errors...
My example function extract traf_id, bytes_in, bytes_out and try to
fill an array, like this
CREATE OR REPLACE FUNCTION myf_test() RETURNS void
AS $$
DECLARE
p_tmp RECORD;
On May 23, 2007, at 1:12 PM, Donald Laurine wrote:
Now my question. The performance of each of these databases is
decreasing. I measure the average insert time to the database. This
metric has decreased by about 300 percent over the last year. I run
vacuum analyze and vacuum analyze full
Bhavana.Rakesh [EMAIL PROTECTED] writes:
Here's what happens when I specify the port number
[EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
psql: could not connect to server: Connection refused
Is the server running on host 127.0.0.1 and accepting
I am currently having a problem with an application that has been
working fine for the past few months. Whenever I try to add a new entry
into a table I receive the following message:
ERROR: permission denied for sequnce contractid
I have checked the permission for this sequence as well as the
I understand that it is possible for tables from different databases that have
the exact same data
but different Encoding can sort rows in differet orders.
Could this allow affect the order that triggers and rules are fired?
Regards,
Richard Broersma Jr.
---(end of
On May 25, 2007, at 5:28 PM, Tom Lane wrote:
That's true at the level of DDL operations, but AFAIK we could
parallelize table-loading and index-creation steps pretty effectively
--- and that's where all the time goes.
I would be happy with parallel builds of the indexes of a given
table.
Richard Broersma Jr [EMAIL PROTECTED] writes:
I understand that it is possible for tables from different databases that
have the exact same data
but different Encoding can sort rows in differet orders.
Could this allow affect the order that triggers and rules are fired?
AFAIK, no --- those
On 5/31/07, Richard Broersma Jr [EMAIL PROTECTED] wrote:
I understand that it is possible for tables from different databases that
have the exact same data
but different Encoding can sort rows in differet orders.
Could this allow affect the order that triggers and rules are fired?
This
On May 31, 2007, at 14:53 , Hackenberg, Rick wrote:
I am currently having a problem with an application that has been
working fine for the past few months. Whenever I try to add a new
entry into a table I receive the following message:
ERROR: permission denied for sequnce contractid
On Thu, May 31, 2007 at 04:07:25PM -0400, Tom Lane wrote:
the kernel rejected the connection before looking for a listening process.
or a host-based firewall might produce the same result.
---(end of broadcast)---
TIP 3: Have you checked our
On Thu, 31 May 2007 22:20:09 +0200, Vivek Khera [EMAIL PROTECTED] wrote:
On May 25, 2007, at 5:28 PM, Tom Lane wrote:
That's true at the level of DDL operations, but AFAIK we could
parallelize table-loading and index-creation steps pretty effectively
--- and that's where all the time goes.
On Thu, 31 May 2007 23:36:32 +0200, PFC [EMAIL PROTECTED] wrote:
On Thu, 31 May 2007 22:20:09 +0200, Vivek Khera [EMAIL PROTECTED] wrote:
On May 25, 2007, at 5:28 PM, Tom Lane wrote:
That's true at the level of DDL operations, but AFAIK we could
parallelize table-loading and index-creation
Hello Everybody!
I know that something doing wrong, but I can't find out what is it. This
is a part from trigger function:
/
attnum[3] = SPI_fnumber( tupdesc, arfolyam );
datums[3] = _selectFunctionB( SELECT ertek FROM foo WHERE
parameter='rate' ); // this come back with Datum type from
Greg Smith wrote:
[...]
-Find something harmless I can execute in a loop that will generate WAL
activity, run that until the segment gets archived. Haven't really
thought of something good to use for that purpose yet.
Some time ago I started a thread about taking on-the-fly backups at file
I have postgresql running several databases. I can stop them all by
stopping postgresql, but sometimes I'd like to shut down a single database.
Can I get the same effect of stopping postgresql for only one database?
--
Non c'e' piu' forza nella normalita', c'e' solo monotonia.
signature.asc
Ottavio Campana [EMAIL PROTECTED] wrote:
I have postgresql running several databases. I can stop them all by
stopping postgresql, but sometimes I'd like to shut down a single database.
Can I get the same effect of stopping postgresql for only one database?
You can tweak pg_hba.conf to
Bill Moran wrote:
Ottavio Campana [EMAIL PROTECTED] wrote:
I have postgresql running several databases. I can stop them all by
stopping postgresql, but sometimes I'd like to shut down a single database.
Can I get the same effect of stopping postgresql for only one database?
You can tweak
I did something like this with a single VALUES statment [eg: VALUES
((2),(3))]
and thought I could extend this to two columns
But I'm not having any luck.
BTW - history_idx is an integer and token_idx is a bigint.
select v.history.idx, v.token_idx
from (
values ((3,1),(3,2))) as
Hi,
is there a packet source for recent PostgreSQL binaries?
I just finished installing OpenSUSE 10.2 and like to add PostgreSQL
8.2.4 instead of the provided 8.1.5.
I'd rather go with something that is at least vaguely official.
PostgreSQL.org has only binaries for fedora+redhat and I found
Ottavio Campana wrote:
Bill Moran wrote:
Ottavio Campana [EMAIL PROTECTED] wrote:
I have postgresql running several databases. I can stop them all by
stopping postgresql, but sometimes I'd like to shut down a single database.
Can I get the same effect of stopping postgresql for only one
Joshua D. Drake wrote:
Ottavio Campana wrote:
Bill Moran wrote:
Ottavio Campana [EMAIL PROTECTED] wrote:
I have postgresql running several databases. I can stop them all by
stopping postgresql, but sometimes I'd like to shut down a single
database.
Can I get the same effect of stopping
On Thu, 31 May 2007, Marco Colombo wrote:
archive_command = 'test ! -f /var/lib/pgsql/backup_lock /dev/null'
Under normal condition (no backup running) this will trick PG into thinking
that segments get archived. If I'm not mistaken, PG should behave exactly as
if no archive_command is
Ottavio Campana wrote:
Joshua D. Drake wrote:
Ottavio Campana wrote:
Bill Moran wrote:
Ottavio Campana [EMAIL PROTECTED] wrote:
I have postgresql running several databases. I can stop them all by
stopping postgresql, but sometimes I'd like to shut down a single
database.
Can I get the same
Tom Allison [EMAIL PROTECTED] writes:
select v.history.idx, v.token_idx
from (
values ((3,1),(3,2))) as v(history_idx, token_idx)
left outer join history_token ht on v.history_idx = ht.history_idx
and v.token_idx = ht.token_idx
where ht.history_idx is null;
ERROR: operator does not exist:
=?ISO-8859-2?Q?Dud=E1s_J=F3zsef?= [EMAIL PROTECTED] writes:
I know that something doing wrong, but I can't find out what is it.
Getting a stack trace from the point of the errfinish call would
probably help narrow it down. One thing that's not clear is whether
SPI_modifytuple itself is failing
On 5/31/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
Ian Harding wrote:
tsearch indexes have to reside in the table where the data is, for the
automagical functions that come with it to work. You can define a
view that joins the tables, then search each of the index columns for
the values
Ian Harding wrote:
On 5/31/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
Ian Harding wrote:
tsearch indexes have to reside in the table where the data is, for the
automagical functions that come with it to work. You can define a
view that joins the tables, then search each of the index
Thanks for your reply!
I was run gdb and errfinish but didn't get much help because I write to
list.
Yes the first datas ( datums[0-2] ) are char* / VARCHAR types and if I
call SPI_modifytuple( ( trigdata-tg_relation, tmptuple, 3, attnum[0],
datums[0], isNull[0] ) than everything is OK.
Just
Hi All,
I want to create a user in Postgres Database. And I want to restrict that user
with some privileges. And also I want that user should be specific to
particular database.
He should not be able to do the following
1) Connect to any other database.
2) Connect to System
hello,
you have to initialise array before using. Like:
declare a int[] = '{0,0,0,0,0, .}';
begin
a[10] := 11;
..
reason: older postgresql versions unsuported nulls in array
regards
Pavel
2007/5/31, Anton [EMAIL PROTECTED]:
Hi.
I want to use array for store some values
62 matches
Mail list logo