We are assessing how to migrate our current (and very old) Oracle Database
10.1.2.4 to Postgres. Our question/concern is the data to be migrated is used
extensively by custom applications written with Oracle Forms 6i. Will Postgres
work with Forms 6i? If not, what options would you
On 2/20/2014 12:45 PM, Santo Campione wrote:
We are assessing how to migrate our current (and very old) Oracle
Database 10.1.2.4 to Postgres. Our question/concern is the data to be
migrated is used extensively by custom applications written with
Oracle Forms 6i. Will Postgres work with Forms
On 02/20/2014 12:53 PM, John R Pierce wrote:
On 2/20/2014 12:45 PM, Santo Campione wrote:
We are assessing how to migrate our current (and very old) Oracle
Database 10.1.2.4 to Postgres. Our question/concern is the data to be
migrated is used extensively by custom applications written with
On Thu, 2014-02-20 at 14:03 -0800, Joshua D. Drake wrote:
On 02/20/2014 12:53 PM, John R Pierce wrote:
On 2/20/2014 12:45 PM, Santo Campione wrote:
We are assessing how to migrate our current (and very old) Oracle
Database 10.1.2.4 to Postgres. Our question/concern is the data to be
Has anyone successfully connected and browsed a postgres database
using the Eclipse QuantumDB plugin?
I can connect and execute sql, but the existing table list is always
empty as if no meta information is ever provided to the browser
plugin. At first, I thought it might be a permission problem
On 11/22/2013 05:46 AM, Mike Kienenberger wrote:
Has anyone successfully connected and browsed a postgres database
using the Eclipse QuantumDB plugin?
You might get a answer sooner here:
http://sourceforge.net/p/quantum/discussion/24178/
I can connect and execute sql, but the existing
Em 22/11/2013 12:54, Adrian Klaver escreveu:
On 11/22/2013 05:46 AM, Mike Kienenberger wrote:
Has anyone successfully connected and browsed a postgres database
using the Eclipse QuantumDB plugin?
You might get a answer sooner here:
http://sourceforge.net/p/quantum/discussion/24178/
I can
I wanted to make sure that it wasn't a permission configuration
problem in postgres first, since all of the other databases have
worked without a similar issue.
On Fri, Nov 22, 2013 at 9:54 AM, Adrian Klaver adrian.kla...@gmail.com wrote:
On 11/22/2013 05:46 AM, Mike Kienenberger wrote:
Has
Adrian, Thanks!
Searching through those forum posts (I had tried doing general google
searches first before posting here, but didn't turn up that forum) I found this:
http://sourceforge.net/p/quantum/discussion/24178/thread/17724b28/?limit=25#1166
which seems to indicate that at least back in
HI,
Is there a way to connect to a sqlserver like dblink?
I just need to execute a Procedure in sqlserver when something happen
--
Gracias
-
Agustín Larreinegabe
On 9/17/2013 11:05 AM, Agustin Larreinegabe wrote:
Is there a way to connect to a sqlserver like dblink?
I just need to execute a Procedure in sqlserver when something happen
postgresql *is* a sql server.or do you mean Microsoft SQL Server ?
--
john r pierce
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Agustin Larreinegabe
Sent: Tuesday, September 17, 2013 2:06 PM
To: PostgreSQL mailing lists
Subject: [GENERAL] Connect postgres to SQLSERVER
HI,
Is there a way to connect to a sqlserver like dblink
On Wed, Sep 18, 2013 at 12:11 AM, Igor Neyman iney...@perceptron.com wrote:
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Agustin Larreinegabe
Sent: Tuesday, September 17, 2013 2:06 PM
To: PostgreSQL mailing lists
Subject: [GENERAL] Connect
On 17/09/2013 19:05, Agustin Larreinegabe wrote:
HI,
Is there a way to connect to a sqlserver like dblink?
I just need to execute a Procedure in sqlserver when something happen
--
Gracias
-
Agustín Larreinegabe
If all you want to do is trigger a single stored proc, one option
Sent: Wednesday, August 14, 2013 9:14 PM
To: Barth Weishoff
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Debugging Postgres?
Hi,
Having a look at the PostgreSQL log may help.
http://stackoverflow.com/questions/71/how-to-log-postgres-sql-queries
You could also try logging in via
On 08/13/2013 01:51 PM, Barth Weishoff wrote:
Hello
I'm having an interesting issue with PGSQL. It seems that I'm
experiencing timeouts at various times. The servers are not busy and
have plenty of resources. The databases are ~50GB in size, the
systems typically have 8-12GB physical
Hello
I'm having an interesting issue with PGSQL. It seems that I'm
experiencing timeouts at various times. The servers are not busy and have
plenty of resources. The databases are ~50GB in size, the systems
typically have 8-12GB physical RAM, and the connections are low (less than
15 at
Hi,
Having a look at the PostgreSQL log may help.
http://stackoverflow.com/questions/71/how-to-log-postgres-sql-queries
You could also try logging in via psql on the database host itself, to
ensure it is not a network issue.
Regards,
Jayadevan
On Wed, Aug 14, 2013 at 2:21 AM, Barth Weishoff
Stephen Brearley, 02.08.2013 11:40:
I can change my registry reference to point to D:\..\9.2\data or
D:\..\9.2\data_old without any (apparently) undesirable consequences,
but I just can’t see my tables in the system, which makes me think I need to
do more than this.
Why don't you use the
: Re: [GENERAL] Re: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400,
re-installation failure PLEASE CAN SOMEONE HELP!! (nearly fixed)
On Sat, Aug 3, 2013 at 7:16 AM, Alban Hertroys haram...@gmail.com wrote:
They are cluster specific, as the roles are stored in the database. If you
switch
On Mon, Aug 5, 2013 at 2:21 AM, Thomas Kellerer spam_ea...@gmx.net wrote:
Stephen Brearley, 02.08.2013 11:40:
Why don't you use the official way to re-configure the Windows service and
use pg_ctl unregister and pg_ctl register
to make it use the correct data directory. There is no need to
On Sat, Aug 3, 2013 at 7:16 AM, Alban Hertroys haram...@gmail.com wrote:
They are cluster specific, as the roles are stored in the database. If you
switch between different data directories, that means you're switching the
available roles as well. And their details, such as passwords. You're
On Aug 3, 2013, at 24:04, BladeOfLight16 bladeofligh...@gmail.com wrote:
My big concern as I've been reading this thread is whether users are cluster
specific or installation specific. If they're cluster specific, he'll need to
know credentials for his original cluster anyway to get the
On 08/02/2013 02:40 AM, Stephen Brearley wrote:
Hi Folks (hope I haven’t left anyone out)
SUCCESS (ALMOST)!!
I’ve managed to re-install Postgres **without any install errors** and
I’ve managed to login **without any connection errors**
But..I’m not 100% sure how I did it and..
I can’t
On Fri, Aug 2, 2013 at 10:18 AM, Adrian Klaver adrian.kla...@gmail.comwrote:
You can't do that and have it work. \base is just part of the puzzle, you
need the complete \data directory for Postgres to work.
The problem(as stated before) is you have two distinct installations of
the Postgres
Alban Hertroys, 31.07.2013 15:16:
I suspect the postgres log is either in the Windows Event Log
(available from the Control Panel, perhaps under Administrative Tools
or something similar) or in a file somewhere in the Postgres
installation directory, most likely in a directory named log.
It's
hidayat...@gmail.com, 31.07.2013 15:52:
As per my experience, installing postgresql on windows machine
automatically create postgres user. When you uninstall it, the
postgres user doesn't automatically removed, you must remove it
manually.
Not any more.
Since 9.1 (or was it 9.2?) Postgres
Stephen Brearley wrote on 29.07.2013 21:23:
1.Explain why my bug report has not been responded to
Because it's not a bug as you simply upgraded incorrectly.
5.Tell me how I should uninstall Postgres, if I am doing this wrong
You did run the Uninstall, did you?
6.Tell me how to remove any
Its looks like your previous un-installation was not done properly.
Uninstall it properly first then restart your system.
check pre-requisite for postgresql if any.
then install Postgres 9.2.4.
--
View this message in context:
From: Stephen Brearley
To: pgsql-general@postgresql.org
Sent: Wednesday, July 17, 2013 5:41 AM
Subject: [GENERAL] FW: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400,
re-installation failure
snip
The Problem
On re-installing Postgres, I have not been able to get it to work. During
re
Hello,
I'd like to ask a common question about scale out for postgres.
Our current data volume is about 500GB ~ 1TB in one pg cluster(postgres 9.2).
We've set up master/slave replication to keep sync.
To reach better performance from apps side, we want to use pgbounder like app
to split
On Wed, Jul 17, 2013 at 03:10:37PM +0800, Xiang Jun Wu wrote:
- Hello,
-
- I'd like to ask a common question about scale out for postgres.
-
- Our current data volume is about 500GB ~ 1TB in one pg cluster(postgres 9.2).
We've set up master/slave replication to keep sync.
- To reach better
=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= franc...@teksol.info writes:
Le 2013-06-06 à 17:59, Tom Lane a écrit :
Note where the fine manual says:
schema_name
The name of an existing schema. Each target_role must have CREATE privileges
for each specified schema.
There was some debate
Le 2013-06-06 à 17:59, Tom Lane a écrit :
=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= franc...@teksol.info writes:
regress=# ALTER DEFAULT PRIVILEGES FOR ROLE dataanalysts IN SCHEMA public
REVOKE SELECT ON TABLES FROM dataanalysts;
ERROR: permission denied for schema public
I'm logged in as
Hi all!
I would like to remove the second line from default privileges, because
dataanalysts can't create new tables in public anyway:
# psql -U postgres
psql (9.1.9)
Type help for help.
regress=# \ddp
Default access privileges
Owner |Schema| Type |
=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= franc...@teksol.info writes:
regress=# ALTER DEFAULT PRIVILEGES FOR ROLE dataanalysts IN SCHEMA public
REVOKE SELECT ON TABLES FROM dataanalysts;
ERROR: permission denied for schema public
I'm logged in as postgres, the database superuser. Why am I
On Fri, May 17, 2013 at 1:16 AM, Oscar Calderon
ocalde...@solucionesaplicativas.com wrote:
Hi to everybody, i just wanna ask you if somebody that already has the
certification or if is studying to get it knows if there's a book (or a set
of books) that you recommend me that contains most of
Hi to everybody, i just wanna ask you if somebody that already has the
certification or if is studying to get it knows if there's a book (or a set
of books) that you recommend me that contains most of the necessary
information to cover the topics of the certification, that are the next:
-
I would also like to know this as well.
On Thu, May 16, 2013 at 2:46 PM, Oscar Calderon
ocalde...@solucionesaplicativas.com wrote:
Hi to everybody, i just wanna ask you if somebody that already has the
certification or if is studying to get it knows if there's a book (or a set
of books)
On Mar 9, 2013, at 11:54 AM, Paul Jungwirth wrote:
Hello,
I'm running a specialized search engine that indexes a few tens of millions
of web pages, keeping everything in Postgres, and one problem I'm starting to
see is poor cache hit rates. My database has two or three tables just for the
Well, what problem exactly are you trying to solve?
Having large tables itself isn't a problem, but it often
tends to imply other things that might be problematic:
I'm trying to troubleshoot a very low cache hit rate as returned by this query:
SELECT sum(heap_blks_read) as heap_read,
Hello,
I'm running a specialized search engine that indexes a few tens of millions
of web pages, keeping everything in Postgres, and one problem I'm starting
to see is poor cache hit rates. My database has two or three tables just
for the text of the scraped pages, with one row every time a page
Thank you everybody for your help,
This problem has been resolved, in part to your insights.
All the best,
-JD
On Fri, Mar 1, 2013 at 4:31 AM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
JD Wong wrote:
Hi Adrian, yes I completely copied the config-file and data directories
over.
JD Wong wrote:
Hi Adrian, yes I completely copied the config-file and data directories
over.
That's guaranteed to break everything badly.
Even if I read only style copied the files? Do you mind elaborating on why
this happens? ( or point
me to relevant documentation )
The problem
On 03/01/2013 02:31 AM, Albe Laurenz wrote:
JD Wong wrote:
Hi Adrian, yes I completely copied the config-file and data directories
over.
That's guaranteed to break everything badly.
Even if I read only style copied the files? Do you mind elaborating on why
this happens? ( or point
Hi Adrian,
That's guaranteed to break everything badly.
Even if I read only style copied the files? Do you mind elaborating on
why this happens? ( or point me to relevant documentation )
Thanks,
-JD
On Tue, Feb 26, 2013 at 7:04 PM, Lonni J Friedman netll...@gmail.comwrote:
On Tue, Feb 26,
Hi Adrian, yes I completely copied the config-file and data directories
over.
Lonnie, I don't remember. I might not have shut down the old postgres,
yes I set PGDATA accordingly.
To sum things up, I created a situation where I would use the service to
start old postgres and pg_ctl to start the
I tried copying postgres over to a new directory. it was working until I
deleted a bunch of databases from the old postgres. Lo and behold this
somehow broke the new copy too.
Now when I start with pg_ctl
2013-02-22 18:36:13 EST DETAIL: The database subdirectory base/1066060
is missing.
Did you shut down the 'old' postgres before copying these files?
Did you (re)configure the 'new' postgres to set its $PGDATA directory
to the location of the 'new' files?
On Fri, Feb 22, 2013 at 3:46 PM, JD Wong jdmsw...@gmail.com wrote:
I tried copying postgres over to a new directory. it was
On 02/22/2013 03:46 PM, JD Wong wrote:
I tried copying postgres over to a new directory. it was working until
I deleted a bunch of databases from the old postgres. Lo and behold
this somehow broke the new copy too.
Did you actually copy or symlink?
Now when I start with pg_ctl
2013-02-22
On Tue, Feb 26, 2013 at 4:02 PM, JD Wong jdmsw...@gmail.com wrote:
Hi Adrian, yes I completely copied the config-file and data directories
over.
Lonnie, I don't remember. I might not have shut down the old postgres,
yes I set PGDATA accordingly.
That's guaranteed to break everything badly.
On Tue, Feb 26, 2013 at 4:10 PM, JD Wong jdmsw...@gmail.com wrote:
Hi Adrian,
That's guaranteed to break everything badly.
Even if I read only style copied the files? Do you mind elaborating on why
this happens? ( or point me to relevant documentation )
What is read only style, and how
On 02/26/2013 04:12 PM, Lonni J Friedman wrote:
On Tue, Feb 26, 2013 at 4:10 PM, JD Wong jdmsw...@gmail.com wrote:
Hi Adrian,
That's guaranteed to break everything badly.
Even if I read only style copied the files? Do you mind elaborating on why
this happens? ( or point me to relevant
Yes, this ML is not a right place to discuss this.
Could you raise this issue at postgres-xc-general ML?
Regards;
--
Koichi Suzuki
2013/2/12 Pavan Deolasee pavan.deola...@gmail.com:
This may not be the best place to ask these questions and you could
have considered using postgres-xc
On Tue, Feb 12, 2013 at 2:36 PM, Zenaan Harkness z...@freedbms.net wrote:
Does somone know the object overlap likely between pg and pgxc
repositories?
I ask because I could just git clone pgxc, or I could add a remote for
pgxc to my pg git clone, and make sure the branches are added, and
Does somone know the object overlap likely between pg and pgxc repositories?
I ask because I could just git clone pgxc, or I could add a remote for
pgxc to my pg git clone, and make sure the branches are added, and
fetch that remote.
And in this way, common files/ objects are properly shared in
This may not be the best place to ask these questions and you could
have considered using postgres-xc-general mailing list from the
Postgres-XC project site. Anyways, see my comments below.
On Tue, Feb 12, 2013 at 11:06 AM, Zenaan Harkness z...@freedbms.net wrote:
Does somone know the object
HI all -
I wrote a blog post on how my site takes advantage of Postgres ENUM
types with NHibernate and Castle ActiveRecord. Thought I'd share:
http://blog.kitchenpc.com/2012/12/21/using-enum-types-with-postgresql-and-castle-activerecord/
Mike
PS - Lemme know if any of the Postgres stuff isn't
wd wrote:
the time is between backup start and stop.
That is the problem -- until the point where pg_stop_backup() was
run PostgreSQL can't be sure of having a consistent database. It is
waiting from enough WAL to get it there. My practice is always to
keep the last two base backups and all WAL
Kevin Grittner kgri...@mail.com writes:
That is the problem -- until the point where pg_stop_backup() was
run PostgreSQL can't be sure of having a consistent database. It is
waiting from enough WAL to get it there. My practice is always to
keep the last two base backups and all WAL from the
On Tue, Nov 27, 2012 at 6:59 AM, Kevin Grittner kgri...@mail.com wrote:
wd wrote:
the time is between backup start and stop.
That is the problem -- until the point where pg_stop_backup() was
run PostgreSQL can't be sure of having a consistent database. It is
waiting from enough WAL to get
On Tue, Nov 27, 2012 at 6:59 AM, Kevin Grittner kgri...@mail.com wrote:
wd wrote:
the time is between backup start and stop.
That is the problem -- until the point where pg_stop_backup() was
run PostgreSQL can't be sure of having a consistent database.
In 9.2, it seems to be willing to give
wd wrote:
Logs are something like this:
[2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG: recovery
has paused
[2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 10 0]HINT: Execute
pg_xlog_replay_resume() to continue.
Well, try
SELECT pg_xlog_replay_resume();
Yours,
Laurenz Albe
I can't connect to postgres at that time.
On Mon, Nov 26, 2012 at 4:33 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
wd wrote:
Logs are something like this:
[2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG: recovery
has paused
[2012-11-24 21:51:33.591 CST 583 50b0d0e5.247
wd wrote:
Logs are something like this:
[2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG: recovery
has paused
[2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 10 0]HINT:
Execute pg_xlog_replay_resume() to continue.
Well, try
SELECT pg_xlog_replay_resume();
I can't connect
On Sat, Nov 24, 2012 at 3:44 PM, wd w...@wdicc.com wrote:
What entries are you getting in the log file?
Logs are something like this:
[2012-11-24 21:51:33.374 CST 583 50b0d0e5.247 1 0]LOG: database system
was shut down in recovery at 2012-11-24 21:51:32 CST
[2012-11-24
Jeff Janes wrote:
FATAL: requested recovery stop point is before consistent recovery point
I don't understand why are you not getting this message.
Is it before the point where pg_stop_backup() was run?
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Mon, Nov 26, 2012 at 12:23 PM, Kevin Grittner kgri...@mail.com wrote:
Jeff Janes wrote:
FATAL: requested recovery stop point is before consistent recovery point
I don't understand why are you not getting this message.
Is it before the point where pg_stop_backup() was run?
It turns out
On Mon, Nov 26, 2012 at 11:32 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
wd wrote:
Logs are something like this:
[2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG: recovery
has paused
[2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 10 0]HINT:
Execute
On Tue, Nov 27, 2012 at 8:27 AM, Jeff Janes jeff.ja...@gmail.com wrote:
On Mon, Nov 26, 2012 at 12:23 PM, Kevin Grittner kgri...@mail.com wrote:
Jeff Janes wrote:
FATAL: requested recovery stop point is before consistent recovery point
I don't understand why are you not getting this
Yes, you are right, after set the two command, the recovery will stop at
that time.
But there is an other question, how to make this recovered Postgres can be
read and write? According to the manual, Postgres should be rename
recovery.conf to recovery.done, but it didn't.
I've tried pg_ctl
On Sat, Nov 24, 2012 at 6:00 AM, wd w...@wdicc.com wrote:
Yes, you are right, after set the two command, the recovery will stop at
that time.
But there is an other question, how to make this recovered Postgres can be
read and write? According to the manual, Postgres should be rename
On Sun, Nov 25, 2012 at 4:25 AM, Jeff Janes jeff.ja...@gmail.com wrote:
On Sat, Nov 24, 2012 at 6:00 AM, wd w...@wdicc.com wrote:
Yes, you are right, after set the two command, the recovery will stop at
that time.
But there is an other question, how to make this recovered Postgres can
On Fri, Nov 23, 2012 at 8:59 AM, wd w...@wdicc.com wrote:
Thanks for your reply, the logs are something like bellow,postgres will
restore every wal log I put in the xlog directory,and then continues
waiting for next wal log. The postgres version is 9.1.6.
[2012-11-22 18:49:24.175 CST
wd wrote:
I've try to restore Postgres to a specific time but failed.
The recovery.conf as bellow
restore_command='cp /t/xlog/%f %p'
recovery_target_time='2012-11-22 5:01:09 CST'
pause_at_recovery_target=true
recovery_target_inclusive=false
The basebackup was made at 2012-11-22 3:10 CST,
On Thu, Nov 22, 2012 at 7:29 PM, wd w...@wdicc.com wrote:
Thanks for your reply, the logs are something like bellow,postgres will
restore every wal log I put in the xlog directory,and then continues waiting
for next wal log. The postgres version is 9.1.6.
[2012-11-22 18:49:24.175 CST
hi,
I've try to restore Postgres to a specific time but failed.
The recovery.conf as bellow
restore_command='cp /t/xlog/%f %p'
recovery_target_time='2012-11-22 5:01:09 CST'
pause_at_recovery_target=true
recovery_target_inclusive=false
The basebackup was made at 2012-11-22 3:10 CST, I've copy
wd wrote:
I've try to restore Postgres to a specific time but failed.
The recovery.conf as bellow
restore_command='cp /t/xlog/%f %p'
recovery_target_time='2012-11-22 5:01:09 CST'
pause_at_recovery_target=true
recovery_target_inclusive=false
The basebackup was made at 2012-11-22 3:10
Thanks for your reply, the logs are something like bellow,postgres will
restore every wal log I put in the xlog directory,and then continues
waiting for next wal log. The postgres version is 9.1.6.
[2012-11-22 18:49:24.175 CST 25744 50ae0334.6490 1 0]LOG: database
system was shut down in
-Original Message-
From: Craig Ringer [mailto:ring...@ringerc.id.au]
Sent: 16 October 2012 21:27
To: Will Rutherdale (rutherw)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Does Postgres Object-Relational Syntax follow
Standard?
On 10/17/2012 05:00 AM, Will Rutherdale
From: Chris Travers [mailto:chris.trav...@gmail.com]
Sent: 16 October 2012 22:37
To: Will Rutherdale (rutherw)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Does Postgres Object-Relational Syntax follow Standard?
On Tue, Oct 16, 2012 at 2:00 PM, Will Rutherdale (rutherw) ruth
Hi.
I was having a discussion with people at work about the Postgres
object-relational syntax. The question came up: does this follow an SQL
standard? Or is it rather a Postgres-only feature with different RDBMSs doing
it differently?
I tried some quick checks on Google and Wikipedia but
On 10/17/2012 05:00 AM, Will Rutherdale (rutherw) wrote:
Hi.
I was having a discussion with people at work about the Postgres
object-relational syntax.
What syntax specifically? Do you mean table inheritance and SELECT ONLY ?
--
Craig Ringer
--
Sent via pgsql-general mailing list
On Tue, Oct 16, 2012 at 2:00 PM, Will Rutherdale (rutherw)
ruth...@cisco.com wrote:
Hi.
I was having a discussion with people at work about the Postgres
object-relational syntax. The question came up: does this follow an SQL
standard? Or is it rather a Postgres-only feature with
If I run this query:
select sum(length(html)) from Indexer.Pages;
I get:
15,680,005,116
However, if I type:
C:\Program Files\PostgreSQLdir /s
I get:
Total Files Listed:
5528 File(s) 7,414,385,333 bytes
575 Dir(s) 43,146,137,600 bytes free
So all the Postgres data on disk
On 05/23/2012 06:07 PM, Mike Christensen wrote:
If I run this query:
select sum(length(html)) from Indexer.Pages;
I get:
15,680,005,116
However, if I type:
C:\Program Files\PostgreSQLdir /s
I get:
Total Files Listed:
5528 File(s) 7,414,385,333 bytes
575 Dir(s)
Mike --
...
Is PG compressing this data? I'm curious as I was considering
converting this column to a byte array and gzip'ing the data to save
space, however if PG is already doing this for me, then I'm not going
to bother. Thanks!
Mike
It may vary from version of postgres to version, but
On Wed, May 23, 2012 at 6:16 PM, Greg Williamson
gwilliamso...@yahoo.com wrote:
Mike --
...
Is PG compressing this data? I'm curious as I was considering
converting this column to a byte array and gzip'ing the data to save
space, however if PG is already doing this for me, then I'm not
Somewhere along the line the install of one of my apps created a
userid named PostGres, I assume in connection with installing
the PostGres database manager.
Now I no longer have the option of having the system just boot up
into my own ID: I have to select my ID from a login screen that
displays
On Sun, Apr 29, 2012 at 9:43 AM, postg...@fatbelly.com wrote:
I'd like to drive a stake through this thing's heart. I know I
can do it via Control Panel | User Accounts | Delete the account.
The Question:
Am I going to regret doing this?
If you want to keep using Postgres, yes. Search
RE/
Am I going to regret doing this?
If you want to keep using Postgres, yes. Search the web
Suspicion.. *Confirmed*.
Thanks!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Can postgres be configure for GSS/Kerberos authentication without a keyfile?
I have Kerberos working
I compiled postgres with -with-gssapi
I've setup the pg_hba.conf with gss and my IP address
I'm not sure what to put in the postgres.conf
I can do a kinit
Eric,
* Eric.Kamradt (eric.kamr...@accessdevelopment.com) wrote:
Can postgres be configure for GSS/Kerberos authentication without a keyfile?
I'd say 'probably not'.
You have to have a princ for postgres and that princ needs to exist in a
keytab file on the PostgreSQL server. By default, the
Can postgres be configure for GSS/Kerberos authentication without a keyfile?
I have Kerberos working
I compiled postgres with -with-gssapi
I've setup the pg_hba.conf with gss and my IP address
I'm not sure what to put in the postgres.conf
I can do a kinit
Hello all,
Good day.
I have installed postgres 8.4 on ubuntu 11.10 desktop.My interest is to
test three web-based application.One is drupal7.the other two still working
on it.There should be possibility of data transaction between them.The two
web based will work with tomcat instances(port:8080)
Twaha Daudi wrote on 10.03.2012 10:32:
Hello all, Good day. I have installed postgres 8.4 on ubuntu 11.10
desktop.My interest is to test three web-based application.One is
drupal7.the other two still working on it.There should be possibility
of data transaction between them.The two web based
Thomas,
Thank for your response may put this way.
Hello all,
Good day.
I have the following scenario.
System 1:
Database: postgresql 8.4
application server: tomcat 6
System 2:
Database: Postgresql 8.4
Application Server: Tomcat 6:
These system to be able to exchange data.
Then I
hi List,
As a result of writing a C 'postgres' function, I have a memory
corruption problem. Something is either being free twice or I am
accessing beyond the data structure and corrupting the malloc/free/sbrk
memory pool.
My attempts to memory support in glibc, that been stopped because
Ok ive come a little further.
I changed the user to the administrator and now my output looks like this.
D:\Program Files\PostgreSQL\9.1\binpg_upgrade -d D:/Program
Files/PostgresPlus
/8.4SS/data -D D:/Program Files/PostgreSQL/9.1/data -b D:/Program
Files/Post
gresPlus/8.4SS/bin -B D:/Program
Hi guys,
i'm currently in the process of upgrading my 8.4SS version to a 9.1 version
of postgresql.
I am running it on a Windows 2003 Server machine.
The tool that I'm using is 'pg_upgrade'.
Both servers are stopped.
I have editet the pgpass.conf to include a line like this:
201 - 300 of 1052 matches
Mail list logo