The video archive for the 10/13 SFPUG meeting, "The Mighty GUCS: A
guide to the essential PostgreSQL settings you need to know," is now
available:
http://thebuild.com/blog/2009/10/16/the-mighty-gucs/
It's also available on Vimeo:
http://vimeo.com/7109722
--
-- Christophe Pet
Hmm would this be a bad time to ask for PostGres 1.0 support?
On Fri, Oct 16, 2009 at 1:55 PM, Jeff Davis wrote:
> On Fri, 2009-10-16 at 11:26 +0100, Neha Patel wrote:
>> We are running with postgres sql 7.3.2. We were trying to create an
>> index on a big table. The create index command ran for
On Oct 12, 2009, at 1:21 PM, Erik Jones wrote:
On Oct 9, 2009, at 9:57 AM, Takeichi Kanzaki Cabrera wrote:
Hi everybody, I need your help. I have a hierarchy of tables, and
other table that has a foreign key with the top table of the
hierarchy, can I insert a value into the "other" table where t
On Fri, Oct 16, 2009 at 10:04 AM, decibel wrote:
> Out of curiosity, did you look at doing hints as comments in a query? I'm
> guessing you couldn't actually do that in just a contrib module, but it's
> how Oracle handles hints, and it seems to be *much* more convenient, because
> a hint only appl
On Oct 16, 2009, at 4:51 PM, Scott Marlowe
wrote:
On Fri, Oct 16, 2009 at 11:25 AM, Kirk Wythers
wrote:
Any ideas what the problem could be here?
Use the pg_dump from the target (i.e. newer) pgsql. I.e. if going
from 8.3.8 to 8.4.1, use the pg_dump that comes with 8.4.1 to dump the
8.
Is this the right place to post this?
I set up the same characteristics on the console, and it runs fine, (COPY
commands will import back, right? That's what it output.)
On the console, it was:
pg_dump -vaF p -f dbase.sql -U user-name dbase-name
More details:
about 11 tables, practically e
2009/10/17 Tom Lane :
> If you decide to go with this approach and use PAM as intermediary,
> you'll need the patch I just committed in response to bug #5121 --- it
> turns out nobody had ever tried that with Postgres before :-(. But
> I think it's also possible to just use PG's native Kerberos su
"Scot Kreienkamp" writes:
> On 16/10/2009 19:38, Scot Kreienkamp wrote:
>> ... We are a largely Windows shop with many app and
>> database servers running Linux. The Linux environment is growing too
>> large not to do centralized authentication of some kind.
> So I guess what I see taking sha
On Fri, Oct 16, 2009 at 11:25 AM, Kirk Wythers wrote:
> Any ideas what the problem could be here?
Use the pg_dump from the target (i.e. newer) pgsql. I.e. if going
from 8.3.8 to 8.4.1, use the pg_dump that comes with 8.4.1 to dump the
8.3.8 database.
I usually just do it like so:
(First migra
On Fri, Oct 16, 2009 at 3:31 PM, marcin mank wrote:
> On Fri, Oct 16, 2009 at 9:19 PM, Peter Hunsberger
> wrote:
>
>> The basic problem I have is that I have some tables that are
>> potentially very long (100,000's to millions of rows) and very skinny,
>
>> and I end up with maybe a total of 12 b
On Fri, 2009-10-16 at 11:26 +0100, Neha Patel wrote:
> We are running with postgres sql 7.3.2. We were trying to create an
> index on a big table. The create index command ran for nearly 5 hours
> at which point we decided to interrupt it. Since this was interrupted,
> any operations attempted on t
On 16/10/2009 19:38, Scot Kreienkamp wrote:
> Hey everyone,
>
>
>
> I apologize in advance for going slightly off topic, but I have never
> setup a centralized authentication scheme under Linux. My question is,
> what do most people do for centralized command line, X, and PG
> authentication?
On Fri, 2009-10-16 at 12:04 -0500, decibel wrote:
> I'm guessing you couldn't actually do that in just a contrib module,
> but it's how Oracle handles hints, and it seems to be *much* more
> convenient, because a hint only applies for a specific query.
If that's the only reason, that seems eas
On Fri, Oct 16, 2009 at 9:19 PM, Peter Hunsberger
wrote:
> The basic problem I have is that I have some tables that are
> potentially very long (100,000's to millions of rows) and very skinny,
> and I end up with maybe a total of 12 bits of data in each row.
Are You aware that there are some 20
On Oct 16, 2009, at 10:04 AM, decibel wrote:
Out of curiosity, did you look at doing hints as comments in a query?
I don't think that a contrib module could change the grammar.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
On Oct 12, 2009, at 1:21 PM, Erik Jones wrote:
On Oct 9, 2009, at 9:57 AM, Takeichi Kanzaki Cabrera wrote:
Hi everybody, I need your help. I have a hierarchy of tables, and
other table that has a foreign key with the top table of the
hierarchy, can I insert a value into the "other" table where t
On Oct 6, 2009, at 2:57 PM, Oleg Bartunov wrote:
this is an announcement of our new contribution module for
PostgreSQL - Plantuner - enable planner hints
(http://www.sai.msu.su/~megera/wiki/plantuner).
=# set enable_seqscan=off;
=# set plantuner.forbid_index='id_idx2';
Out of curiosity, did
On 16/10/2009 19:38, Scot Kreienkamp wrote:
> Hey everyone,
>
>
>
> I apologize in advance for going slightly off topic, but I have never
> setup a centralized authentication scheme under Linux. My question
is,
> what do most people do for centralized command line, X, and PG
> authentication?
I just realized that my replies to my previous question on sparse
arrays went off list due to the way this list server is set up
(sigh). It has occurred to me that for my problem, one possible
solution is columnar indexes and that, in a way, partitioned tables in
Postgres might give me somewhat t
These are all RH4 and 5, so they do all have PAM. I thought PAM had to
interface with something else, which is where NIS and LDAP enter the
picture, to authenticate to another server though. Otherwise I'm not
sure how it works?
Thanks,
Scot Kreienkamp
skre...@la-z-boy.com
From: Scott
On Fri, Oct 16, 2009 at 2:38 PM, Scot Kreienkamp wrote:
> Hey everyone,
>
>
>
> I apologize in advance for going slightly off topic, but I have never setup
> a centralized authentication scheme under Linux. My question is, what do
> most people do for centralized command line, X, and PG authenti
Hey everyone,
I apologize in advance for going slightly off topic, but I have never
setup a centralized authentication scheme under Linux. My question is,
what do most people do for centralized command line, X, and PG
authentication? From what I've read the main choices are NIS or LDAP.
LDAP
2009/10/16 Kirk Wythers :
> I am trying to move databases to another macine (and update from 8.2 to 8.4
> along the way). I first tried pg_dumpall, but I found that one of the data
> bases did not restore and data, just an empty db with no tables. Since then
> I have tried pg_dump with the followin
I am trying to move databases to another macine (and update from 8.2
to 8.4 along the way). I first tried pg_dumpall, but I found that one
of the data bases did not restore and data, just an empty db with no
tables. Since then I have tried pg_dump with the following:
bash-3.2$ /usr/local/pg
Neha Patel wrote:
Hi,
We are running with postgres sql 7.3.2. We were trying to...
well, right off the bat, thats a -really- old version. Release notes
say February 2003. 7.3 was updated to 7.3.21, and we're currently on
8.4 (while still supporting 8.3, 8.2, 8.1, and 7.4).There
Hi David,
Many thanks for your reply. After good 10 hours of work we managed to
restore from a backup.
Regards
Neha>
-Original Message-
From: David Fetter [mailto:da...@fetter.org]
Sent: 16 October 2009 17:28
To: Neha Patel
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Urgen
On Fri, Oct 16, 2009 at 11:26:40AM +0100, Neha Patel wrote:
> Hi,
>
> We are running with postgres sql 7.3.2.
Whatever you thought your most urgent priority was, it's actually
getting your database off of a major version of PostgreSQL, 7.3, whose
end-of-life was well over a year ago.
Your secon
On Fri, Oct 16, 2009 at 11:26 AM, Neha Patel wrote:
> Hi,
>
>
>
> We are running with postgres sql 7.3.2. We were trying to create an index
> on a big table. The create index command ran for nearly 5 hours at which
> point we decided to interrupt it. Since this was interrupted, any
> operations
Tom Lane wrote:
> Viktor Rosenfeld writes:
> > I can't find the documentation of the ~=~ operator anywhere on the
> > PostgreSQL homepage.
>
> Which version's documentation are you reading? It's gone as of 8.4.
I realize that, but I have to use 8.3 right now and can't find it in
that manual ei
Hi,
We are running with postgres sql 7.3.2. We were trying to create an
index on a big table. The create index command ran for nearly 5 hours at
which point we decided to interrupt it. Since this was interrupted, any
operations attempted on the table on which the index was being created
gives fol
I would do this last query searching for the 0xC29F character WITHOUT the
upper() function on the source table, in the native (to table) UTF8 client
encoding. No result either?
Rob
2009/10/16 Arnaud Lesauvage
> Arnaud Lesauvage a écrit :
>
>> But then, if I dump it through a query to have my fi
2009/10/16 Tom Lane
> =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= writes:
> > Is there any reason, why I can't put quotes around name of savepoint, but
> I
> > have/can do this for prepare transaction ?
>
> Savepoint names are identifiers; the SQL spec says so. Prepared
> transaction GIDs are string l
Alban Hertroys writes:
> I'm also somewhat surprised to see an array of what appear to be
> integers be cast to bpchar[]. Did you define those coordinates(?) as
> character types? Numerical comparisons tend to be faster than string
> comparisons, which should make some difference on sequenti
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= writes:
> Is there any reason, why I can't put quotes around name of savepoint, but I
> have/can do this for prepare transaction ?
Savepoint names are identifiers; the SQL spec says so. Prepared
transaction GIDs are string literals. The relevant discussion
a
Arnaud Lesauvage a écrit :
But then, if I dump it through a query to have my field in uppercase, I
get an error 'character 0xc29f of encoding UTF8 has no equivalent in
WIN1252' (translated by myself, the message is in French)
The command is simply :
pgsql2shp -f myouput.shp -u postgres -g mygeo
On 16 Oct 2009, at 10:59, Christian Schröder wrote:
Hi list,
I have the following query:
SELECT *
FROM base
INNER JOIN pt USING (x) WHERE pt.y IN ('1121', '11411', '11421',
'1161', '1162');
"explain analyze" yields the following result:
Is there any reason, why I can't put quotes around name of savepoint, but I
have/can do this for prepare transaction ?
Ie:
SAVEPOINT 'foo'; --- doesn't work
SAVEPOINT foo; --- all grand
PREPARE TRANSACTION 'foo'; --- grand
PREPARE TRANSACTION foo; refuses to work.
It is quite confusing, I feel l
Raymond O'Donnell a écrit :
If it's any help to you, you can get iconv (and a bunch of other helpful
stuff) from GnuWin32:
http://gnuwin32.sourceforge.net/
Thanks for your help Raymond.
I tried iconv but I have other problems now.
I still have to load the file into postgresql because the sh
Does that last query (invoking the upper() function) actually run well when
executed in pgsql console?
Rob
2009/10/16 Arnaud Lesauvage
> Hi all!
>
> I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled
> database. I want my shapefile to be encoded in WIN1252, and a particular
>
On 16/10/2009 10:36, Arnaud Lesauvage wrote:
> I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled
> database. I want my shapefile to be encoded in WIN1252, and a particular
> field to be in uppercase.
>
> Since I am on windows, I don't have an iconv executable. Therefore, I am
Hi all!
I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled
database. I want my shapefile to be encoded in WIN1252, and a particular
field to be in uppercase.
Since I am on windows, I don't have an iconv executable. Therefore, I am
trying to :
- dump the shapefile with shp
Hi list,
I have the following query:
SELECT *
FROM base
INNER JOIN pt USING (x) WHERE pt.y IN ('1121', '11411', '11421',
'1161', '1162');
"explain analyze" yields the following result:
QUERY PLAN
-
42 matches
Mail list logo
