I just had a brief outage on a production server running 8.3.6, which
I suspect was triggered by me running a table bloat report making lots
of pgstattuple calls.
The first I got of it was the script I'd just kicked off died:
could not open segment 1 of relation 1663/16409/11088101 (target block
Hello,
I would like to implement parallel DB Architecture in postgres.I
came across various parallel architectures shared memory,shared disk,shared
nothing,hierarchical.But I am unaware of how to implement one of these in real
time system.Can you guys help me in this aspect?
2009/3/29 Bruno Baguette :
>
> I have a table that contains two timestamps (and some other fields that does
> not matter here).
>
> the_table
> --
> pk_planning_id ==> INT8 (primary key)
> timestamp_start ==> (not null timestamp without time zone)
> timestamp_stop =+> (not null timestamp
ray wrote:
> 1) The first question is how do I get this stack to look for the 2.6
> version?
Without rebuilding PL/Python, you can't. Python 2.5 and Python 2.6 are
not binary compatible.
You will need to install Python 2.5.
> If I make a copy of python26.dll and rename it python25.dll, that
> r
Eric Smith writes:
> Yes, if I start one, but not the other, the process works just great.
> It's only when trying to run both that I have a problem.
Have you looked into the postmaster logfile?
One likely idea is that you don't have shmall cranked up high enough
for two servers, which'd resu
Yes, if I start one, but not the other, the process works just great.
It's only when trying to run both that I have a problem.
Thanks,
Eric
On Mar 28, 2009, at 3:37 PM, Adrian Klaver wrote:
On Saturday 28 March 2009 3:27:15 pm Eric Smith wrote:
All,
I'm trying to run two database clusters
ray wrote:
I am installing PostgreSQL 8.3. I chose to include JDBC. During the
installation, this message was included:
JDBC
The JDBC drivers are installed into the jdbc\ subdirectory of the main
installation directory by default. You may wish to add this folder to
the CLASSPATH environment var
"V S P" writes:
> What does this LOG string mean, and what should I do?
That's supposed to be a can't-happen case. How did you provoke it
exactly? (No, you didn't provide enough detail for someone else
to reproduce it...)
Are you by any chance using database encoding mule_internal?
That's the
I am installing PostgreSQL 8.3. I chose to include JDBC. During the
installation, this message was included:
JDBC
The JDBC drivers are installed into the jdbc\ subdirectory of the main
installation directory by default. You may wish to add this folder to
the CLASSPATH environment variable to allo
I am trying to get Python 2.6 and PostgreSQL 8.3 to work together
under Windows 2000.
When I try to add Python to PostgreSQL via:
createlang plpythonu dbname
But when doing so, I get an error:
createlang: language installation failed: ERROR: could not load
library "C:/Program Files/PostgreSQL/8.
Hi,
I think I resolved my second question (about rollback modifing the
search_path)
I did not realize that I had to issue a commit
after set search_path
so what was happening is that when I did the rollback, the search path
was also gone.
The same problem was with my set client encoding (my othe
Hello !
I have a table that contains two timestamps (and some other fields that
does not matter here).
the_table
--
pk_planning_id ==> INT8 (primary key)
timestamp_start ==> (not null timestamp without time zone)
timestamp_stop =+> (not null timestamp without time zone)
I would lik
I have read that
if a given connection has an error,
it first must be rolledback (before any other statement on that
connection can
be executed).
Is this true for Selects as well?
In other words if select fails, should the connection be 'rolledback'?
I am trying to test my error handing
and havin
Hi,
I am seeing this error in my concole (winXP) log
using Pg 8.3 UTF-8 encoding
client is Pg ODBC latest,
every time I open a connection I set
client encoding to UTF-8 (to make sure my C++ app is getting via
ascii version of pgODBC the UTF-8 strings).
"SET client_encoding='UTF8'"
What does thi
SydMosh wrote:
Hi, i'm kinda new on postgresql, so i have a doubt, i'm trying to make a
query look like this:
http://img90.imageshack.us/img90/9440/consultaen.jpg
I feel like it is something so simple, show the "SUM(price_serv) AS total"
on a new line, but i just can't find the way. I've read th
I could be wrong, but I would swear I was once able to set up my foreign
key constraints so that the optimizer would not bother looking up rows in
tables that did not contribute to the result set. This is useful because I
can set up a single view that joins all the related tables together, but
ca
Eugenio Modesti writes:
> i tried and i got this output:
> WARNING: Calculated CRC checksum does not match value stored in file.
> Either the file is corrupt, or it has a different layout than this
> program is expecting. The results below are untrustworthy.
This is proof positive that you ha
Hi, i'm kinda new on postgresql, so i have a doubt, i'm trying to make a
query look like this:
http://img90.imageshack.us/img90/9440/consultaen.jpg
I feel like it is something so simple, show the "SUM(price_serv) AS total"
on a new line, but i just can't find the way. I've read the postgresql
man
Thanks to all that responded. I got it figured out. The one I was testing did
not have the associated table created yet (error message did not point me to a
solution). Created the referenced table and it worked like a chump, er champ.
Michael
From: michaelblack75...@hotmail.com
To: pg
On Mar 29, 2009, at 10:04 AM, Michael Black wrote:
First, I am relatively new to postgres, but have been using database
(design not administering) for about 20 years (you would think that
I could figure this out - lol). At an rate, I am trying to create
tables that have forgein keys via a
First, I am relatively new to postgres, but have been using database (design
not administering) for about 20 years (you would think that I could figure this
out - lol). At an rate, I am trying to create tables that have forgein keys
via a script. What happens is if the table that is referred
>
>
> Hi,
>>
>> i have a character varying variable and i concatenate with some other
>> variable, using the '||' operator.
>> the result of this concatenation should be the name of a column in my
>> table.
>>
>> however i don't know how to tell that this new concatenated string is a
>> column name
>
> Hi,
>
> i have a character varying variable and i concatenate with some other
> variable, using the '||' operator.
> the result of this concatenation should be the name of a column in my
> table.
>
> however i don't know how to tell that this new concatenated string is a
> column name.
> how to
Il giorno 29/mar/09, alle ore 11:34, Vibhor Kumar ha scritto:
Use the following command to know about the locale.
pg_controldata
hi
i tried and i got this output:
WARNING: Calculated CRC checksum does not match value stored in file.
Either the file is corrupt, or it has a different layout th
Hi,
i have a character varying variable and i concatenate with some other
variable, using the '||' operator.
the result of this concatenation should be the name of a column in my table.
however i don't know how to tell that this new concatenated string is a
column name.
how to do it ?
thanks.
--
Hi Eigenio,
Stefan has already mentioned the reason for the error.
It seems the database is not compatible with the binaries/server.
However, you can check the locale of data directory using the
pg_controldata , if the it is compatible with the server.
For information about the command:
htt
Hi Eugenio,
Use the following command to know about the locale.
pg_controldata
For more information, please follow the link given below:
http://www.postgresql.org/docs/8.3/static/app-pgcontroldata.html
Thanks & Regards,
Vibhor Kumar
www.enteprisedb.com
Stefan Kaltenbrunner wrote:
Eugenio Mod
On Mar 28, 12:57 pm, dp...@pgadmin.org (Dave Page) wrote:
> On Sat, Mar 28, 2009 at 4:21 PM, Scott Mead
>
>
>
>
>
> wrote:
>
> > On Sat, Mar 28, 2009 at 3:51 AM, ray wrote:
>
> >> I have installed 8.2 on a Windows 2000 laptop.
>
> >> I think it is installed. From the pgAdmin, it shows "Servers (
On Sun, Mar 29, 2009 at 10:24 AM, marcin mank wrote:
> I think (a part of) Your problem is that order by random() is O(N
> logN) complexity, while You are after O(N) .
>
> The solution (in pseudocode)
>
[snip]
OK, I may be guiding You the wrong way
select g,g,g,g from generate_series(1,2500
I think (a part of) Your problem is that order by random() is O(N
logN) complexity, while You are after O(N) .
The solution (in pseudocode)
random_sample(resultset,K):
result := first K rows from resultset
resultset.scrollto(K+1)
p = K+1
while(resultset.hasMoreRows())
row = result
30 matches
Mail list logo
