On Mon, Apr 30, 2012 at 8:34 PM, Liang Ma wrote:
> Hi There,
>
> While trying to restore a ~700GM binary dump by command
>
> pg_restore -d dbdata < sampledbdata-20120327.pgdump
>
> I encountered following errors repeatedly
>
> pg_restore: [archiver (db)] Error from TOC entry 2882463; 2613
> 102673
Tulio wrote:
> Let me expand the collate situation. I´m from Perú and I have turned
> everything in postgresql.conf as 'es_PE.UTF-8' even the
> default_text_search_config = 'pg_catalog.spanish'. Even my Ubuntu 12.04
> works in English I have es_PE locale too.
> if I do
>
> SELECT * FROM pru order
On Fri, Apr 27, 2012 at 4:42 PM, Frank Lanitz wrote:
> Hi folks,
>
> Just looking for a nice server side solution to implement some
> fundamental logic for an application. plpythonu looks in this tmers very
> well as I'm liking the syntax of Python. However, an very old blog post
> at [1] made me
On Fri, May 4, 2012 at 4:09 PM, Stuart Bishop wrote:
> On Fri, Apr 27, 2012 at 4:42 PM, Frank Lanitz wrote:
>> Hi folks,
>>
>> Just looking for a nice server side solution to implement some
>> fundamental logic for an application. plpythonu looks in this tmers very
>> well as I'm liking the synta
Hi Raghavendra,
Is it sure that we can copy only the data of Postgresql from one disk to other
seamlessly and then I can reuse the content without any hassle? If so,
tablespace is what I should create first?
Please clarify me on this.
Thanks & Regards,
Siva.
From: Raghavendra [mailto:raghavend
On Fri, May 4, 2012 at 3:31 PM, Siva Palanisamy wrote:
> Hi Raghavendra,
>
> ** **
>
> Is it sure that we can copy only the data of Postgresql from one disk to
> other seamlessly and then I can reuse the content without any hassle? If
> so, tablespace is what I should create first?
>
> P
Hi everybody,
I want to thank Basile for his function but I've problems with it.
1- When I tried to apply it in postgres SQL 8.4 on a DB in LATIN1 I've this
message :
ERROR: character 0xe280a2 of encoding "UTF8" has no equivalent in "LATIN1"
2- I tried this function on a DB in UTF8 and I've th
Hello
this can help
http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Iteration_over_RECORD_variable_inside_trigger
Regards
Pavel Stehule
2012/5/4 Geo-x :
> Hi everybody,
>
> I want to thank Basile for his function but I've problems with it.
>
> 1- When I tried to apply it in postgres SQL 8.4 on a
On Fri, May 4, 2012 at 8:04 AM, Pavel Stehule wrote:
> Hello
>
> this can help
> http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Iteration_over_RECORD_variable_inside_trigger
hstore has replaced information schema method for me when doing these
type of things:
see: http://archives.postgresql.org/
Hi list,
we have two 9.1.2 servers on debian squeeze, and are setting up a simple
streaming replication between the two.
* wal_keep_segments is set high on the master
* the slave's recovery.conf contains just standbay_mode=on and
primary_conninfo=foo
* we use a simple start_backup/rsync/stop_b
On Fri, May 4, 2012 at 8:55 AM, Vincent de Phily
wrote:
> Hi list,
>
> we have two 9.1.2 servers on debian squeeze, and are setting up a simple
> streaming replication between the two.
>
> * wal_keep_segments is set high on the master
> * the slave's recovery.conf contains just standbay_mode=on an
On Friday 04 May 2012 09:47:16 Merlin Moncure wrote:
> On Fri, May 4, 2012 at 8:55 AM, Vincent de Phily
>
> wrote:
> > Hi list,
> >
> > we have two 9.1.2 servers on debian squeeze, and are setting up a simple
> > streaming replication between the two.
> >
> > * wal_keep_segments is set high on
This is due to how sequences are pre-allocated in blocks to sessions
running on the master.
Since the slave is updated via the WALs, and not via 'nextval' function
calls in queries, the sequences that are actually used will remain in sync
with the master.
--
Mike Nolan
Hi
Apologies in advance if this is the wrong place to ask.
I have Postres 8.4 and I am setting up replication with Slony.
I'm having password issues with slony.
I have roamed the net for a solution and the way to fix it is to use the
.pgpass file or change pg_hba.conf to accept trusted connection
Rebecca Clarke writes:
> I'm having password issues with slony.
> I have roamed the net for a solution and the way to fix it is to use the
> .pgpass file or change pg_hba.conf to accept trusted connections.
> I do not want to touch the pg_hba.conf so I have generated the .pgpass file.
Reasonable.
On Fri, May 4, 2012 at 1:22 AM, Albe Laurenz wrote:
> But would you really order 'leon', 'mendoza', 'juan' before
> 'leo', 'zara', 'juan'?
No, I guess that Tulio would not do that, because (usually) 'leo' goes
before 'leon'.
What Tulio is saying is that 'leon' and 'león' are the same thing from
I tried test the ODBC driver. I failed and I was told I should install the
odbc driver manager to configure the ODBC driver first, then I can test the
ODBC drive. And the following ODBC driver were installed on my server :
psqlodbc-08.02.0400 psqlodbc-08.03.0400 psqlodbc-09.00.0200
psqlodbc-0
Al Eridani writes:
> What Tulio is saying is that 'leon' and 'león' are the same thing from
> the point of view of sorting in Spanish, but his PostgreSQL seems to
> think that 'leon' goes before 'león'.
Postgres never considers that two distinct strings are "equal". If the
locale setting conside
On May 4, 2012, at 9:30 AM, Rebecca Clarke wrote:
> I do not want to touch the pg_hba.conf so I have generated the .pgpass file.
> The permissions is set to 600, and I have correctly inputted the details into
> .pgpass, there are no leading spaces.
>
> myhostname:myport:*:postgres:mypassword
>
On 05/04/2012 10:23 AM, leaf_yxj wrote:
I tried test the ODBC driver. I failed and I was told I should install the
odbc driver manager to configure the ODBC driver first, then I can test the
ODBC drive. And the following ODBC driver were installed on my server :
psqlodbc-08.02.0400 psqlodbc-08.0
Hi all,
I'm a bit confused about when exactly I can rely on the resultset order
when using set returning functions. The documentation states:
'After a query has produced an output table (after the select list has been
processed) it can optionally be sorted. If sorting is not chosen, the rows
will
On 05/03/12 10:18 PM, David Johnston wrote:
On May 3, 2012, at 20:20, EllyR wrote:
> Yes you are right, I have read that it is not that reliable, but I have to do
> something for that, what would be your suggestion for this case? Thanks.
Simplest option: install a new local hard drive and c
On 05/04/2012 07:31 PM, Tom Lane wrote:
Al Eridani writes:
What Tulio is saying is that 'leon' and 'león' are the same thing from
the point of view of sorting in Spanish, but his PostgreSQL seems to
think that 'leon' goes before 'león'.
Postgres never considers that two distinct strings are "e
2012/5/4 Ingmar Brouns :
>
> Hi all,
>
> I'm a bit confused about when exactly I can rely on the resultset order when
> using set returning functions. The documentation states:
>
> 'After a query has produced an output table (after the select list has been
> processed) it can optionally be sorted.
24 matches
Mail list logo
