Thank you guys for the answers.
On Tue, Apr 28, 2009 at 6:06 PM, Joshua D. Drake wrote:
>
> >
> > Ops team want to install postgres as (usr/local/bin) using RPM, and
> > want to keep the data directory under (/var/lib/data/pgsql) and they
> > say that we cannot have two versions at the same time
On Mon, Apr 27, 2009 at 3:24 PM, Richard Broersma
wrote:
> On Mon, Apr 27, 2009 at 1:32 PM, Scott Marlowe
> wrote:
>> OK, I'm hitting a wall here. I've written this trigger for partitioning:
>>
>> create or replace function page_access_insert_trigger ()
>> returns trigger as $$
>> DECLARE
>>
>
> Ops team want to install postgres as (usr/local/bin) using RPM, and
> want to keep the data directory under (/var/lib/data/pgsql) and they
> say that we cannot have two versions at the same time using RPM.
> They say that red hat standard is to install all binaries of the
> database under /us
On Tue, Apr 28, 2009 at 6:08 PM, John R Pierce wrote:
> I for one use the PGDG yum rpm repository, and install the 8.3 on top of the
> default rhel/centos 4 or 5 binaries. the repository includes a
> compatibility library which satisfies RPM dependencies on the original RHEL
> versions of the li
On Tue, Apr 28, 2009 at 6:00 PM, DM wrote:
> Hi All,
> What is the best way to Install postgres database?
> We have installed (2) versions of the postgres on th server using source
> code (compiling and building) (/usr/local/pgsql/8.3.3/ and
> /usr/local/pgsql/8.3.6/) and our data directory is (/m
DM wrote:
Hi All,
What is the best way to Install postgres database?
We have installed (2) versions of the postgres on th server using
source code (compiling and building) (/usr/local/pgsql/8.3.3/ and
/usr/local/pgsql/8.3.6/) and our data directory is (/mnt/data/pgsql/)
Our database size is m
Hi All,
What is the best way to Install postgres database?
We have installed (2) versions of the postgres on th server using source
code (compiling and building) (/usr/local/pgsql/8.3.3/ and
/usr/local/pgsql/8.3.6/) and our data directory is (/mnt/data/pgsql/)
Our database size is more than 100GB.
Christine Penner writes:
> This is the start of the log file after I tried to restore the database again:
> 2009-04-27 18:19:12 PDT LOG: loaded library
> "$libdir/plugins/plugin_debugger.dll"
> 2009-04-27 18:19:20 PDT LOG: loaded library
> "$libdir/plugins/plugin_debugger.dll"
> 2009-04-27 18:
Carlo Stonebanks wrote:
I think the ORDER BY is free to update the rows in any order it needs
to. The key is to put the sequence further down. How about this?
Adam - thanks. Unless I hear otherwise I will assume that you mean the
UPDATE is free to update the rows in any way it wants - irrega
On 28/04/2009 21:09, Joshua D. Drake wrote:
> On Tue, 2009-04-28 at 12:59 -0700, Christine Penner wrote:
>> After looking closer at the log file I found something interesting:
>
>> This backup included the table creating aswell. How can it not have a
>> column in the table. Am I wrong to assume t
On Tue, 2009-04-28 at 12:59 -0700, Christine Penner wrote:
> After looking closer at the log file I found something interesting:
> This backup included the table creating aswell. How can it not have a
> column in the table. Am I wrong to assume that when I restore over an
> existing database it
After looking closer at the log file I found something interesting:
2009-04-27 17:38:38 PDT ERROR: column "f_township" of relation
"fire_report" does not exist at character 3584. Almost every insert
got an error about a duplicate primary key. That shouldn't happen
because all these records we
On Tue, Apr 28, 2009 at 1:44 PM, Christine Penner
wrote:
> Scott:
>>
>> I'm really starting to wonder about your hardware and / or OS. Are
>> you running any anti-virus software (if so turn it off and / or
>> uninstall it)? Have you tested your machine with something like
>> memtest86+?
>
> All
I think the ORDER BY is free to update the rows in any order it needs
to. The key is to put the sequence further down. How about this?
Adam - thanks. Unless I hear otherwise I will assume that you mean the
UPDATE is free to update the rows in any way it wants - irregardless of how
whether th
I looked at the log files. The log file for one crash I had looks
like it got to loading data in one of the larger tables. Finished
inserting a record and stopped. It did complain about the fact that
the tables already existed but seemed to continue and loaded about 49
tables before it quit.
On Tue, Apr 28, 2009 at 11:56 AM, Christine Penner
wrote:
> The crashes I get are the windows, this program has encountered a problem
> and must close, error. At that point I can't do anything with Postgres. I
> can't restart the service. I have to restart windows.
>
> Usually we are restoring int
Christine Penner wrote:
> The crashes I get are the windows, this program has encountered a
> problem and must close, error. At that point I can't do anything with
> Postgres. I can't restart the service. I have to restart windows.
The PostgreSQL logs should have more info regarding the crash.
On Tue, 28 Apr 2009, Tim Uckun wrote:
Does anybody know if there is a sample database or text files I can
import to do some performance testing? I would like to have tables with
tens of millions of records if possible.
There is a utility that ships with PostgreSQL named pgbench that includes
Carlo Stonebanks wrote:
(FOR PG VERSION 8.3.6 running on Windows 2003 Server x64)
We have a function that assigns unique ID's (to use as row identifiers)
to a table via an UPDATE using nextval(). This table is imported from
another source, and there is a "sequencing" field to let the query kno
The crashes I get are the windows, this program has encountered a
problem and must close, error. At that point I can't do anything with
Postgres. I can't restart the service. I have to restart windows.
Usually we are restoring into an already loaded database but we have
gotten the crashes load
(FOR PG VERSION 8.3.6 running on Windows 2003 Server x64)
We have a function that assigns unique ID's (to use as row identifiers) to a
table via an UPDATE using nextval(). This table is imported from another
source, and there is a "sequencing" field to let the query know in which
order to assi
You may want to zero in on the problem by performing database dumps
(using pg_dump and the various options accordingly) then restore on the
failing installation using the psql command.
Maybe (I am guessing here, you haven't elaborated on "crashes") you may
be issuing insert statements (in the
We are in the process of converting our application to use Postgres.
We have about 5 computers in the office. We frequently create a
database on one computer and then transfer it to the other computers
as needed. We are currently doing this all through pgAdmin.
We backup a data base using the
Hi,
I'm trying to setup Bucardo to do a master-master replication between two
PostgreSQL servers. However, it looks like when it tries to execute a query
involving DISTINCT and a column with a data type of "polygon", the following
error is thrown by PostgreSQL:
ERROR: 42883: could not identi
Daroslav wrote:
>
> Hi
>
> As a newbie in PL/pgSQL I have faced an error SPI_ERROR_TRANSACTION which
> was raised always when I have tried to launch following function with
> uncommented keywords SAVEPOINT, SET TRANSACTION and COMMIT(when commented,
> function works fine):
Yes, you cannot use t
On 28/04/2009 15:52, Emi Lu wrote:
> The problem still did not resolve:( It happened again this morning.
>
> No changes for the script and postgresql configuration. But when I
> re-run the script, it succeeded.
Is there something interrupting network connectivity?
Ray.
My daily data population cronjob(around 1 hour) terminated at the middle and
raised the following error this morning:
Connection rejected: FATAL: Ident authentication failed for user
"schema_owner_name".
Could anyone tell me what might cause the problem please?
This does not seem logical. ide
On Tue, Apr 28, 2009 at 2:21 PM, Jasen Betts wrote:
> On 2009-04-23, durumdara wrote:
>> Hi!
>>
>> In a mod_py application I wanna write a wrapper that handle all PSQL
>> data view with paging/slicing.
>>
>> For example:
>> I have 1.500 records. I wanna show only N (f. ex: 15) records in the
>
Hi
As a newbie in PL/pgSQL I have faced an error SPI_ERROR_TRANSACTION which
was raised always when I have tried to launch following function with
uncommented keywords SAVEPOINT, SET TRANSACTION and COMMIT(when commented,
function works fine):
CREATE OR REPLACE FUNCTION insert_employee(
name_em
In response to Developer :
> How to "listen" only in local socket?
Set in your postgresql.conf:
listen_addresses = ''
(uncomment this line and set the value to '')
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, priv
In response to Developer :
> Hello,
>
> In config:
>
> > # - Connection Settings -
> >
> > #listen_addresses = 'localhost' # what IP address(es) to listen on;
> > # comma-separated list of addresses;
> > # d
On 2009-04-28, Developer wrote:
> Hello,
>
> In config:
>
>> #listen_addresses = 'localhost' # what IP address(es) to listen on;
>> # comma-separated list of addresses;
>> # defaults to 'localhost', '*' = all
In response to Tim Uckun :
> Thanks I'll try something like that.
>
> I guess can create some random dates or something for other types of fields
> too.
Sure, dates for instance:
test=*# select (current_date + random() * 1000 * '1day'::interval)::date from
generate_series(1,10);
date
--
>
> > I would like to have tables with tens of millions of records if possible.
>
> It is easy to create such a table:
>
> test=# create table huge_data_table as select s, md5(s::text) from
> generate_series(1,10) s;
Thanks I'll try something like that.
I guess can create some random dates or so
Hello,
In config:
> # - Connection Settings -
>
> #listen_addresses = 'localhost' # what IP address(es) to listen on;
> # comma-separated list of addresses;
> # defaults to 'localhost', '*' = all
>
On 2009-04-23, durumdara wrote:
> Hi!
>
> In a mod_py application I wanna write a wrapper that handle all PSQL
> data view with paging/slicing.
>
> For example:
> I have 1.500 records. I wanna show only N (f. ex: 15) records in the
> view, other records are accessable with a pager (links):
For
On 2009-04-28, David wrote:
> Ok got permission to send the code I think I have got all the relevent bits.
>
>CREATE TABLE currentcall (
>cadc_taskno integer DEFAULT
> nextval(('currentcall_cadc_taskno_seq'::text)::regclass) NOT NULL,
>coversight character varying(4),
...
>CREATE RUL
In response to Tim Uckun :
> Does anybody know if there is a sample database or text files I can import to
> do some performance testing?
>
> I would like to have tables with tens of millions of records if possible.
It is easy to create such a table:
test=# create table huge_data_table as select
Hello Tim,
you can create this by yourself very easily, e.g. you have a table
CREATE TABLE test1
(
a_int serial NOT NULL,
a_text character varying(200),
dt timestamp without time zone DEFAULT now(),
primary key (a_int)
);
create a bunch of data with something like:
insert into test1
This solved it. Just renamed my tables with lowercase letters. Thanks a
lot.:clap:
BTW Hibernate forum is currently in maintenance mode and I just tried my
luck here. Sorry about that.
Cheers
Mario
dmigowski wrote:
>
> Hello mgazzo,
>
> mgazzo schrieb:
>> I am new to PostgreSQL and I want to
On 2009-04-28, David wrote:
> Our internal task database is doing something odd in that the sequence is
> incrementing by 2 instead of 1 and I can't find any reason why I have checked
> the
> sequence itself to see if it had somehow got set to increment by 2 but no.
> The table in question has
Does anybody know if there is a sample database or text files I can import
to do some performance testing?
I would like to have tables with tens of millions of records if possible.
On 2009-04-22, Bill Todd wrote:
> I am trying to connect to a PostgreSQL server from another machine on my
> small home network. When I click the Test button in the ODBC data mnager
> for my system DSN I get the error "No connection could be made because
> the target machine actively refused it
Hello mgazzo,
mgazzo schrieb:
I am new to PostgreSQL and I want to use it from a Java Application with the
Hibernate ORM. I ran into a problem when I created my first simple Hello
Postegres app where I receive a 'relation "X" does not exist' error. It
turns out that the query Hibernate produces
On 2009-04-24, Johan Nel wrote:
> Hi,
>
> Sorry for cross posting, but seems nobody read the pgsql.sql NG. Have
> not received any response there so lets see if this create some reaction.
>
> Is it possible in pgsql to have something to manipulate columns where
> the column names will only be r
On 28/04/2009 10:56, Jasen Betts wrote:
> would this:
>
> delete from testing where "id"=$1;
>
> be safe?
No - you haven't really changed anything - the double-quotes just
prevent Postgres folding mixed/upper-case identifiers to lower-case.
Why not just change the name of the argument as othe
On 2009-04-24, Tom Lane wrote:
> pavunkumar writes:
>> create or replace function newd(id integer ) returns void as $$
> ^^
>> begin
>> delete from testing where id=$1;
>^^
>> end;
>> $$
>> language 'plpgsql';
>
> Don't use the same nam
On Mon, Apr 27, 2009 at 03:37:22PM -0600, Scott Marlowe wrote:
> On Mon, Apr 27, 2009 at 3:24 PM, Richard Broersma wrote:
> > At this point I don't think that there is a way for this function to
> > know the correct table type of new.* since page_access_... is still
> > only a concatenated string.
Hello ,
My question is related to some functions in PostGIS.
Problem:
We are trying to find x points from a table that are within 20
nautical miles from a given point. Would like to use the ST_Dwithin
function as it would use the GIST index. I could use the
ST_Distance_Spheroid function but tha
On Mon, Apr 27, 2009 at 02:15:05PM -0700, Gauthier, Dave wrote:
> The stored procedure calls another recursive stored procedure that
> can take a long time to run, usually about 3-4 seconds. Not bad for
> a handful of records, but it is now operating on a table with over
> 40,000 records.
The mos
Cool thanks that makes sense was hard to pin down because we didn't notice for
a while.
On Tue, Apr 28, 2009 at 09:31:26AM +0200, Daniel Verite wrote:
> David wrote:
>
> >the sequence is incrementing by 2 instead of 1 and I can't
> >find any reason why I have checked the
> >sequence itsel
David wrote:
the sequence is incrementing by 2 instead of 1 and I can't
find any reason why I have checked the
sequence itself to see if it had somehow got set to increment
by 2 but no.
The table in question has a number of both before and after triggers
that do various bits of busines
Ok got permission to send the code I think I have got all the relevent bits.
On Tue, Apr 28, 2009 at 01:01:39AM -0600, Scott Marlowe wrote:
> On Tue, Apr 28, 2009 at 12:38 AM, David wrote:
> > Looked for that can't find anything and there is no reason why someone
> > would have added that.
>
>
On Tue, Apr 28, 2009 at 12:38 AM, David wrote:
> Looked for that can't find anything and there is no reason why someone would
> have added that.
Well, unless you've got some example code for us to look at, it's
kinda hard to tell you what's wrong.
Often, you see people do something like this:
54 matches
Mail list logo
