Good morning,
My daily data population cronjob(around 1 hour) terminated at the middle
and raised the following error this morning:
Connection rejected: FATAL: Ident authentication failed for user
"schema_owner_name".
Could anyone tell me what might cause the problem please?
Thanks a lot!
On Wed, Apr 22, 2009 at 2:36 PM, Emi Lu wrote:
> Good morning,
>
> My daily data population cronjob(around 1 hour) terminated at the middle and
> raised the following error this morning:
>
> Connection rejected: FATAL: Ident authentication failed for user
> "schema_owner_name".
>
> Could anyone te
Check your pg_hba.conf file. What does it look like? The message suggests that
your job is trying to connect to the database as the user "schema_owner_name"
(or whatever the real user name is), but is actually running as a different
unix user. Also, did anyone change the unix user running this
Alvaro Herrera wrote:
Try TRUNCATE. That leaves the less garbage behind and takes the less
time.
A follow up question, as far as I understand it, delete removes entries
in the fsm, so vacuum has to clean it all up when performing a delete,
is this approximately correct? what happens with tru
I set log_min_duration_statement to 1 and restart the postgres. But when
i check the tail to log i am getting all queries. please tell is it bug ?
i have log_statement = all . is there any relation between this and
min_duaration?
Arvind S
*
"Many of lifes failure are people who did not realiz
On Wed, Apr 22, 2009 at 9:16 AM, S Arvind wrote:
> I set log_min_duration_statement to 1 and restart the postgres. But
> when
> i check the tail to log i am getting all queries. please tell is it bug ?
> i have log_statement = all . is there any relation between this and
> min_duaration?
I
In response to S Arvind :
> I set log_min_duration_statement to 1 and restart the postgres. But when
> i check the tail to log i am getting all queries. please tell is it bug ?
> i have log_statement = all . is there any relation between this and
> min_duaration?
log_statement = all loggs _all
Dear members of the list,
I have a function which returns a custom type, that has only two fields,
each of them being varchar arrays.
The reason that I have written this function is that I have a table
basically with the following structure (with simplified column names)
name_col1 name_col2 se
If I have built a dynamic sql statement in a function, how do i return it
as a ref cursor?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Our company wants to move from 8,1 to 8.3 latest. In irc they told me to
check realse notes for issues while upgrading. But there are lots of release
notesss. Can anyone tell some most noticable change or place-of-error while
upgrading?
Arvind S
*
"Many of lifes failure are people who did not rea
S Arvind escribió:
> Our company wants to move from 8,1 to 8.3 latest. In irc they told me to
> check realse notes for issues while upgrading. But there are lots of release
> notesss. Can anyone tell some most noticable change or place-of-error while
> upgrading?
If you're too lazy to read them, w
On Wed, 2009-04-22 at 22:12 +0530, S Arvind wrote:
> Our company wants to move from 8,1 to 8.3 latest. In irc they told me
> to check realse notes for issues while upgrading. But there are lots
> of release notesss. Can anyone tell some most noticable change or
> place-of-error while upgrading?
on
On Wed, 2009-04-22 at 12:49 -0400, Alvaro Herrera wrote:
> S Arvind escribió:
> > Our company wants to move from 8,1 to 8.3 latest. In irc they told me to
> > check realse notes for issues while upgrading. But there are lots of release
> > notesss. Can anyone tell some most noticable change or plac
When trying to upgrade Postgres I got this message:
The existing data directory (Date/time settings: floating -point
numbers) is not compatible with this server (Date/Time setting:
64-bit integers)
I saw a few posts about this but I'm still not sure how to fix it. I
think one of them said I
On 22/04/2009 16:57, Christine Penner wrote:
> The existing data directory (Date/time settings: floating -point
> numbers) is not compatible with this server (Date/Time setting: 64-bit
> integers)
>
> I saw a few posts about this but I'm still not sure how to fix it. I
> think one of them said I
On Wed, 2009-04-22 at 18:09 +0100, Raymond O'Donnell wrote:
> On 22/04/2009 16:57, Christine Penner wrote:
>
> > The existing data directory (Date/time settings: floating -point
> > numbers) is not compatible with this server (Date/Time setting: 64-bit
> > integers)
> >
> > I saw a few posts abou
I am upgrading from 8.3.4 to 8.3.7. That's why I'm confused. The
notes said I wouldn't have to do that. 8.3.4 was the original install.
Christine
At 10:09 AM 22/04/2009, you wrote:
On 22/04/2009 16:57, Christine Penner wrote:
> The existing data directory (Date/time settings: floating -point
On 22/04/2009 18:12, Joshua D. Drake wrote:
> On Wed, 2009-04-22 at 18:09 +0100, Raymond O'Donnell wrote:
>> It sounds as if you're trying to get a later-version server to use an
>> earlier-version data directory - this won't work.
>
> Actually the error is about whether or not the server was com
On Wed, Apr 22, 2009 at 7:36 AM, Emi Lu wrote:
> Good morning,
>
> My daily data population cronjob(around 1 hour) terminated at the middle and
> raised the following error this morning:
>
> Connection rejected: FATAL: Ident authentication failed for user
> "schema_owner_name".
>
> Could anyone te
Could someone reply to this email? I am testing my subscription; joined over 2
months ago, but never get any response to questions
Thanks!
Atul
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joshua D. Drake
Sent: We
On Wed, Apr 22, 2009 at 2:13 AM, Alvaro Herrera
wrote:
> Ouch ... I thought that was the way that Windows designated UTF8
> locales, but maybe I am wrong.
Ok, now I found out that Windows doesn't support locales with encoding
using more than two bytes per character and initdb falls back to 1252.
On 22/04/2009 18:21, Atul Chojar wrote:
> Could someone reply to this email? I am testing my subscription;
> joined over 2 months ago, but never get any response to questions
Receiving you loud and clear!
Ray.
--
Raymond O'Donnell,
Windows XP pro. I went to the postgres web site, downloads, clicked
on the binary package and selected windows. It gave me a file called
Postgresql-8.3.7-1-windows.exe
When I run that I hit next for the postgres directory, then after
hitting next for the data directory I get the error. I kept
On Wed, 2009-04-22 at 10:31 -0700, Christine Penner wrote:
> Windows XP pro. I went to the postgres web site, downloads, clicked
> on the binary package and selected windows. It gave me a file called
> Postgresql-8.3.7-1-windows.exe
>
> When I run that I hit next for the postgres directory, then
On Wed, 2009-04-22 at 10:13 -0700, Christine Penner wrote:
> I am upgrading from 8.3.4 to 8.3.7. That's why I'm confused. The
> notes said I wouldn't have to do that. 8.3.4 was the original install.
What OS are you running? How did you go about upgrading?
Debian/Ubuntu will use --integer-datetim
Coming loud and clear !
joao
On Wed, 2009-04-22 at 13:21 -0400, Atul Chojar wrote:
> Could someone reply to this email? I am testing my subscription; joined over
> 2 months ago, but never get any response to questions
>
> Thanks!
> Atul
>
>
>
> -Original Message-
> From: pgsql-gen
Mikko escribió:
> On Wed, Apr 22, 2009 at 2:13 AM, Alvaro Herrera
> wrote:
> > Ouch ... I thought that was the way that Windows designated UTF8
> > locales, but maybe I am wrong.
>
> Ok, now I found out that Windows doesn't support locales with encoding
> using more than two bytes per character a
Joshua D. Drake wrote on 22.04.2009 19:34:
Huh, I wonder when the windows package changed its defaults.
Could it be that Christine initially installed the pginstaller version, and now
downloaded the EnterpriseDB installer? And EnterpriseDB compiles with a
different default setting?
As far a
On 22/04/2009 19:00, Thomas Kellerer wrote:
> Could it be that Christine initially installed the pginstaller version,
> and now downloaded the EnterpriseDB installer? And EnterpriseDB compiles
> with a different default setting?
>
> As far as I recall the .exe is the EnterpriseDB One-Click-Instal
It was a zip file with an msi installer in it. I tried to find a
similar one for the update but all I could find was the one click installer.
Christine
At 11:00 AM 22/04/2009, you wrote:
Joshua D. Drake wrote on 22.04.2009 19:34:
Huh, I wonder when the windows package changed its defaults.
Christine Penner writes:
> Windows XP pro. I went to the postgres web site, downloads, clicked
> on the binary package and selected windows. It gave me a file called
> Postgresql-8.3.7-1-windows.exe
There are different people distributing Postgres-for-Windows with
different build options. You
"Joshua D. Drake" writes:
> RedHat/Cent/Fedora has long used the incorrect default of floating based
> timestamps.
Josh, you're being extremely unhelpful by presenting the problem in
this narrow minded "correct" vs "incorrect" way.
I'm going to go on the record now that if Bruce gets pg_migrator
On 22/04/2009 19:05, Christine Penner wrote:
> It was a zip file with an msi installer in it. I tried to find a similar
> one for the update but all I could find was the one click installer.
The initial installation sounds like it was the pgInstaller, so. It
would be worth trying again with the sa
Thanks to everyone who replied to the test email!
Now for my real question:-
We are facing a strange problem in our 8.2.7 database.
There is a bash shell script that does:-
sql=”select distinct to_char(date_of_issue, ‘MM’) from
yan.int_prod_s_master order by 1;”
MM=`/usr/local/pgsql/bi
The link below takes me to the same place I got this installer I'm
having problems with. I am pretty sure I got the original installer
from the Postgres web site just like I just did.
Christine
At 11:14 AM 22/04/2009, you wrote:
On 22/04/2009 19:05, Christine Penner wrote:
> It was a zip file
Tom Lane wrote:
> "Joshua D. Drake" writes:
> > RedHat/Cent/Fedora has long used the incorrect default of floating based
> > timestamps.
>
> Josh, you're being extremely unhelpful by presenting the problem in
> this narrow minded "correct" vs "incorrect" way.
>
> I'm going to go on the record no
On 22/04/2009 19:21, Christine Penner wrote:
> The link below takes me to the same place I got this installer I'm
> having problems with. I am pretty sure I got the original installer from
Well, there are two installers listed there (at least, that's what I see):
* One-click installer, on Enterpr
Looks like that's the one I got last time. They must have had that
one list on the main download page when I did the original install. I
wouldn't have looked in the ftp section.
Also when I looked in the ftp section earlier today, I skipped the
binary stuff because the one click installer I go
Alvaro Herrera writes:
> Does this imply that we shouldn't allow UTF8 database on Windows at all?
That would be pretty unfortunate :-(
I think what this suggests is that there probably needs to be some
encoding conversion logic near the places we examine localeconv()
output.
Raymond O'Donnell wrote on 22.04.2009 20:14:
On 22/04/2009 19:05, Christine Penner wrote:
It was a zip file with an msi installer in it. I tried to find a similar
one for the update but all I could find was the one click installer.
The initial installation sounds like it was the pgInstaller, s
On Wed, Apr 22, 2009 at 12:29 PM, wrote:
> If I have built a dynamic sql statement in a function, how do i return it
> as a ref cursor?
CREATE FUNCTION reffunc(_ref) RETURNS refcursor AS
$$
BEGIN
OPEN _ref FOR execute 'SELECT * from foo';
RETURN _ref;
END;
$$ LANGUAGE plpgsql;
BEGIN;
SE
Bruce Momjian wrote on 22.04.2009 20:26:
Yes, I can confirm I think pg_migrator will work for 8.3->8.4 upgrades;
I start testing this week.
This is pretty good news, cool.
Will there be Windows binaries for the pg_migrator once that 8.4 ships?
Thomas
--
Sent via pgsql-general mailing list
n Wed, Apr 22, 2009 at 2:54 PM, Merlin Moncure wrote:
> On Wed, Apr 22, 2009 at 12:29 PM, wrote:
>> If I have built a dynamic sql statement in a function, how do i return it
>> as a ref cursor?
>
> CREATE FUNCTION reffunc(_ref) RETURNS refcursor AS
oops
CREATE FUNCTION reffunc(_ref refcursor)
On Wed, Apr 22, 2009 at 7:54 PM, Thomas Kellerer wrote:
> I still wonder why the one-click installer is so much more prominent than
> the pginstaller.
Because it was designed to remove many of the complexities of the MSI
installer that most users don't need and many don't understand if
they're n
Thomas Kellerer wrote:
> Bruce Momjian wrote on 22.04.2009 20:26:
> > Yes, I can confirm I think pg_migrator will work for 8.3->8.4 upgrades;
> > I start testing this week.
> >
> This is pretty good news, cool.
>
> Will there be Windows binaries for the pg_migrator once that 8.4 ships?
Uh, no i
2009/4/22 Atul Chojar
>
> We are facing a strange problem in our 8.2.7 database.
>
> There is a bash shell script that does:-
>
> sql=”select distinct to_char(date_of_issue, ‘MM’) from
> yan.int_prod_s_master order by 1;”
> MM=`/usr/local/pgsql/bin/psql -U postgres -h payday -d sandbox -t
2009/4/22 sarikan
>
> Dear members of the list,
> I have a function which returns a custom type, that has only two fields,
> each of them being varchar arrays.
> The reason that I have written this function is that I have a table
> basically with the following structure (with simplified column na
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 :-(
>
> I think what this suggests is that there probably needs to be some
> encoding conversion logic near the places we examine localeconv()
when i try to copy database (into another database), i get "relation
does not exist" errors for 'super objects' like sequences. (that is
fine since i am using pg_dump, not pg_dumpall) but there is one
relation i can't find to recreate in the new database.
how can i search database for relation by
Here is the sql
SELECT c.oid,
n.nspname,
c.relname
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relname LIKE ('%dt%')
AND pg_catalog.pg_table_is_visible(c.oid)
replace dt with your sequence name
pg_catalog has the information.
Thank
On Apr 22, 2009, at 8:04 AM, Thomas Finneid wrote:
Alvaro Herrera wrote:
Try TRUNCATE. That leaves the less garbage behind and takes the less
time.
A follow up question, as far as I understand it, delete removes
entries in the fsm, so vacuum has to clean it all up when performing
a delet
Hi Filip,
First of all: thanks a lot for your kind response. Here is the create script
for my schema:
CREATE TABLE "app"."archetype_data" (
"id" BIGINT NOT NULL,
"context_id" VARCHAR(1000),
"archetype_name" VARCHAR(1000),
"archetype_path" VARCHAR(1000),
"name" VARCHAR(1000),
"value_str
how to revoke multiple users permission from multiple tables at the same
time?
Or in simple is there a way to revoke multiple users grant access from
multiple tables under a schema.?
I use Revoke below command to execute on each table one by one.
revoke SELECT/ALL on testtable from user1;
Thanks
you keep everything in varchars, and yet you request improvements in
performance.
you are a funny guy, ...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Apr 22, 2009 at 4:19 PM, DM wrote:
> how to revoke multiple users permission from multiple tables at the same
> time?
> Or in simple is there a way to revoke multiple users grant access from
> multiple tables under a schema.?
Best way is to NOT grant multiple users permissions, but to gra
Hi there,
I have a set of dynamically composed objects represented in Java, with
string values for various attributes, which have variable length. In case
you have suggestions for a better type for this case, it would be my
pleasure to hear about them.
2009/4/22 Grzegorz Jaśkiewicz
> you keep ev
On Wed, Apr 22, 2009 at 5:01 PM, Scott Marlowe wrote:
> On Wed, Apr 22, 2009 at 4:19 PM, DM wrote:
>> how to revoke multiple users permission from multiple tables at the same
>> time?
>> Or in simple is there a way to revoke multiple users grant access from
>> multiple tables under a schema.?
>
>
2009/4/22 Seref Arikan :
> Hi Filip,
> First of all: thanks a lot for your kind response. Here is the create script
> for my schema:
>
> CREATE TABLE "app"."archetype_data" (
> "id" BIGINT NOT NULL,
> "context_id" VARCHAR(1000),
> "archetype_name" VARCHAR(1000),
> "archetype_path" VARCHAR(1
Thanks Scott.
Good answer, I was consolidating the schemas here, there were too many users
were granted permission to tables.I wanted to consolidate/optimize to bring
it to one role and granting this role to the user (same way as you
mentioned).
Thanks for the solution.
Thanks
Deepak
On Wed, Ap
The error message says all. Pgpool process needs to create
/var/run/pgpool/pgpool.pid when starting up. So you should give pgpool
write access right to the directory(/var/run/pgpool/), and of courese
along with access right to reach the directory.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> Hello,
>
>
Seref Arikan wrote:
I have a set of dynamically composed objects represented in Java, with
string values for various attributes, which have variable length. In
case you have suggestions for a better type for this case, it would be
my pleasure to hear about them.
cut out about 3 layers of abst
61 matches
Mail list logo
