I have set /usr/lib/postgresql/bin as a explixit path but stil it woun't so, I
have to find out some ting more that I have been doing wrong.
>
> For an explanation of the purpose and behavior of initlocation, look
> here:
>
> http://www.postgresql.org/docs/7.4/static/app-initlocation.html
>
Hi!
I am trying to copy my db from one machine to another .
However since my dump file is pretty big while trying to restore on the
target one
the machine just "hangs up" - we got an empty black console and no ssh
response.
We think that this is caused by postmaster eating too much memory the
la
On Apr 12, 2005, at 2:48 AM, Andrei Bintintan wrote:
I have to do a database replication (of corse pgsql database) and I
never done something like this. I still read about ... what
replication is.
Can anyone send me some directions, documentation, ideeas, solutions?
Here is a nice article on
Hi,
The developers on my company reports me a problem with de upper() function.
The problem is:
- with a text 'magriñá'
- the upper('magriñá') returns MAGRIñà
- NOTE that the characters 'ñ' and 'á' didn't change the case.
- the text are stored in a table in a character varying(50) field
- the datab
On Mon, 2005-04-11 at 00:20, Inpreet Singh wrote:
> Hello,
>
> I am working on live server where we have installed postgres database
> as our back end. But now the problem is due to continues work on
> postgres, size of log files has become problem for us. And the
> partition where our postgres e
A followup, there was a type in my last post, shoulda been:
su - postgres -c 'pg_ctl start | /usr/sbin/rotatelogs $PGDATA/logs/pgsql
86400 2>&1 &'
Note that change in the 2>&1...
---(end of broadcast)---
TIP 9: the planner will ignore your desire
On Mon, 11 Apr 2005, [iso-8859-1] Reuly Bússolo Mendes wrote:
> Hi Stephan, tks
>
> I drop database and move directory data to data01.
> I already executed "initdb --locale=C" and the file postgresql.conf change
> to LC_MESSAGES, LC_MONETARY, LC_NUMERIC and LC_TIME = 'C', but the problem
> persist
Tsirkin Evgeny <[EMAIL PROTECTED]> writes:
> top - 12:07:46 up 1:06, 2 users, load average: 0.99, 0.93, 0.57
> Tasks: 52 total, 3 running, 49 sleeping, 0 stopped, 0 zombie
> Cpu(s): 99.7% us, 0.3% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si
> Mem: 1035532k total, 364012k us
=?ISO-8859-1?Q?=22Lic=2E_Guillermo_Gonz=E1lez=22?= <[EMAIL PROTECTED]> writes:
> The problem is:
> - with a text 'magriñá'
> - the upper('magriñá') returns MAGRIñà
> - NOTE that the characters 'ñ' and 'á' didn't change the case.
This is determined by your locale (specifically LC_CTYPE) not by what
The command's return
teste=# show LC_COLLATE;
ERROR: Option 'lc_collate' is not recognized
I remade the process of yesterday (dropdb and move directory) and added in
initdb the option --lc_collate=C without taking off -- locale=C, executed
but it does not appear in postgresql.conf and the problem
Hello...
Last time I found that about 200 schemas have appeared in my database. These
schemas are pg_temp_. What's this? Can I remove it safely or these
schemas will be removed automatically?
Thx,
Marcin
---(end of broadcast)---
TIP 6: Have
On Tue, 12 Apr 2005, [iso-8859-1] Reuly Bússolo Mendes wrote:
> The command's return
> teste=# show LC_COLLATE;
> ERROR: Option 'lc_collate' is not recognized
Darn, that must have been added after 7.3.x. If you have pg_controldata,
I think you can use pg_controldata . I don't
remember enough ab
On Tue, 12 Apr 2005, Stephan Szabo wrote:
> On Tue, 12 Apr 2005, [iso-8859-1] Reuly Bússolo Mendes wrote:
>
> > The command's return
> > teste=# show LC_COLLATE;
> > ERROR: Option 'lc_collate' is not recognized
>
> Darn, that must have been added after 7.3.x. If you have pg_controldata,
> I thi
Yes, the server is stopped.
I will go to verify on the pg_controldata!
Tks
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Reuly Bússolo Mendes" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, April 12, 2005 11:43 AM
Subject: Re: [ADMIN] Problem in order by
On Tue, 12 Apr
John DeSoi wrote:
On Apr 12, 2005, at 2:48 AM, Andrei Bintintan wrote:
I have to do a database replication (of corse pgsql database) and I
never done something like this. I still read about ... what
replication is.
Can anyone send me some directions, documentation, ideeas, solutions?
Here is
i am having poor performance with postgres 8.0.0
the config of my machine is:
single xeon 3.4 Ghz, 1GB of memory, two IDE drives mounted using LVM and
JFS file system on Suse 9.2 professional.
What I am trying to do is simple...atleast in ORACLE or DB2 that I am
trying to stay away from.
I have
On Sat, 2005-04-09 at 19:29 -0300, [EMAIL PROTECTED] wrote:
> Please,
> how do I identify a id timeline on a transaction log file?
>
> Thanks.
First 8 characters of the filename show the timeline id in hex.
Best Regards, Simon Riggs
---(end of broadcast)---
unsubscribe
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
hello all,
i work in an organization that has a handful of people accessing a few ms
access database files. i'm strongly considering porting everything to
postgre (as the backend for access) for a number of obvious reasons, one of
the most prominent ones would be the availability of a back up v
Hello,
I want to kown if the Postgres can support High Available(HA) in verson 8.
Waiting for you response.
Thanks you very much.
Best Regards,
Yours sincerely , Liu LiJiang
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands
"Alex Zendel" <[EMAIL PROTECTED]> writes:
> ... i've been reading up on the wal and point in time recovery in
> the online postgre manual. but i have a question about using it:
[ obligatory gripe: it's postgres or postgresql, not postgre ]
> is it possible to visually read the entries in the log
Oops! [EMAIL PROTECTED] was seen spray-painting on a wall:
> I want to kown if the Postgres can support High Available(HA) in
> verson 8.
We're running some PostgreSQL 7.4 instances on the IBM HACMP system
for AIX.
That being readily "supportible," I can't readily conceive of a reason
why Postgre
22 matches
Mail list logo
