hi, i tried the exact setup that you described here, but unfortunately i had to
restart the new master(former slave) in order to get the new settings and this
will conduct to a downtime and service interruption.
anyway thanks for sharing your experience.
Adrian Videanu
--- On Fri, 4/20/12, jen
Usually the standard location for data is /var/lib/pgsql/data for
postgresql 8.
So try to restore this directory first and underneath.
Only with that you can hopefully restore the whole system assuming that
if tablespaces were creates are under the standard location.
I would ask others to mak
On tor, 2012-04-19 at 10:02 +0200, Albe Laurenz wrote:
> After looking at the UNICODE character list I tend to agree that
> code point 0xB5 (MICRO SIGN) should not be converted to
> 0x39C (GREEK CAPITAL LETTER MU). There's 0x3BC for GREEK SMALL LETTER MU.
http://www.unicode.org/Public/UNIDATA/Uni
On Thu, Apr 19, 2012 at 5:47 PM, Nagaraj Shindagi <
nagaraj.shind...@gmail.com> wrote:
> Hi team,
>
> i am nagaraj, i am newbi in this database world. i required your help.
> 2 dyas back i formatted one of my client system. which is having
> postgresql 8.2 database & that was having data. but i am
Hi team,
i am nagaraj, i am newbi in this database world. i required your help.
2 dyas back i formatted one of my client system. which is having postgresql
8.2 database & that was having data. but i am not taken backup of the data.
1) how to take the data from the formatted harddisk. ?
2) how many
Need more info.
How is Postgres setup, what version.
How are you migrating?
How is Oracle setup, what version.
Etc.
2012/4/16 ЇЯЅHAÐ
> Hi,
>
> We are trying to migrate from Postgres to Oracle, although our DB is
> gigantic
> but we started on Mar 14th 2012 & its still running with an average of
On Mon, 2012-04-16 at 16:27 -0700, ЇЯЅHAÐ wrote:
>
>
> We are trying to migrate from Postgres to Oracle,
Hmm.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, de
Hi,
We are trying to migrate from Postgres to Oracle, although our DB is
gigantic
but we started on Mar 14th 2012 & its still running with an average of
40 records per day
How can we check what is going wrong.
Any memory leak, CPU issue or anything.
Please help me fix it
hi
we did a new shell script named recovery_config_chage.sh at standby server.
the script I wanted to change the fail down postgres master config ,let it
start as standby server
and build the communication with the former standby now is master server,then
started it by remotestart.sh
the abo
Hello,
I am using Postgres version 8.3.17 on one of my database server. I have
received a .sql dump file from my client. Which is supposed to be taken
from a Postgres 8.3.7 db. Now, I have created an empty database and I am
trying to restore the .sql file with command psql command. After few
so, just to make sure that i understand:
after the master failed, the slave become the new master, the you have changed
postgresql.conf from master to slave and viceversa and restarted the old master
as slave ?
--- On Thu, 4/19/12, jenopob [via PostgreSQL]
wrote:
From: jenopob [via PostgreSQ
Rural Hunter wrote:
>> Do you get the error if you try Chinese settings without nlpbamboo?
> How can I do this? The Chinese processing is provided by nlpbamboo.
Er, sorry, forget what I said. I have no experience with Chinese.
I guess you should try to ask the nlpbamboo people.
Is there anythin
Scott Whitney wrote:
> I'll be moving to PG9 (hopefully soon...probably 6 weeks).
>
> At that time, I'll be setting up hot-standby with streaming replication to 2
> sites. Off-siting my
> pgdumps nightly is no longer going to be possible in the very near future,
> due to the size of the
> dumps.
service prodat wrote:
> first: i hope im right here in this mailing list.
Yes.
> My problem:
>
> We have several Postgre servers 9.0.4, one on Windows Server 2008 R2 and
> others on different UNIX/Linux systems.
> Windows: LC_CTYPE = 'German, Germany'
> UNIX: LC_CTYPE='de_DE.UTF-8'
> (so LC_COLL
14 matches
Mail list logo