In response to Wang, Mary Y :
> Thanks Andreas for the info. I'm working on a development server right now,
> and currently I don't have any data loaded yet. As matter of fact, I was
> trying to load the database data from a dump file that generated by
> "pg_dump".
> Here is the thing:
> I'v
Thanks Andreas for the info. I'm working on a development server right now,
and currently I don't have any data loaded yet. As matter of fact, I was
trying to load the database data from a dump file that generated by "pg_dump".
Here is the thing:
I've a /usr/bin/initdb -> this is probably fro
In response to Wang, Mary Y :
> Hi,
>
> I got this error:
> "-bash-2.05b$ /usr/local/pgsql/bin/pg_ctl start
> server starting
> -bash-2.05b$ FATAL: database files are incompatible with server
> DETAIL: The data directory was initialized by PostgreSQL version 7.3, which
> is not compatible with
Hi,
I got this error:
"-bash-2.05b$ /usr/local/pgsql/bin/pg_ctl start
server starting
-bash-2.05b$ FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 7.3, which is
not compatible with this version 8.3.8."
I think I must have two
Cool! That worked. Thanks. Now I just have to see if I can migrate the
database data from 7.1 to 8.3 successfully.
Mary
-Original Message-
From: Devrim GÜNDÜZ [mailto:dev...@gunduz.org]
Sent: Monday, February 22, 2010 11:43 PM
To: Wang, Mary Y
Cc: Joshua D. Drake; pgsql-general@postgr
I realize that this is a feature and not a bug, but what I ran into
confronting the same issue was the fact that the servers listen on
different ports and when I uninstalled the older version, the newer
version was listening on a non-standard port. This caused some
confusion for awhile.
The one-click installers are designed in such a way that you can have
different major versions of postgresql co-exist on the same machine.
Thats the reason, the 8.4.1 installer doesn't realize that 8.3 is even
installed.
On 2/26/10 12:56 AM, dtrobert wrote:
Hi,
We have tried this at least wi
Hiroshi Inoue wrote:
> Bruce Momjian wrote:
> > Where are we on this issue?
>
> Oops I forgot it completely.
> I have a little improved version and would post it tonight.
Ah, very good. Thanks.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://ente
Bruce Momjian wrote:
Where are we on this issue?
Oops I forgot it completely.
I have a little improved version and would post it tonight.
regards,
Hiroshi Inoue
---
Hiroshi Inoue wrote:
Tom Lane wrote:
Alvaro Herrera
Tom Lane wrote:
> Bruce Momjian writes:
> > Right, but you are saying it is still an open issue, which says we
> > should look at it.
>
> Sure. Maybe put it on TODO?
OK, TODO is:
Fix locale-aware handling (e.g. monetary) for specific
server/client encoding combinations
Bruce Momjian writes:
> Right, but you are saying it is still an open issue, which says we
> should look at it.
Sure. Maybe put it on TODO?
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
htt
Tom Lane wrote:
> Bruce Momjian writes:
> > Where are we on this issue?
>
> According to my files, I complained about the extreme ugliness of the
> patch (redefining strdup for pete's sake) and the fact that it did not
> actually do things anything like the LC_TIME code as was claimed.
> Hiroshi
Bruce Momjian writes:
> Where are we on this issue?
According to my files, I complained about the extreme ugliness of the
patch (redefining strdup for pete's sake) and the fact that it did not
actually do things anything like the LC_TIME code as was claimed.
Hiroshi rejected those criticisms. I
Where are we on this issue?
---
Hiroshi Inoue wrote:
> Tom Lane wrote:
> > Alvaro Herrera writes:
> >> Does this imply that we shouldn't allow UTF8 database on Windows at all?
> >
> > That would be pretty unfortunate :-(
>
Tom Lane wrote:
> Karl Nack writes:
> > I notice the row count does not reflect the newly-inserted row, which
> > suggests that the trigger is not seeing changes made to the table. This
> > seems to be exactly opposite of what's in the manual:
> > http://www.postgresql.org/docs/8.3/interactive/t
Hi,
We have tried this at least with Windows 2008 64-bit server and the problem
is very reproducible (multiple systems):
1. Install 8.3 on some non-C drive (say E:\)
2. Run the 8.4.1 installer to upgrade this install
> it appears that the 8.4.1 doesn't realize 8.3 is even installed
Result:
On Thu, Feb 25, 2010 at 12:56 PM, Andy Yoder wrote:
> Thanks Allan for the input - I guess I didn't specify enough details. I am
> looking for some type of tool/report that is already done. We have nearly
> 1000 tables, over 300 functions to look at a little over a day to provide the
> answer
Thanks Allan for the input - I guess I didn't specify enough details. I am
looking for some type of tool/report that is already done. We have nearly 1000
tables, over 300 functions to look at a little over a day to provide the
answers (all without dropping any other tasks, of course). I had c
Dominik Sander writes:
> I have an issue with a table partitioned by one boolean column. The
> query planner only seems to skip the non matching table if expired
> (the column I use for the partition) is true.
Hm, interesting case. The reason it's behaving asymmetrically is the
fix for this bug:
On Feb 24, 2010, at 5:10 PM, Tom Lane wrote:
Richard Huxton writes:
On 24/02/10 21:34, Tom Lane wrote:
Hmm. Jeff found some relevant material on perlref. Should that
link be
added? Should the link(s) be more specific than telling you to
read the
whole d*mn man page? Neither of those p
Greg Smith, 25.02.2010 17:47:
Based on tests showing a similar style and magnitude regression at Sun
by Jignesh Shah, I would assume this is mainly because some of the
starting parameter changes in 8.4 detuned this particular benchmark a
bit, in favor of proving a better default for real-world us
Thomas Kellerer wrote:
http://suckit.blog.hu/2009/09/29/postgresql_history
It would be interesting to know why the max. performance in the r/w
scenario for 8.4.1 is lower compared to 8.3.7 (and if maybe 8.4.2
fixed this)
Based on tests showing a similar style and magnitude regression at S
Does anyone know of a tool (or a way to use the database catalogs) that can
analyze function code/queries accessing the database to pull out a list of the
fields used in a set of tables. Basically we are importing a lot of data from
another source, and we are trying to determine what percentage
On Thu, Feb 25, 2010 at 08:22, Wappler, Robert wrote:
> Unfortunately, base_user inherits the connect privileges from role
> PUBLIC, regardless, whether it was created with NOINHERIT.
Yeah, IMO the documentation does not really spell out that limitation.
> How about changing the CREATEROLE privi
I don't have the root privileges. But I have followed the instructions
http://www.depesz.com/index.php/2008/11/28/recovering-lost-postgresql-password/
it worked out well.
Thanks for the suggestion
Regards
On Thu, Feb 25, 2010 at 10:21 AM, paragasu wrote:
> if you know the root password
>
> #s
Thank you. It worked
Regards
On Thu, Feb 25, 2010 at 10:18 AM, hubert depesz lubaczewski <
dep...@depesz.com> wrote:
> On Thu, Feb 25, 2010 at 10:15:55AM -0500, akp geek wrote:
> > Dear all -
> >
> > I forgot the password for the postgres user for the
> > database. Is there
On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe wrote:
> On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote:
>> Hello,
>>
>> I have an application that is doing something stupid in that it is
>> tacking on its own order clause at the end of the statement I am
>> providing.
>>
>> For example, I am putti
On 2010-02-25, Alex Hunsaker wrote:
> You could create a base role that does not have connect privileges on
> the other databases. Then just inherit from that role. Something
like:
> CREATE ROLE base_user; REVOKE CONNECT ON database from base_user; ...
>
> CREATE ROLE my_user inherit base_user
if you know the root password
#su root
#su postgres
#psql
#alter role with password
it think that should do
On Thu, Feb 25, 2010 at 11:15 PM, akp geek wrote:
> Dear all -
>
> I forgot the password for the postgres user for the
> database. Is there way I can reset the pa
> > 1) how do the clogs relate to wal shipping based replication? Clearly
> > the master doesn't need that clog but the slave does.
> >
> They should just be kept in sync. There's some useful background on
> this topic at
> http://old.nabble.com/control-the-number-of-clog-files-and-xlog-files
On Thu, Feb 25, 2010 at 10:15:55AM -0500, akp geek wrote:
> Dear all -
>
> I forgot the password for the postgres user for the
> database. Is there way I can reset the password to whatever I want. When I
> do the psql -U postgres , it's prompting me the password. Can you pleas
Dear all -
I forgot the password for the postgres user for the
database. Is there way I can reset the password to whatever I want. When I
do the psql -U postgres , it's prompting me the password. Can you please
help?
Regards
On Thu, Feb 25, 2010 at 01:26, Wappler, Robert wrote:
> Good Morning,
> is there a way to limit the CREATEROLE privilege to a specific database?
> I currently set up an automated integration test environment. This includes a
> database owned by a specific user which should have all degrees of free
Hi *,
I have encountered a problem while implementing an index structure. I don't
have any access to the RM (I don't know, how to set it up properly) using my
index. However, when I don't have the situation of working with a temporary
table, I need to put entries using XLogInsert(...). The probl
2010/2/25 Ivan Sergio Borgonovo :
> On Thu, 11 Feb 2010 20:11:54 +0100
> Ivan Sergio Borgonovo wrote:
>
>> I'm still having trouble making this work:
>>
>> http://pgsql.privatepaste.com/14a6d3075e
>
> I tried to play with
> item->operator.left
> to see if reshuffling the expression could make any
On Thu, 11 Feb 2010 20:11:54 +0100
Ivan Sergio Borgonovo wrote:
> I'm still having trouble making this work:
>
> http://pgsql.privatepaste.com/14a6d3075e
I tried to play with
item->operator.left
to see if reshuffling the expression could make any difference.
item->operator.left = 2 * lexeme - 2
In response to Shameem Ahamed :
> Hi,
>
> I want to create a global temp table in database, which can be
> accessed from any session to the database. Is it possible ?.
No.
>
> I tried with create global temp table , but the table created exist
> only in that specific session. No other session i
SELECT
COALESCE(r.name, ) AS name,
d.year_start AS year,
SUM(d.value * d_nom.value) / SUM(d_nom.value) AS value
FROM
pop_total_access_water AS d
RI
Hi,
I want to create a global temp table in database, which can be accessed from
any session to the database. Is it possible ?.
I tried with create global temp table , but the table created exist only in
that specific session. No other session is able to access the table.
How can i sort it out
On Thu, 25 Feb 2010 09:34:19 +0100, Stefan Schwarzer wrote:
> Hi there,
>
> I have tables with values for each country of the world.
>
> Now, there is the possibility for the user to generate regional
> (Europe, Africa...) or subregional (Western Europe, Central
> Europe...) aggregations on-the-f
On 2010-02-22, beulah prasanthi wrote:
> Helo
> I am working on spring project with postgres 8.4
> i wrote a function in postgrees which i am passing the
> argument email email[] array
> From front end we need to insesrt data into that emailarray
> .so i used java.arraylist.util
> while i am
Hi there,
I have tables with values for each country of the world.
Now, there is the possibility for the user to generate regional
(Europe, Africa...) or subregional (Western Europe, Central Europe...)
aggregations on-the-fly. In some cases, these aggregations need to be
calculated by usin
Greg Smith, 25.02.2010 03:13:
Martijn van Oosterhout wrote:
I remember a while back someone posted a graphs showing a scalability
of postgresql for various versions (I think 8.0 to 8.4). I've tried to
find this image again but havn't been able to locate it. Does anyone
here remember?
http://su
Good Morning,
is there a way to limit the CREATEROLE privilege to a specific database?
I currently set up an automated integration test environment. This includes a
database owned by a specific user which should have all degrees of freedom
for installing whatever database schemas are in the current
On Wed, Feb 24, 2010 at 09:13:36PM -0500, Greg Smith wrote:
> Martijn van Oosterhout wrote:
>> I remember a while back someone posted a graphs showing a scalability
>> of postgresql for various versions (I think 8.0 to 8.4). I've tried to
>> find this image again but havn't been able to locate it.
45 matches
Mail list logo
