as it squashed?
It would have been helpful to have that from the start.
--
Wells Oliver
wellsoli...@gmail.com
On Jul 12, 2013, at 2:23 AM, Giuseppe Broccolo
wrote:
> Hi Oliver,
>
> Il 12/07/2013 04:07, Wells Oliver ha scritto:
>> I ran:
>>
>> pg_ctlcluster 9.1
g the offending view?
--
Wells Oliver
wellsoli...@gmail.com
I was running
pg_ctlcluster? It would have saved me a lot of time.
--
Wells Oliver
wellsoli...@gmail.com
s viable? If not, is there another way to create a duplicate
> cluster
> > > in a timely fashion?
> >
> > Test Repmgr works with the same philosophy. ;-)
> >
> > Saludos,
> > Gilberto Castillo
> > La Habana, Cuba
> >
> >
rocessed by Kaspersky Mail Gateway 5.6.28/RELEASE
> running at host imx3.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
>
>
--
Wells Oliver
wellsoli...@gmail.com
viable? If not, is there another way to create a duplicate cluster
in a timely fashion?
--
Wells Oliver
wellsoli...@gmail.com
What is the proper way to repoint pg_config? I'm on Ubuntu Server, so it's
in /usr/bin/pg_config, which references 9.1.
On Thu, Jul 11, 2013 at 10:52 AM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> On Thu, Jul 11, 2013 at 11:14 PM, Wells Oliver wrote:
>
I have 9.1 and 9.2 installed, and I am trying to build the PLR extension:
http://www.joeconway.com/plr/doc/plr-install.html
I'm using the USE_PGXS=1 method. But it's building for 9.1:
gcc -I/usr/include/postgresql/9.1/server ...
I want to build for 9.2. How can I do this?
the WAL is still being
created and the master/slave relationship properly maintained?
Thanks.
--
Wells Oliver
wellsoli...@gmail.com
data directory and the files will still be in the new
> directory since the link count will be > 0.
>
> Ken
>
--
Wells Oliver
wellsoli...@gmail.com
. It took all of 10 minutes to complete, which didn't count for
> running the analyze afterward. However, if you are going to run the analyze
> DB afterward, your mileage may vary.
>
>
> On Wed, Jul 10, 2013 at 11:52 AM, Wells Oliver wrote:
>
>> Can anyone speak to the spe
Can anyone speak to the speed of pg_upgrade? Our database is 153GB. From
9.1 to 9.2, I'm nervous it might take hours. If it were less than hour,
downtime would be more acceptable.
On Wed, Jul 10, 2013 at 11:08 AM, Jonathan Nalley wrote:
> On Wed, Jul 10, 2013 at 1:53 PM, Wells Oliver
f 9.1, then switch it over.
Is there a better idea? Thanks for any tips.
--
Wells Oliver
wellsoli...@gmail.com
f && cp %p
/mnt/postgresql-logs/%f'
max_wal_senders = 3
wal_keep_segments = 16
So, now I have 16GB of WAL segments, 974 of them. Will postgresql clean
this up? Will it remove these files? Will it create more with big inserts?
What is the best way to manage this?
--
Wells Oliver
wellsoli...@gmail.com
--
Wells Oliver
wellsoli...@gmail.com
Trying to call my function like so:
select myschema.myfunction(select myid from mytable);
myfunction has the signature: myfunction(integer[])
myid is an integer; I am trying to select them as an array to pass to the
function.
Where am I going wrong? Thanks!
--
Wells Oliver
wellsoli
Is there a way to get the date that starts week 14, or 15 (etc)?
--
Wells Oliver
wellsoli...@gmail.com
COPY to avoid this? There are properly quoted
string values elsewhere in the final, so I'm reticent to strip out double
quote characters or anything.
Thank you.
--
Wells Oliver
wellsoli...@gmail.com
h, OK, it _was_ 200 but now it's definitely 100. Is there a reason this
change cannot be made now?
--
Wells Oliver
wellsoli...@gmail.com
How do you ensure you're not keeping logs from 35+ days ago, or whatever?
Just a find -mtime +10 -exec rm {}\; kind of thing?
On Wed, Apr 11, 2012 at 4:03 PM, Tom Lane wrote:
> Wells Oliver writes:
> > Might anyone share theirs? My log_rotation is set to 'stderr', and
r any tips.
--
Wells Oliver
wellsoli...@gmail.com
Is the server perpetually in recovery mode?
Looking at PGAdmin, "in recovery?" is "yes", but replay location is the
same as receive location, and the data is absolutely up to date.
Is the recovery bit an issue, or just SOP?
Thanks.
--
Wells Oliver
wellsoli...@gmail.com
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'
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
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:
>
re log that has everything?
I could also do a pg_restore to the new slave from last night's DB backup,
but I understand (at least, I seem to read it) that you can't bring a slave
up using pg_restore.
Are there any other options I am missing? Thanks for any tips.
--
Wells Oliver
wellsoli...@gmail.com
ou might need to add
explicit type casts.
But on another postgres 8.4 server, it properly returns a concatenated string.
Any tips on how/where I can track down why/where there might be duplicate
operators?
--
Wells Oliver
Architect, Baseball Systems
619-795-5359
San Diego Padres | 100 Park Boul
nse- great food for thought. Do you have any
recommendations on a pg connection pooler?
--
Wells Oliver
Architect, Baseball Systems
619-795-5359
San Diego Padres | 100 Park Boulevard | San Diego CA 92101
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your su
The value of shared_buffers is set to 6GB, work_mem is 64MB,
maintenance_work_mem is 128MB, effective_cache_size is 4GB.
max_connections is set to 200.
Any ideas here? The system has 12GB; raising the shared_buffers seems
reasonable but 6GB also feels like it should be sufficient.
Any thou
ocess?
Thanks.
--
Wells Oliver
wellsoli...@gmail.com
ly the DB name. I've looked
over the logging options in the documentation and they are legion. What
are my key options to reduce logging to the lowest, most vital sort of
messages?
Thanks for tips!
--
Wells Oliver
Developer, Baseball Systems
San Diego Padres | 100 Park Boulevard | San Diego CA 92101
ents. Also, what's the best way to track down the reason for the
crash? Just get into /var/log/postgresql and poke around?
Thanks.
--
Wells Oliver
Developer, Baseball Systems
San Diego Padres | 100 Park Boulevard | San Diego CA 92101
619-795-5359
32 matches
Mail list logo
