I am running Ubuntu 11.04, I have Postgres 8.4 and 9.1 installed.
My default when I say psql it connects to postgres 8.4
ie I set export PGCLUSTER=9.1/main
it connects to 9.1
Q. How can I connect to 9.1 by default without having to set PGCLUSTER?
I looked in /etc/postgresql-common, there di
Hi Chris
Thanks for the suggestion, I tried a making the changes are you suggest,
I still getting an error from Postgres ie
define("PG_OPTIONS" , "--cluster=9.1/main");
define("PG_DB" , "tripe");
define("PG_HOST", "localhost");
define("PG_USER", "dp42");
define("PG_PORT", "5432");
define(
My reply is at:
http://ledgersmbdev.blogspot.com/2012/02/robert-young-is-wrong-about-threads-and.html
On Mon, Feb 6, 2012 at 9:05 PM, John R Pierce wrote:
> On 02/03/12 5:53 PM, Rodrigo E. De León Plicet wrote:
>
>> Author's followup:
>>
>> http://drcoddwasright.**blogspot.com/2012/02/damn-you-*
OK .. my offending line number is 4533
How can i remove it while copying ?
*COPY Table
FROM 'insert .csv dir here'
USING DELIMITERS ';' CSV HEADER*
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5462255.html
Sent from the Pos
On 02/03/12 5:53 PM, Rodrigo E. De León Plicet wrote:
Author's followup:
http://drcoddwasright.blogspot.com/2012/02/damn-you-damocles.html
his links hardly seem related to his proclamations.
--
john r pierceN 37, W 122
santa cruz ca mid-le
On Jan 26, 4:52 pm, Rodrigo E. De León Plicet
wrote:
> Quote:
>
> ==
>
> This thread
>
> http://postgresql.1045698.n5.nabble.com/Multithread-Query-Planner-td5...
>
> was mentioned in a performance sub-group posting. Give it a read
I have encountered the symmetric error to this -> PGRES_COPY_OUT.
We are using a foreign data wrapper into a large (and unnamed) database
system which generates a substantial pipeline of rows for copyout to bring
back through libPQ to respond to the psql request.
If the back end is blown away the
On 07/02/12 10:03, Dave Potts wrote:
I have two versions of postgres installed, 8.4 and 9.1 installed on the
same machine
To connect to my 9.1 database, I defined the envromental variable
PGCLUSTER=9.1/main
and use psql to connect via php pg_connect
I have try saying
define("PG_OPTIONS" , "
I have two versions of postgres installed, 8.4 and 9.1 installed on the
same machine
To connect to my 9.1 database, I defined the envromental variable
PGCLUSTER=9.1/main
and use psql to connect via php pg_connect
I have try saying
define("PG_OPTIONS" , "--cluster=9.1/main");
and using the ph
Hi!
While running pg_upgrade, on one instance, it ran out of memory during the
final stages of upgrade
(just before it starts to "link" old database files to new ones).
We are using Postgres 9.1.1, and I see that there were some fixes to
pg_upgrade in 9.1.2, though
it doesn't mention anything ab
I don't want to admit how many times I have revisited this but I have
some preliminary tests working.
My test server is XP and I just reconfirmed that there are no issues
getting the scheduled task to run on that box pretty easily.
On the windows server 2008 the following looks like it will
Ralph Dell, GISP
GIS Dept.
Catawba County, NC
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Richard Sickler
Sent: Monday, February 06, 2012 12:04 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] windows 2008 scheduled task pr
Hello,
as you don't seems to need the returned column definition in Postgres, a
solution may be to cast the result to text.
e.g.:
create or replace function get_record ()
returns setof text as
$$
select (foo)::text from
(values(1,'a a'),(3,'b b'))foo
$$
language sql;
Hi folks,
I'm using PG 8.4.10 on Ubuntu Server 10.04.3.LTS x86_64.
Is there any way to query the SSL mode for client connections?
E.g. select backend_id from some_table_or_view where ssl_mode = false;
I have not been able to find it in pg_stat_activity or anywhere else in
the catalog. Maybe I
Hi,
Well, I think you will need to write your own function(s) which will solve
your particular case...
There are two ways explaind in last mails... Dynamic SQL or direct export
to file...
Kind Regards,
Misa
2012/2/6 Andrus
> Thank you.
>
>
> the point is - it is not possible to get unknown
Thank you.
the point is - it is not possible to get unknown no of columns in 1 SQL
query...
i.e.
Account, Store, Amount
100, St1, 1000.00
100, St2, 2000.00
to get:
Acount,St1 , St2
100, 1000.00 2000.00
to get that in your query... St1 and St2 - must be hardcoded... (is the
Hi,
I think you dont understand me (or I do not understand you :) )
the point is - it is not possible to get unknown no of columns in 1 SQL
query...
i.e.
Account, Store, Amount
100, St1, 1000.00
100, St2, 2000.00
to get:
Acount,St1 , St2
100, 1000.00 2000.00
to get that
Fanbin Meng wrote:
> I installed the PostgreSql9.0 in windows 7 with "one click installer".
> How can i backup another PostgreSql server database remotely via an internet
> connection .
> I trid "add a connection to a server", but it did not work.
Don't know waht you mean with 'add a connection
Ralph,
It may help to break this into a couple of parts
Make a folder called c:\cronjobs
in c:\cronjobs create a bat file that contains the commands you want
executed.
Maybe something like
set logfile=shp2pgsql.log
echo Running shp2pgsql > %logfile%
date /t >> %logfile%
time /t >> %logfile%
shp2
Pat Heuvel writes:
> On 6/02/2012 4:39 AM, Tom Lane wrote:
>> What exactly happens when you try to reindex pg_largeobject?
> ERROR: could not create unique index "pg_largeobject_loid_pn_index"
> DETAIL: Table contains duplicated values.
Could be worse. What you'll need to do is look through t
See my reply below:
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ralph Dell
Sent: Monday, February 06, 2012 8:26 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] windows 2008 scheduled task problem
I am running postgresql 8.4.3/ postgis
Thank you.
first calculate how much columns we should return...No of stores in in your
Sales table (multiply 3 in your case)...
(and based on that - build the grid in UI)
then with knowing that - we select full "table" with simple 3 functions:
CalcSales(coount, Store), getBudget(account, Store)
I am running postgresql 8.4.3/ postgis 1.5 on a windows server 2008 R2
I am unable to get the shp2pgsql command to run as scheduled tasks.
There is no problem running any of the commands from the command line or
a python script.
Some sample commands are
shp2pgsql -s 900913 -I -d myshape.s
Hm...
I am not sure it is possible at all and with just 1 column for crosstab
(instead of 3) to return table with undefined No of columns (to number of
stores do not be hardcoded)...
At least you must define your return type...
Problem is known to me, and we have solved it on some way... which i
I'm looking for a way to generate cross tab with 3 columns for every store
where
number of stores in not hard coded.
Every store info should contain 3 columns:
turnover
budget
budget percent (=turnover/budget*100)
Result should look like:
Acc st1turnover st1budget st1percent ... stNturn
On Fri, Feb 3, 2012 at 2:55 PM, Christopher Opena wrote:
> Merlin, thanks for the response.
no problem. if you're open to architecture suggestions you might also
want to consider going with HS/SR and getting those large olap queries
off your main database. you'll have to configure it to be very
I installed the PostgreSql9.0 in windows 7 with "one click installer".
How can i backup another PostgreSql server database remotely via an
internet connection .
I trid "add a connection to a server", but it did not work.
Does anyone can help me or give suggestions?
Thanks
Fanbin
On 6 February 2012 13:26, Lockas wrote:
> *
> ok then if I want to except that row from copying. how i can write it ?*
You can either remove the offending line(s) from the csv file or copy
to a staging table that doesn't have those limitations on field
lengths first.
--
If you can't see the for
On Feb 6, 2012, at 7:26, Lockas wrote:
> *
> ok then if I want to except that row from copying. how i can write it ?*
>
>
Copy is all or nothing. Either fix the problem row(s) or remove them from the
file manually.
David J.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
*
ok then if I want to except that row from copying. how i can write it ?*
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5459976.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-gene
On 6/02/2012 4:39 AM, Tom Lane wrote:
Pat Heuvel writes:
[ vacuumlo fails ]
When I added the -v option, there were many "removing lo x" messages
before the above messages appeared. I have previously tried to reindex
pg_largeobject, but that process failed as well.
You need to get the index
On Mon, Feb 06, 2012 at 11:29:23AM +, Jasen Betts wrote:
> On 2012-02-04, hubert depesz lubaczewski wrote:
> > select 'depesz depeszx depesz' ~ E'^(.*)( \\1)+$';
> >
> > what's worse:
> > $ select regexp_replace( 'depesz depeszx depesz', E'^(.*)( \\1)+$', E'\\1'
> > );
> > regexp_replace
>
On 2012-01-25, Adrian Klaver wrote:
> On Wednesday, January 25, 2012 7:48:34 am hubert depesz lubaczewski wrote:
>> On Wed, Jan 25, 2012 at 07:44:14AM -0800, Adrian Klaver wrote:
>> > > I thought that this is what I will achieve with extract(epoch from
>> > > now() at time zone 'UTC') but clearly
On 2012-02-04, hubert depesz lubaczewski wrote:
> select 'depesz depeszx depesz' ~ E'^(.*)( \\1)+$';
>
> what's worse:
> $ select regexp_replace( 'depesz depeszx depesz', E'^(.*)( \\1)+$', E'\\1' );
> regexp_replace
>
> depesz
> (1 row)
>
> I know that Pg regexps are limited, b
On 2012-01-25, hubert depesz lubaczewski wrote:
> On Wed, Jan 25, 2012 at 02:07:40PM -0800, Adrian Klaver wrote:
>> Finally dawned on me. When you use 'at time zone' on a timestamp
>> with tz it strips the tz which then allows the value to be indexed
>> because:
>>
>> -[ RECORD 5
>> ]---+---
On 6 February 2012 07:37, Lockas wrote:
> I've tried a lot of sizes
> but I still have messages in my log saying:
>
> * ---
> ERROR: value too long for type character varying(200)
> --- *
>
> Why is this? There are no other varchar(200) columns in my DB at all,
> no other table. Only this colu
+1
I could undertsand the need to point to current version... but my goal was
just to give someone a hint for his problem... I have answered from bed,
from my mobile phone... so it was shortcut - few taps copy/paste, and
google pointed me to the link...
In case I needed to worry about "is it for
On Mon, Feb 6, 2012 at 8:42 PM, Thomas Kellerer wrote:
> Misa Simic, 06.02.2012 10:35:
>
>> Hi Bob,
>>
>> I guess with "overwrite the table" you mean to fill some columns with your
>> values in trigger...
>>
>> If that is the case, in docs is example:
>>
>> http://www.postgresql.org/docs/8.1/stati
Misa Simic, 06.02.2012 10:35:
Hi Bob,
I guess with "overwrite the table" you mean to fill some columns with your
values in trigger...
If that is the case, in docs is example:
http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html
Kind Regards,
Please do not link to outdated docume
Hi Bob,
I guess with "overwrite the table" you mean to fill some columns with your
values in trigger...
If that is the case, in docs is example:
http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html
Kind Regards,
Misa
Sent from my Windows Phone
--
From: Bo
40 matches
Mail list logo
