Greetings.
I just noticed the following default ports in the pg_upgrade --help:
-p, --old-port=OLDPORTold cluster port number (default 50432)
-P, --new-port=NEWPORTnew cluster port number (default 50432)
Why is this different from:
--with-pgport=PORTNUM set default port nu
On 10/04/2012 12:29 AM, Виктор Егоров wrote:
Greetings.
I just noticed the following default ports in the pg_upgrade --help:
-p, --old-port=OLDPORTold cluster port number (default 50432)
-P, --new-port=NEWPORTnew cluster port number (default 50432)
http://www.postgresql.o
2012/10/4 Adrian Klaver :
> http://www.postgresql.org/docs/9.2/static/pgupgrade.html
> "Obviously, no one should be accessing the clusters during the upgrade.
> pg_upgrade defaults to running servers on port 50432 to avoid unintended
> client connections. You can use the same port number for both c
Hi, i am new to postresql and have been trying to convert some of our mssql
procedures into postresql functions. What i have been trying to do is to
somehow return a temporary table with dynamic columns. Is it possible?
On Thu, Oct 04, 2012 at 12:22:55PM +0530, Swayam Prakash Vemuri wrote:
> Hi
>
> We have an application which uses postgresql 7.4.5.
You have a very large problem. The 7.4 series went out of support two
years ago at 7.4.30, which means that you have known data corruption
and crash bugs, and would
Hello
2012/10/4 clear chan :
> Hi, i am new to postresql and have been trying to convert some of our mssql
> procedures into postresql functions. What i have been trying to do is to
> somehow return a temporary table with dynamic columns. Is it possible?
>
it is possible, but usually it is not, w
On 10/04/2012 10:13 AM, David Fetter wrote:
For each database on the 7.4 machine, run the following on the 9.2
machine:
pg_dump -h name.of.7.4.machine.com -U postgres -Fc --file=mydb.dump mydb
Don't forget the global settings:
pg_dumpall -g -U postgres -f globals.sql
And you should pro
On Tue, Oct 2, 2012 at 5:09 PM, Jeff Janes wrote:
> I don't know how the transactionality of analyze works. I was
> surprised to find that I even could run it in an explicit transaction
> block, I thought it would behave like vacuum and create index
> concurrently in that regard.
>
> However, I
The appropriate list for this is the jdbc list: pgsql-j...@postgresql.org
-
Achilleas Mantzios
IT DEPT
We use Debian linux 32-bits, so the addressable space available really seems
to be in the 3.0Gb to 3.5Gb range. Last night I decreased the shared_buffers
from 2Gb to 1Gb and tried the global ANALYZE again. It went out of memory
after 3 hours 40 minutes. That database has 12,197 schemas with 22 tabl
"Hugo " writes:
> We use Debian linux 32-bits, so the addressable space available really seems
> to be in the 3.0Gb to 3.5Gb range. Last night I decreased the shared_buffers
> from 2Gb to 1Gb and tried the global ANALYZE again. It went out of memory
> after 3 hours 40 minutes. That database has 12
On Thu, Oct 4, 2012 at 10:54 AM, Hugo wrote:
> We use Debian linux 32-bits, so the addressable space available really seems
> to be in the 3.0Gb to 3.5Gb range. Last night I decreased the shared_buffers
> from 2Gb to 1Gb and tried the global ANALYZE again. It went out of memory
> after 3 hours 40
On Thu, Oct 4, 2012 at 04:50:09PM +0300, Виктор Егоров wrote:
> 2012/10/4 Adrian Klaver :
> > http://www.postgresql.org/docs/9.2/static/pgupgrade.html
> > "Obviously, no one should be accessing the clusters during the upgrade.
> > pg_upgrade defaults to running servers on port 50432 to avoid unint
Jeff Janes writes:
> For the record, the culprit that causes "analyze;" of a database with
> a large number of small objects to be quadratic in time is
> "get_tabstat_entry" and it is not fixed for 9.3.
I was a bit surprised by this assertion, as I'd thought that tabstats
were flushed to the coll
On 01/10/2012 15:36, Moshe Jacobson wrote:
> I am working on an audit logging trigger that gets called for every row
> inserted, updated or deleted on any table.
> For this, I need to store a couple of temporary session variables such as
> the ID of the user performing the change, which can be set
Hi all.
I'd like to tap into the list's experience regarding the job of a DBA
in general and Pg DBA in particular.
I see that most of the DBA job posts ask for Sr or Ssr which is
understandable given that databases are among a company’s most
valuable assets, but it is also an obvious catch-22. So
Hi, this is my first post so forgive me if I ve done something wrong, because
this is my first experience with a forum post which works through a mailing
list.
I am bumping this topic because as a long time pokertracker user who's tried
to maximize the performance of his system for years, this to
On Thu, Oct 4, 2012 at 6:12 AM, Ivan Voras wrote:
> On 01/10/2012 15:36, Moshe Jacobson wrote:
> > I am working on an audit logging trigger that gets called for every row
> > inserted, updated or deleted on any table.
> > For this, I need to store a couple of temporary session variables such as
>
On 10/05/2012 03:58 AM, serraios wrote:
*2. My Software Setup.* I am using Windows 7 x64, but the database -and my
poker playing- is installed in a Virtualbox VM running Windows XP x64. I
have assigned 1 processor (out of 16) and 12 GB of RAM in that machine.
Well there's your first problem. G
On Oct 4, 2012, at 1:44 PM, Thalis Kalfigkopoulos wrote:
> Hi all.
>
> I'd like to tap into the list's experience regarding the job of a DBA
> in general and Pg DBA in particular.
>
> I see that most of the DBA job posts ask for Sr or Ssr which is
> understandable given that databases are among
On Thu, Oct 4, 2012 at 2:44 PM, Thalis Kalfigkopoulos
wrote:
> Hi all.
>
> I'd like to tap into the list's experience regarding the job of a DBA
> in general and Pg DBA in particular.
>
> I see that most of the DBA job posts ask for Sr or Ssr which is
> understandable given that databases are amon
Swayam Prakash Vemuri, 04.10.2012 08:52:
Hi
We have an application which uses postgresql 7.4.5.
Now when we moved to Java 1.6, we are seeing lots of jdbc driver related
compilation issues like shown at end of this email.
Not only are you using an outdated (and unsupported) PostgreSQL versio
On 10/04/12 11:21 PM, Thomas Kellerer wrote:
You are also moving to a Java version that is soon to be de-supported.
Java is supported? only if you mean the non-stop stream of updates
brought on by web exploit exposures.
if you're using Java as a server side application development
environm
On Fri, Oct 5, 2012 at 6:44 AM, Thalis Kalfigkopoulos
wrote:
> Is it an easier and more common entry point to be a part-time DBA e.g.
> perform DBA duties as part of being a U**X sysadmin?
>
> Is it more common to start as a developer and change focus to DBA?
>
> In particular how does one go abou
24 matches
Mail list logo
