On Saturday 07 May 2011, John R Pierce elucidated thus:
> On 05/07/11 6:08 AM, Bob Wilson wrote:
> > Hello
> > This is Bob and I will like to order ( Indexing Table )Do get back
> > to me with the types and cost for the ones you do carry and let me
> > know if there is an extra cost when using visa
On Wednesday 20 October 2010, John R Pierce elucidated thus:
> On 10/20/10 3:46 AM, Georgi Ivanov wrote:
> > Hi,
> > Is there any specific reason one should/should not run postgre on
> > virtual machine for production ?
> > Is there any special tuning for virtual environment ?
> > Client of mine is
On Friday 15 October 2010, Scott Marlowe elucidated thus:
> On Fri, Oct 15, 2010 at 12:37 PM, Tom Lane wrote:
> > I'd look around for a cron job or some other periodic task that
> > thinks it's supposed to reload the database or something like that.
> > Postgres doesn't forget stuff that easily .
On Thursday 30 September 2010, Dann Corbit elucidated thus:
> I installed the 64 bit PostgreSQL 9.0 on Windows Server 2008 and it
> seems to perform wonderfully. I moved 1.5 million records that are 3K
> wide from SQL*Server into PostgreSQL and rebuilt 6 indexes all in
> less than 6 minutes.
> I w
On Tuesday 21 September 2010, Dmitriy Igrishin elucidated thus:
> Hey all,
>
> After ten years with stored procedures I am thinking so this is not
>
> > too well technique. Much better is writing stored procedures to a
> > file and using usual tools for file's versioning. We did some tools
> > for
On Tuesday 21 September 2010, Henri De Feraudy elucidated thus:
> Hello,
> I have developed an application in C++ under Qt in Windows XP, now I
> would like to port it to Ubuntu GNU/Linux.
> Choosing the libraries in Windows was a piece of cake: the bottom of
> my Qt qmake project file was
> win3
On Friday 17 September 2010, Tom Lane elucidated thus:
> "Joshua J. Kugler" writes:
> > On Thursday 16 September 2010, Tom Lane elucidated thus:
> >> Update. Whatever reasons you might have for running 7.3.2 are bad
> >> ones.
> >
> > Disclaim
On Thursday 16 September 2010, Tom Lane elucidated thus:
> "Utsav Turray" writes:
> > I am using postgres 7.3.2 on RHEL 4.0.
>
> Egad.
>
> > Secondly what are probable reasons behind corruption and what can
> > we do to prevent this error.
>
> Update. Whatever reasons you might have for runnin
On Wednesday 15 September 2010, Peter Hopfgartner elucidated thus:
> The server is a rather bare bone server for web mapping, so basically
> PostgreSQL/PostGIS, Apache, PHP, Tomcat and little other stuff. The
> Dell software was the only which did not come from
> CentOS/EPEL/argeo/in-house RPM pack
On Tuesday 07 September 2010, Scott Ribe elucidated thus:
> On Sep 7, 2010, at 7:09 PM, Tom Lane wrote:
> > Personally, though, I think it's easier to change the default port
> > number and not worry about sharing /tmp. Changing the port is a
> > good idea anyway to avoid any possible conflicts on
On Tuesday 07 September 2010, John R Pierce elucidated thus:
> On 09/07/10 5:15 PM, Scott Ribe wrote:
> > Assume I want to install an instance of postgres such that it
> > cannot interfere with another install, or even be visible to other
> > apps. Is this all I need to do:
> >
> > - install pg s
On Monday 09 August 2010, Joshua D. Drake elucidated thus:
> On Mon, 2010-08-09 at 10:09 -0600, Scott Ribe wrote:
> > It's not a requirement, just a reasonable default.
>
> The actual requirement is:
>
> Thou shall not use a privelaged user, e.g; Administrator or UID = 0.
>
> Not only is that a rea
On Monday 09 August 2010, Randal L. Schwartz elucidated thus:
> >>>>> "Joshua" == Joshua J Kugler writes:
>
> Joshua> I'll add in a "me too" only to say that I am someone that
> learns Joshua> best by example.
>
> Keep in mind
On Friday 06 August 2010, Scott Marlowe elucidated thus:
> >> Everyone of my trainees want such thing - for databases, for other
> >> programming-languages etc. It's the worst thing you can give them.
> >> The< will copy, they will paste and they will understand nothing.
> >> Learning is the way to
On Thursday 14 January 2010, Fernando Hevia elucidated thus:
> > The easiest way is to shut down Pg, move the 'main' directory
> > somewhere else, and then point a symlink to the new location.
>
> Thanks for your reply.
> I had considered this first but then I wasn't sure if there would be
> any pe
On Thursday 14 January 2010, Fernando Hevia elucidated thus:
> An Ubuntu install creates a postgres cluster automatically on
> /var/lib/postgresql/8.4/main
> Whats the best procedure for moving this cluster to an other
> location? Should I just rerun initdb? What happens then with the
> default clu
On Wednesday 11 November 2009, David Kerr said something like:
> I'm trying to meet a very high uptime requirement in a high
> performance environment.
If you don't mind Xen, have you considered:
http://dsg.cs.ubc.ca/remus/ System mirroring/hot standby, with instant
failover, complete with any o
On Monday 29 June 2009, fe...@crowfix.com said something like:
> I'd like to dump a database schema to a file, probably XML but
> anything reasonable is good enough. By "schema", I don't mean the
> narrow postgres keyword, but rather the table names, columns,
> foreignkeys, triggers, constraints,
On Wednesday 17 December 2008, justin said something like:
> aravind chandu wrote:
> > Hello,
> > I have problem with select statement in c++ program I am
> > using pqxx library to connect to postgresql database.My query is
> >
> > result R(T.exec(" select * from dbtable where u
On Wednesday 17 December 2008, Peter Eisentraut said something like:
> Because the TRUNCATE commands are taking out an exclusive lock on the
> tables.
>
> > My understanding of MVCC is that I should be able to query against
> > those tables while these insert loops are in their transaction.
>
> You
I've read the Pg docs about MVCC and possible locks that indexes can
create. Even so, I can't figure out why my code is causing all other
queries to block while it is running. I'm reading data in from a file
(line by line, its CSV), doing a little pre-processing, and inserting
it into a table
21 matches
Mail list logo
