Srs. realizei uma instalação de um de nossos servers e me deparei com a
seguinte mensagem
[user@local ~]$ psql
psql: invalid connection option "client_encoding"
Depois de procurar sobre o assunto, setei uma variavel chamada
PGCLIENTENCODING = UTF8 e isso resolveu meu problema, no entanto, ao
inst
On Thursday, February 23, 2012 4:00:08 pm Dmytrii Nagirniak wrote:
> On 24/02/2012, at 2:06 AM, Adrian Klaver wrote:
> >> Would appreciate some suggestions.
> >
> > Not enough information to make suggestions.
>
> Jack Christensen pretty nailed it very well. But I'll answer the particulars
here t
On Thu, Feb 23, 2012 at 5:22 PM, Dmytrii Nagirniak wrote:
> On 24/02/2012, at 5:15 AM, Simon Riggs wrote:
>
> Now all you have to do is parallelise the tests and everything can
> work 10 times quicker and it would be much faster than the time SQLite
> produced.
>
> So using PostgreSQL for testing
On Thursday, February 23, 2012 1:53:42 pm Willem Buitendyk wrote:
> Both via psql and PgAdmin.
>
> Yes only one database cluster.
>
Another thought.
Did you CREATE the schema using PgAdmin and if so, might you have
inadvertently
put in a trailing or leading space ?
I ask because if I remember
On 02/23/2012 07:16 PM, Dmytrii Nagirniak wrote:
That's totally fine if PG can't beat SQLite on speed in **this
particular case**.
I just want to try to tune it to be as fast as it can (for **this
particular case**, see my reply to Adrian).
You can find all of the big tunable parameters at
htt
On 24/02/2012, at 5:15 AM, Simon Riggs wrote:
> Now all you have to do is parallelise the tests and everything can
> work 10 times quicker and it would be much faster than the time SQLite
> produced.
>
> So using PostgreSQL for testing would be both quicker and more
> accurate, if you set the tes
On 24/02/2012, at 2:22 AM, Simon Riggs wrote:
>> Would appreciate some suggestions.
>
> You really need to explain why this matters...
I've just replied to Adrian with more details. I suppose you don't mind to take
a look there so I won't copy-paste it :)
> You mention a "typical Ruby on Rail
On 24/02/2012, at 2:06 AM, Adrian Klaver wrote:
>>
>> Would appreciate some suggestions.
>
> Not enough information to make suggestions.
Jack Christensen pretty nailed it very well. But I'll answer the particulars
here too:
> Why are you switching databases?
Need FTS from PG. No other reason
On 23/02/2012, at 7:35 PM, Marti Raudsepp wrote:
> If you have lots of very simple queries, then usually much of the
> overhead is in query planning. There are a few tricks to dumb down the
> planner to make it faster -- although that may come at the cost of
> slowing down execution.
>
> * If you
On Thu, Feb 23, 2012 at 11:15 AM, Simon Riggs wrote:
> On Thu, Feb 23, 2012 at 5:20 PM, Scott Marlowe
> wrote:
>
>> He's probably doing automated continuous integration testing. Two
>> jobs ago we had a setup to do that and had 40k tests. The whole test
>> suite took about 30 minutes to runm a
On Thu, Feb 23, 2012 at 3:09 PM, Jayashankar K B
wrote:
> Hi Tom,
>
> Sorry about the cross-post.
> I am not aware of the procedures for patch etc.
> Could you please tell me how to use the patch ?
see general instructions here:
http://jungels.net/articles/diff-patch-ten-minutes.html
merlin
--
On 02/23/2012 01:53 PM, Willem Buitendyk wrote:
Both via psql and PgAdmin.
Yes only one database cluster.
1)
Did you try Johns recommendation, just to be sure?:
"
add the database name to your log_line_prefix ... I use something like...
log_line_prefix = '%m %u@%d[%p]: '
"
2)
So what ha
Both via psql and PgAdmin.
Yes only one database cluster.
On 2012-02-23, at 1:32 PM, Adrian Klaver wrote:
> On 02/23/2012 01:08 PM, Willem Buitendyk wrote:
>> I have it set in postgresql.conf and I've also used:
>>
>> alter user postgres set search_path = crabdata,public;
>>
>> looking at t
On 02/23/2012 01:08 PM, Willem Buitendyk wrote:
I have it set in postgresql.conf and I've also used:
alter user postgres set search_path = crabdata,public;
looking at the logs after issuing the above alter user command I get:
2012-02-23 13:03:09 PST WARNING invalid value for parameter "search_
On 02/23/2012 01:15 PM, Igor Polishchuk wrote:
Actually, what works is
set search_path='crabdata', 'public' ;
Yea, I was not clear here. I was referring to postgresql.conf setting.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
Actually, what works is
set search_path='crabdata', 'public' ;
On 2/23/12 1:10 PM, "Adrian Klaver" wrote:
> On 02/23/2012 01:08 PM, Willem Buitendyk wrote:
>> I have it set in postgresql.conf and I've also used:
>> alter user postgres set search_path = crabdata,public;
>>
>
> Well search_pat
On 02/23/2012 01:08 PM, Willem Buitendyk wrote:
I have it set in postgresql.conf and I've also used:
alter user postgres set search_path = crabdata,public;
Well search_path is a string, so have you tried?;
search_path='crabdata,public'
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via p
Hi Tom,
Sorry about the cross-post.
I am not aware of the procedures for patch etc.
Could you please tell me how to use the patch ?
I have already compiled and got the postgres server.
So please let me know the process of patching or kindly point me to a link
which explain this.
Thanks and Regar
On 02/23/12 11:49 AM, Willem Buitendyk wrote:
2012-02-23 11:31:44 PST WARNING invalid value for parameter "search_path":
"crabdata"
2012-02-23 11:31:44 PST DETAIL schema "crabdata" does not exist
Bizarre because I did set my search path to the schema crabdata but now it is
saying
I have it set in postgresql.conf and I've also used:
alter user postgres set search_path = crabdata,public;
looking at the logs after issuing the above alter user command I get:
2012-02-23 13:03:09 PST WARNING invalid value for parameter "search_path":
"crabdata, public"
2012-02-23 13:03:09
On 02/23/2012 11:49 AM, Willem Buitendyk wrote:
Here are the log returns:
2012-02-23 11:31:44 PST WARNING invalid value for parameter "search_path":
"crabdata"
2012-02-23 11:31:44 PST DETAIL schema "crabdata" does not exist
Bizarre because I did set my search path to the schema c
crabby=# \dv
List of relations
Schema | Name| Type | Owner
--+---+--+--
crabdata | Total XXX X by XXX | view | postgres
also;
crabby=# show sear
Jayashankar K B writes:
> Hi All,
> I am trying to compile Postgres Source code for ARM cortex A8 architecture.
> While compiling, I got an error message which read "selected processor does
> not support `swpb r4,r4,[r3]' "
> One of the Postgres forums at the location
> "http://postgresql.104569
On 02/23/2012 12:49 PM, Willem Buitendyk wrote:
Here are the log returns:
2012-02-23 11:31:44 PST WARNING invalid value for parameter "search_path":
"crabdata"
2012-02-23 11:31:44 PST DETAIL schema "crabdata" does not exist
Bizarre because I did set my search path to the schema c
Hi All,
I am trying to compile Postgres Source code for ARM cortex A8 architecture.
While compiling, I got an error message which read "selected processor does not
support `swpb r4,r4,[r3]' "
One of the Postgres forums at the location
"http://postgresql.1045698.n5.nabble.com/BUG-6331-Cross-compi
Here are the log returns:
2012-02-23 11:31:44 PST WARNING invalid value for parameter "search_path":
"crabdata"
2012-02-23 11:31:44 PST DETAIL schema "crabdata" does not exist
Bizarre because I did set my search path to the schema crabdata but now it is
saying that crabdata doesn't
On Thursday, February 23, 2012 11:18:46 am Willem Buitendyk wrote:
> I have recently upgraded my database from 8.4 to 9.1. In the process I
> have moved everything to a different schema. Postgis is occupying the
> public schema. Everything is working fine except for some of my own
> functions. H
I have recently upgraded my database from 8.4 to 9.1. In the process I have
moved everything to a different schema. Postgis is occupying the public
schema. Everything is working fine except for some of my own functions. Here
is a small function and table that will not update when I perform th
On Thu, Feb 23, 2012 at 5:20 PM, Scott Marlowe wrote:
> He's probably doing automated continuous integration testing. Two
> jobs ago we had a setup to do that and had 40k tests. The whole test
> suite took about 30 minutes to runm and kicked off automatically when
> the last one finished and an
That worked. Thank you Adrian
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, February 23, 2012 9:58 AM
To: pgsql-general@postgresql.org
Cc: Carlos Oliva
Subject: Re: [GENERAL] Dynamic File Name for COPY TO in Stored Procedure
On Thursday, Februa
On Thu, Feb 23, 2012 at 10:05 AM, David Salisbury wrote:
>
>
> On 2/23/12 9:06 AM, Jack Christensen wrote:
>>
>> As another Rails developer using PostgreSQL I think I can explain the
>> use case. In standard Rails usage, the ORM handles all SQL query
>> generation and thus the application is datab
On 2/23/12 9:06 AM, Jack Christensen wrote:
As another Rails developer using PostgreSQL I think I can explain the
use case. In standard Rails usage, the ORM handles all SQL query
generation and thus the application is database agnostic. It is typical
to use SQLite in development and testing and
On 02/23/12 3:22 AM, ultrayoYO wrote:
OS : Linux Centos 5.1
you haven't installed any security or stability updates since 2007 ?
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-genera
Hi,
What would it be the correct format for using a variable in a stored
procedure that uses COPY TO?
I have the current stored procedure:
CREATE FUNCTION Table_To_File(text) RETURNS void AS $delimeter$
COPY (SELECT * FROM table_to_xml('table', true, false, '')) TO '$1'
WITH CSV QUOTE ' ';
$de
On 2/23/2012 9:22 AM, Simon Riggs wrote:
On Thu, Feb 23, 2012 at 5:13 AM, Dmytrii Nagirniak wrote:
I wonder if you can suggest me how to speed-up PG when running specs.
I asked it at SO here:
http://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing
But briefly. PG spec
> > > > the problem arises when u have a field value that contains a newline
> > > > character, when this field is not the first column, then all the data
> > > > after this newline comes in the first column..
> > > >
> > > > u can try this out, writing a function or table,
> > > > and then add 'e
ultrayoYO wrote:
> I need to enable option --enable-thread-safety after install
completed.
> Do you have any way for this case. Because I try to remove and
reinstall by
> enable thread safety.
> But not update feature --enable-thread-safety Postgresql config still
value
> config in the first insta
On Thu, Feb 23, 2012 at 5:13 AM, Dmytrii Nagirniak wrote:
> I wonder if you can suggest me how to speed-up PG when running specs.
> I asked it at SO here:
>
> http://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing
>
> But briefly. PG specs are >2x slower than SQLite.
> I
On Wednesday, February 22, 2012 9:13:06 pm Dmytrii Nagirniak wrote:
> Hi guys,
>
> I wonder if you can suggest me how to speed-up PG when running specs.
> I asked it at SO here:
>
> http://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-tes
> ting
>
> But briefly. PG specs are >
On Thursday, February 23, 2012 6:42:53 am Carlos Oliva wrote:
> Hi,
> What would it be the correct format for using a variable in a stored
> procedure that uses COPY TO?
>
> I have the current stored procedure:
> CREATE FUNCTION Table_To_File(text) RETURNS void AS $delimeter$
>COPY (SELECT * F
Hi,
What would it be the correct format for using a variable in a stored
procedure that uses COPY TO?
I have the current stored procedure:
CREATE FUNCTION Table_To_File(text) RETURNS void AS $delimeter$
COPY (SELECT * FROM table_to_xml('table', true, false, '')) TO '$1'
WITH CSV QUOTE ' ';
$de
On Thu, Feb 23, 2012 at 2:00 AM, Twaha Daudi wrote:
> Hello all,
> Good day,
> I would like to make Postgresql 8.4 as main database for running
> three(software) and possible exchanging data.Is it possible? if yes what is
> the implication in terms of performance?
>
Yes.
As far as implication
Twaha Daudi wrote:
> I would like to make Postgresql 8.4 as main database for running
three(software) and possible
> exchanging data.Is it possible? if yes what is the implication in
terms of performance?
Please give us more information:
- What is three(software)?
- Can you specify how and with w
OS : Linux Centos 5.1
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-enable-thread-safety-on-postgresql-8-3-6-tp5507687p5507721.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@pos
Hi
I need to enable option --enable-thread-safety after install completed.
Do you have any way for this case. Because I try to remove and reinstall by
enable thread safety.
But not update feature --enable-thread-safety Postgresql config still value
config in the first install.
Any way sugest to m
Hello all,
Good day,
I would like to make Postgresql 8.4 as main database for running
three(software) and possible exchanging data.Is it possible? if yes
what is the implication in terms of performance?
It's certainly possible. Obviously it will need a bigger machine than
you would use for
Need to enable log_line_prefix with timestamp "%t".
http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Thu, Feb 23, 2012 at 2:15 PM, Madhu S R wrote:
> Hi,
>
> I need to log DDL or M
Timothy Garnett wrote:
> We recently upgraded to 9.1.2 from 9.0.3 and ran into some issues with
the process we've been using to
> dump and restore databases. We typically use a super user (but not
the postgres user) to dump and
> restore databases, but in moving the 9.1.2 we've run into trouble wi
Hi,
I need to log DDL or MOD statements with current time when the statement
executed. Please let me know if this is possible.
Regards,
Madhu
Hello all,
Good day,
I would like to make Postgresql 8.4 as main database for running
three(software) and possible exchanging data.Is it possible? if yes what is
the implication in terms of performance?
regards
huu
On Thu, Feb 23, 2012 at 08:02, Dmytrii Nagirniak wrote:
> Thanks. So far I tried:
>
> fsync = off
> full_page_writes = off
>
> It seems it got a *little* faster (down to ~65 seconds from ~76) but is till
> too far from my target of ~34 secs.
If you have lots of very simple queries, then usually m
51 matches
Mail list logo
