On Tue, Apr 10, 2012 at 11:21 AM, Kiruba suthan kirubasut...@gmail.comwrote:
We are using Postgresql Database server to host DB for an analytical tool
I am working on. Basically this DB has metrics about files. Row count of
few tables are more than 18 million. But the content of the tables
On Tue, Apr 10, 2012 at 10:00 AM, Sashbeer Bhandari sashb...@gmail.comwrote:
Hi
Good Morning,
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.
Convert a database in the SQL_ASCII format into one of the UTF-8 format::
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
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 what you
Sashbeer Bhandari sashb...@gmail.com 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
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
On Tue, Apr 10, 2012 at 12:34 PM, Wells Oliver wellsoli...@gmail.com 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:
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 scott.marl...@gmail.comwrote:
On Tue, Apr 10, 2012 at 12:34 PM, Wells Oliver
Wells Oliver wellsoli...@gmail.com 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
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
Kevin Grittner kevin.gritt...@wicourts.gov writes:
Wells Oliver wellsoli...@gmail.com 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
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
Wells Oliver wellsoli...@gmail.com 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?
I am using the WAL method w/ 9.1.
On Tue, Apr 10, 2012 at 4:29 PM, Kevin Grittner kevin.gritt...@wicourts.gov
wrote:
Wells Oliver wellsoli...@gmail.com 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
[rearranged; please don't top-post]
Wells Oliver wellsoli...@gmail.com wrote:
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
Wells Oliver wellsoli...@gmail.com 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
Sorry for the delay.
On Tue, Apr 3, 2012 at 1:44 AM, masterchief esi...@theiqgroup.com 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
16 matches
Mail list logo