Given your data set is small so a dump/restore cycle is painless, you
should also consider upgrading to the latest stable release.
I agree with Raghu that you need to vacuum your database periodically
to keep it's footprint under control, but rather than doing the VACUUM
commands via scheduled
Matt Williams wrote:
> I ran it through xxd and the hex-bytes are different than those of the proper
> utf8 character:
>
> 03300a0: 7472 c383 c2b6 6d65 7209 3009 5c4e 0931 trmer.0.\N.1 (from the
> dump file)
>
> ö : c3b6
>
> ö : c383 c2b6
That looks like your database does not contain w
Sashbeer Bhandari wrote:
> I am using Postgresql DB 8.2 and my encoding is in SQL_ASCII ,. I
> want to convert it in UTF8, Please help me it.
This has nothing to do with the thread on which you posted it.
Please start a new thread with an appropriate subject line.
By the way, PostgreSQL ver
Hey all, I have a question about streaming replication available in PG 9+
The general configuration I see is along the lines of this:
http://brandonkonkle.com/blog/2010/oct/20/postgres-9-streaming-replication-and-django-balanc/
Where you do the file system backup and restore. However, our curren
On Tue, Apr 10, 2012 at 12:34 PM, Wells Oliver wrote:
> Hey all, I have a question about streaming replication available in PG 9+
>
> The general configuration I see is along the lines of this:
>
> http://brandonkonkle.com/blog/2010/oct/20/postgres-9-streaming-replication-and-django-balanc/
>
> Wh
I admit to being scared as crap of rsync'ing a live database to another
server. Like chills are running down my spine even typing it. Is this an
approved, safe thing?
On Tue, Apr 10, 2012 at 11:38 AM, Scott Marlowe wrote:
> On Tue, Apr 10, 2012 at 12:34 PM, Wells Oliver
> wrote:
> > Hey all, I h
Wells Oliver wrote:
> I admit to being scared as crap of rsync'ing a live database to
> another server. Like chills are running down my spine even typing
> it. Is this an approved, safe thing?
It is fine, as long as you're doing it between the pg_start_backup()
and pg_stop_backup() calls. We
I've definitely done this, albeit with a 6-7 GB database. I had
accomplished previous backups with pg_dump commands, that invariably
had to be restarted and took DAYS to complete. The rsync method
achieved the backup within hours the first time, and you can do
subsequent backups in minutes (in ca
"Kevin Grittner" writes:
> Wells Oliver wrote:
>> I admit to being scared as crap of rsync'ing a live database to
>> another server. Like chills are running down my spine even typing
>> it. Is this an approved, safe thing?
> It is fine, as long as you're doing it between the pg_start_backup()
>
Hey everyone. I'd like to create a schema on my slave so that users who do
not have access to the master can create some data. Clearly this data won't
be replicated, since it's on the slave, but will it cause any problems w/
data integrity to have it on the slave?
--
Wells Oliver
wellsoli...@gmai
Wells Oliver wrote:
> I'd like to create a schema on my slave so that users who do not
> have access to the master can create some data. Clearly this data
> won't be replicated, since it's on the slave, but will it cause
> any problems w/ data integrity to have it on the slave?
What are you us
I am using the WAL method w/ 9.1.
On Tue, Apr 10, 2012 at 4:29 PM, Kevin Grittner wrote:
> Wells Oliver wrote:
>
> > I'd like to create a schema on my slave so that users who do not
> > have access to the master can create some data. Clearly this data
> > won't be replicated, since it's on the
[rearranged; please don't top-post]
Wells Oliver wrote:
> Kevin Grittner > Wells Oliver wrote:
>>
>>> I'd like to create a schema on my slave so that users who do not
>>> have access to the master can create some data. Clearly this
>>> data won't be replicated, since it's on the slave, but wil
Sorry for the delay.
On Tue, Apr 3, 2012 at 1:44 AM, masterchief wrote:
> I see. Is there a more elegant way that I could shut down my standby server
> so that it would be in a more clean state? For example, when I first built
> the standby and began replication, I didn't get either of those re
14 matches
Mail list logo
