On Wed, Apr 27, 2011 at 04:17:16PM -0400, Mark Stosberg wrote:
> On 04/27/2011 10:48 AM, Mark Stosberg wrote:
> >
> > Hello,
> >
> > I'm working on moving a table with over 30 million to rows to be
> > partitioned. The table seeing several inserts per second. It's
> > essentially an activity log
On Mon, Aug 01, 2011 at 04:42:23PM +0200, Willy-Bas Loos wrote:
> Hi,
>
> I'ver been wondering how to set the number of rows that are scanned by
> analyze. (I want to increase it)
> I couln't find it at first but when i read closer i found that is does:
> "The largest statistics target among the c
On Wed, Dec 28, 2011 at 11:13:22AM +0100, lst_ho...@kwsoft.de wrote:
> Zitat von Craig Ringer :
>
> >On 22/12/2011 5:41 PM, lst_ho...@kwsoft.de wrote:
> >>Zitat von "Liu, Jianli (Jianli)" :
> >>
> >>>No one has responded to my questions. I am wondering if anyone
> >>>can point me to where in postg
On Fri, May 04, 2012 at 01:57:47PM +0200, Thomas Kellerer wrote:
> Hi,
>
> I'm trying to enable "ident" authentication on my Windows machine using
> PostgreSQL 9.1
>
> However as soon as I add the following line to pg_hba.conf
>
>hostall all ::1/128id
On Fri, May 04, 2012 at 03:22:47PM +0530, Gnanakumar wrote:
> > SELECT application_name, client_addr, client_hostname, client_port
> > FROM pg_stat_activity
> > WHERE procpid = 14740;
>
> > (Replace 14740 of the process ID of the "idle in transaction" backend).
>
> > Look on the client machine an
On Fri, May 04, 2012 at 08:57:08AM -0500, Kevin Grittner wrote:
> "k...@rice.edu" wrote:
>
> > You may also want to consider setting a statement_timeout to
> > prevent this until you can find the problem with the application.
>
> How would a statement time
On Mon, May 14, 2012 at 11:02:30AM -0600, Benjamin Krajmalnik wrote:
> I am experiencing a little higher CPU load than I would like to see, and
> was wondering if it has to do with the number of connections (although
> many are idle).
>
> I am running PG 9.0.4/amd64 on FreeBSD 8.1., dual boxes run
On Wed, May 16, 2012 at 02:52:44PM -0400, David Schnur wrote:
> I'm investigating a 'could not stat file' error that points to a file
> "base/16384/52212305.1". All the data files I've ever seen have names that
> are whole numbers; I've never seen a decimal suffix. It occurs to me that
> perhaps
On Thu, Jul 26, 2012 at 01:16:42PM +0530, Rajat Sangal wrote:
> Hello Everyone,
>
> I want to import Data from MySql to MS Sql Server 2008 using vb.net.
> So please help me. Pls give me reply as soon possible.
>
You should probably post this to a MySQL or MSSQL mailing list or
forum. This venue i
On Sat, Feb 23, 2013 at 12:55:07AM -0500, Charles Sprickman wrote:
> Howdy,
>
> I've been finding that keeping full query logs is quite helpful; I started
> doing this to be able to run pgbadger each day to get a nice overview of
> what's going on with the db servers. The one huge downside to t
On Mon, Feb 25, 2013 at 01:57:11PM -0500, Frank Cavaliero wrote:
> Hi Adrian,
>
> Thanks for the response. The situation is more like the following:
>
> Using the JDBC driver, I connect to database TEST1 and immediately,
> without having to pass username credentials again, I want to use databa
On Wed, Apr 10, 2013 at 11:06:32AM -0700, Bhanu Murthy wrote:
> Hi all,
>
> Can someone please point me to detailed documentation on how to
> secure/encrypt connections between PGBouncer and Postgresql database (version
> 8.4.3)?
>
> Thanks in advance!
>
> Bhanu M. Gandikota
> Cell: (415)
On Wed, May 01, 2013 at 01:58:21PM -0600, Benjamin Krajmalnik wrote:
> I need to migrate a production database from Postgres 9.0 to Postgres
> 9.2.
>
> Running FreeBSD 8.1/amd64, and presently running Postgres 9.0.4.
>
> Due to the nature of the application, I cannot have any considerable
> downt
On Tue, May 28, 2013 at 11:28:02AM -0400, steve.tout...@inspq.qc.ca wrote:
> Hi,
> Using postgres 9.2, I created a FOREIGN TABLE on a csv file. It works.
> But I need to change the structure of the data and I created several sql
> select using union, like
> select from .foreign table... where
On Wed, Jul 10, 2013 at 02:08:04PM -0400, Jonathan Nalley wrote:
> On Wed, Jul 10, 2013 at 1:53 PM, Wells Oliver wrote:
> > I have 9.1 running on 5432, and 9.2 running on 5433. The 9.1 database size
> > is 153g. 9.1 is actively used by systems, 9.2 is just sitting there empty.
> >
> > I'd like to
On Wed, Jul 10, 2013 at 11:52:54AM -0700, Wells Oliver wrote:
> 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.
>
You can use the --link option and then you make
On Wed, Jul 10, 2013 at 12:02:06PM -0700, Wells Oliver wrote:
> Hard linking means that you must maintain 8.2's data directory though, even
> after upgrade, correct? Since it's a link and not a copied file.
>
I think it only hard links the files to the new 9.2 data directory so you
can delete the
On Wed, Jul 10, 2013 at 03:46:28PM -0500, lxnf9...@gmail.com wrote:
> On Wed, 10 Jul 2013, Vincent Lau wrote:
>
> how would pg_upgrade be used to upgrade to a new machine
> use nfs?
> would i run pg_upgrade on the new server?
>
>
I would replicate to the new server from the old using WAL to get
18 matches
Mail list logo