I love Postgresql to death, it's one of the shining stars of the Open Source
movement IMHO. It's rock solid, crashes less frequently than Oracle in my
experience, and does almost everything I could ask of it (granted - I don't
ask much often, just simple things like consistent behaviour, which see
On Friday 18 January 2008 14:38, Steve Clark wrote:
> Thanks for everyone that replied to my query about pg_dumpall.
>
>
> Now another question/issue - anytime I usr createdb the resulting db
> ends up
> with UTF-8 encoding unless I use the -E switch. Is there a way to make
> the
> default be sql_a
On Jan 19, 2008 6:46 PM, Gordan Bobic <[EMAIL PROTECTED]> wrote:
> Existing solutions can't handle multiple masters. MySQL can do it at
> least in a ring arrangement.
mysql multi-master replication looks a lot better on paper than it
really is...one of the reasons mysql is able to seemingly provid
Hi everyone,
Have you seen PostgreSQL terminated abnormally with "signal 66" ?
I'm using PostgreSQL 8.1.4 on Windows XP SP2.
autovacuum process aborted with "signal 66", and "startup process"
aborted also.
-
2008-01-18 10:04:56 892 LOCATION: AutoVacMain, autovacuum.c:412
2008-01-18 10:05:5
Thanks Alvaro
iconv -f iso-8859-1 -t utf-8 es_ES.dict > es.dict
works!!
--- Alvaro Herrera <[EMAIL PROTECTED]>
escribió:
> marcelo Cortez escribió:
>
> > i've tried too with
> > convmv -f iso-8859-1 --notest -t utf-8
> es_ES.dic
> > whitout success too.
>
> convmv only recodes the n
On Sun, 20 Jan 2008, Tom Lane wrote:
Greg Smith <[EMAIL PROTECTED]> writes:
It is a beta and
there's already a known issue that will cause later 8.3 releases to use a
different internal database format,
Uh ... known to whom?
I thought there was a catalog rev bump in RC2 that was going to fo
Hello,
The first thing which should be checked on Vista - correct file access
permissions. Did you create postgres.conf yourself?
Niederland wrote:
This seems to be an installer bug for VISTA
If I run postgres via the command prompt with:
postgres -D ../data
then the postgres.conf file is lo
marcelo Cortez escribió:
> i've tried too with
> convmv -f iso-8859-1 --notest -t utf-8 es_ES.dic
> whitout success too.
convmv only recodes the name of the file -- the content is not affected.
To recode the file content you need iconv.
--
Alvaro Herrerahtt
Teodor
i've tried with openoffice.org but whitout success,
:)
ERROR: invalid byte sequence for encoding "UTF8":
0xe16261
HINT: This error can also happen if the byte sequence
does not match the encoding expected by the server,
i've tried too with
convmv -f iso-8859-1 --notest -t utf-8
Greg Smith <[EMAIL PROTECTED]> writes:
> Also, as someone already mentioned, you will be forced at some point to
> trash whatever database install you do with 8.3rc1. It is a beta and
> there's already a known issue that will cause later 8.3 releases to use a
> different internal database forma
Thanks Teodor
for quick response,and your work
> That's right, but you should convert dictionary and
> affix file in UTF8 encoding.
how to i can do it?
best regards
MDC
Yahoo! Encuentros.
Ahora encontrar pareja es mucho más fácil, probá el nuevo Yahoo! Encuentros
http://y
flag *J:# isimo
E> -E, 'ISIMO # grand'isimo <-- here 432
E > -E, 'ISIMOS # grande grand'isimos
E > -E, 'ISIMA# grande grand'isima
E > -E, 'ISIMAS # grande grand'isimas
O > -O, 'ISIMO# tonto tont'isimo
O > -O, 'ISIMA# tonto tont'isima
hi folks
i've tried to install ispell for
CREATE TEXT SEARCH DICTIONARY spanish_ispell (
TEMPLATE = ispell,
DictFile = spanish,
AffFile = spanish,
StopWords = spanish
);
sentence, but, one error ocurrs
ERROR: syntax error at line 432 of affix file
"/usr/local/pgsql/share/ts
On Sun, 20 Jan 2008, Sebastjan Trepca wrote:
we are spotting constant deadlocks when altering tables.
See http://www.postgresql.org/docs/8.2/interactive/explicit-locking.html
for information about the ACCESS EXCLUSIVE lock that ALTER TABLE takes.
Anything that is doing that needs to be in as
On Fri, 18 Jan 2008, Jon Hancock wrote:
I am a fairly new user of postgres and am starting with the very latest
8.3rc1. I need to figure out the pros/cons of compiling from the source
of postgres.org or the install package from enterprisedb.
If you like their packaging, by all means use it to
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> I thought I could write something like
> create or replace testA(out setof record) as...
> but it seems I can't.
No, you can't. Write
create or replace testA() returns setof record as...
instead. "setof" is only allowed in the RETURNS clause
On Fri, 18 Jan 2008, Jon Hancock wrote:
I get to the 4th step and see I need gmake. I use make instead.
If you look at your make you'll probably find this:
[EMAIL PROTECTED]:~$ make -v
GNU Make 3.81
The standard Ubuntu make is gmake, just isn't named that way by them.
The bin directory is
Hi,
we are spotting constant deadlocks when altering tables. After I
restart the db the ALTER TABLE command runs without problems, but
when I try to alter some other table later on it deadlocks again. If I
kill the process that handles ALTER TABLE the deadlock is "unlocked",
but ALTER TABLE still
I've already read this
http://people.planetpostgresql.org/xzilla/index.php?/archives/149-out-parameter-sql-plpgsql-examples.html#extended
but I still can't get it clear.
I thought I could write something like
create or replace testA(out setof record) as...
but it seems I can't. Or am I missing
On 20/01/2008, Greg Sabino Mullane <[EMAIL PROTECTED]> wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
>
> >> dont forget MySQL also has support for simple commands such as
> >> show databases
> > Type: \d
> >> show tables
> > Type: \l
> >
> > Not sure how it could be any simpler.
Sim Zacks wrote:
> I'm a fan of unsecured languages in the database.
> Obviously they should only be used by people who understand the difference.
> I wouldn't want python locked down.
> That would prevent so many different external functions that can now
> be integrated into the database.
>
> Amon
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 20 Jan 2008 19:08:37 +0100
Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> Type: \copyright for distribution terms
>\h for help with SQL commands
>\? for help with psql commands
>\g or terminate with semicolon to
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> A random thought: Is there not some way of representing this difference
> in the planner?
It's not so much that we have no way to represent the ordering, as that
the planner currently doesn't have any place in its conceptual model for
costs incu
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane escribió:
>> In the long run, for queries inserting many rows it might be interesting
>> to accumulate all the entries intended for a btree index and sort them
>> before inserting. Not sure about possible downsides of that.
> Yeah, in the long
Russell Smith <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> A possibly usable workaround for now is "set enable_hashagg = off"
>> to force a GroupAggregate plan, which will deliver the values sorted
>> by (data, usuario) rather than by their hash values.
> If you add ORDER BY to the query, do y
On Sun, Jan 20, 2008 at 05:54:01PM -, Greg Sabino Mullane wrote:
> Simpler, no, but it could be a lot more intuitive. I think having
> psql recognize /^help/i would be a nice first step. Hmm, off to
> write a quick patch...
When you start psql you get the nice message:
---
Welcome to psql 8.
On Sun, 20 Jan 2008 17:54:01 -
"Greg Sabino Mullane" <[EMAIL PROTECTED]> wrote:
> > Not sure how it could be any simpler...
>
> Simpler, no, but it could be a lot more intuitive. I think having
> psql recognize /^help/i would be a nice first step. Hmm, off to
> write a quick patch...
+1
J
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> dont forget MySQL also has support for simple commands such as
>> show databases
> Type: \d
>> show tables
> Type: \l
>
> Not sure how it could be any simpler...
Simpler, no, but it could be a lot more intuitive. I think having
psql recogni
Hello
>
> support for compiling and execution of Procedures in Postgres is nonexistent
> 99% of SQL code in either Oracle and MySQL DB's are written in
> Procedures..trying to port that to Postgres is a very long and tedious
> uphill climb
>
true compilation is necessary only for some cases (note
On Fri, 18 Jan 2008 01:28:38 -0800 (PST)
Jon Hancock <[EMAIL PROTECTED]> wrote:
> I am a fairly new user of postgres and am starting with the very
> latest 8.3rc1.
>
> I need to figure out the pros/cons of compiling from the source of
> postgres.org or the install package from enterprisedb.
You
On Sun, 20 Jan 2008 17:46:19 +0100
Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> > support for compiling and execution of Procedures in Postgres is
> > nonexistent 99% of SQL code in either Oracle and MySQL DB's are
> > written in Procedures..trying to port that to Postgres is a very
> > lon
On Sun, Jan 20, 2008 at 11:33:43AM -0500, Martin Gainty wrote:
> dont forget MySQL also has support for simple commands such as
> show databases
Type: \d
> show tables
Type: \l
Not sure how it could be any simpler...
> support for compiling and execution of Procedures in Postgres is nonexistent
>
On Sun, Jan 20, 2008 at 12:21:01AM -0800, Jon Hancock wrote:
> I am trying to port a MySQL db to postgres 8.3rc1.
> In MySQL I have a function SHA1, which is critical for storing and
> authenticating passwords.
> I see some old posts on how to add this function myself. see:
> http://raveica.comdur
Good Morning Walter
dont forget MySQL also has support for simple commands such as
show databases
show tables
support for compiling and execution of Procedures in Postgres is nonexistent
99% of SQL code in either Oracle and MySQL DB's are written in
Procedures..trying to port that to Postgres is
On Fri, Jan 18, 2008 at 01:28:38AM -0800, Jon Hancock wrote:
> I am a fairly new user of postgres and am starting with the very
> latest 8.3rc1.
>
> I need to figure out the pros/cons of compiling from the source of
> postgres.org or the install package from enterprisedb.
>
> My production target
Tom Lane escribió:
> In the long run, for queries inserting many rows it might be interesting
> to accumulate all the entries intended for a btree index and sort them
> before inserting. Not sure about possible downsides of that.
Yeah, in the long run we need a more flexible approach towards ind
> The INSTALL file for postgresql 8.3rc1 lists the following install
> instructions:
>
> ./configure
> gmake
> su
> gmake install
> adduser postgres
> mkdir /usr/local/pgsql/data
> chown postgres /usr/local/pgsql/data
> su - postgres
> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
> /usr/loc
On Jan 15, 2008 6:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>>Luca Arzeni <[EMAIL PROTECTED]> writes:
>> That is: the sort order in postgres 8.1.9 seems to ignore the blank.
>
>This is expected behavior in most non-C locales.
>Try "initdb --locale=C".
>
On Jan 15, 2008 6:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Luca Arzeni <[EMAIL PROTECTED]> writes:
> > That is: the sort order in postgres 8.1.9 seems to ignore the blank.
>
> This is expected behavior in most non-C locales.
>
> > In all cases I'm using locale LATIN9 during DB creation, but I
Here's more information: It appears that the postgresql.conf file is
not being used...
executing a show all; from psql
I see that the parameters are using the default values and not paying
attention to the settings in the postgresql.conf file.
The config_file has a value of c:/program files/Post
Terabytes of data: this is a lot of Oracle data to migrate. You would
need a high performance tools capable to handle heterogeneous
environment
People suggested links here, so I will add some that could be very
appropriate to your case:
PostgreSQL loader is limited by the way. For instance, if you
I am a fairly new user of postgres and am starting with the very
latest 8.3rc1.
I need to figure out the pros/cons of compiling from the source of
postgres.org or the install package from enterprisedb.
My production target is AMD64 on ubuntu 7.04.
My test and staging target is 32 bit ubuntu 7.04
On my laptop which I use for development (Windows VISTA), I tried
Postgresql 8.3 RC1. I ran into one problem... It seems that either
the service is not finding the postgresql.conf file or not paying
attention to the search_path within it. This worked in all the
previous 8.2.x, 8.1.x I've used.
I
> > IsMySQLa direct competitor to Oracle? For the people who usemysql,
> > mostly smaller websites, oracle is not a realistic option.
>
> Smaller? Did you mean Larger?
>
I think what I mean is less mission critical. I have never heard of a
bank using MySQL as their main database system.
My poin
I am trying to port a MySQL db to postgres 8.3rc1.
In MySQL I have a function SHA1, which is critical for storing and
authenticating passwords.
I see some old posts on how to add this function myself. see:
http://raveica.comdurav.com/blog/programming/how-do-i-add-sha1-to-postgresql/
Has sha1 been
On Sat, 2008-01-19 at 23:46 +, Gordan Bobic wrote:
> David Fetter wrote:
>
> > In that case, use one of the existing solutions. They're all way
> > easier than re-inventing the wheel.
>
> Existing solutions can't handle multiple masters. MySQL can do it at
> least in a ring arrangement.
>
The INSTALL file for postgresql 8.3rc1 lists the following install
instructions:
./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postgres -D
This seems to be an installer bug for VISTA
If I run postgres via the command prompt with:
postgres -D ../data
then the postgres.conf file is loaded as confirmed with a show all in
psql
If I start postgres via the service which is installed with installer
the postgres.conf file values are not loa
On Jan 20, 2008 6:44 AM, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> On Sun, Jan 20, 2008 at 09:29:16AM -0200, Clodoaldo wrote:
> > Will "enable_hashagg" be settable(*) per query or only at server
> > start/reload?
>
> The enable_* settings are per session, so you can disable hashagg just
On Sun, Jan 20, 2008 at 09:29:16AM -0200, Clodoaldo wrote:
> Will "enable_hashagg" be settable(*) per query or only at server start/reload?
The enable_* settings are per session, so you can disable hashagg just
before the query and reenable it just after, or disable it for just
that process/user/d
On Sun, 20 Jan 2008 09:30:11 +0200
Sim Zacks <[EMAIL PROTECTED]> wrote:
> I've found that multiple simple statements often work faster then
> convoluted single statements.
I don't want to steal any further time to anyone considering my
interest now is just academic since I can't handle any more
i
2008/1/20, Tom Lane <[EMAIL PROTECTED]>:
> Clodoaldo <[EMAIL PROTECTED]> writes:
> > 2008/1/16, Tom Lane <[EMAIL PROTECTED]>:
> >> I don't know of any reason to think that insertion is slower in 8.3
> >> than it was in 8.2, and no one else has reported anything of the sort.
>
> > The old server rep
On Sat, Jan 19, 2008 at 10:33:00PM -0500, Tom Lane wrote:
> The difference comes from the fact that the HashAggregate step --- which
> is being done on hashing columns (data, usuario) --- is effectively
> reading out in hash-value order for usuario, meaning that that is the
> order in which we make
On Sat, 2008-01-19 at 13:53 -0600, Erik Jones wrote:
> Here's the python script I was using to ship to both servers, right
> now I'm back to a direct rsync call for my archive_command to sb1.
> What's really weird, is that for the two WALs that disappeared, or
> didn't make it, even though
On Sat, 2008-01-19 at 13:53 -0600, Erik Jones wrote:
> > Is the History table Insert only? We might use that fact to examine
> > the
> > LSNs of the equivalent blocks on the Primary. If the LSNs are prior to
> > the start of the recovery, as noted in the backup label file of the
> > original bas
55 matches
Mail list logo
