Dear All,
I facing problem in my log rotation for postgres, it
is not rotation properly. I am using syslog-ng package
for loging.
My logs for postgres looks like this,
-rw-r--r--1 root root 10M Feb 28
23:24 postgres.log.20
-rw-r--r--1 root root0 Feb 28
20:16
Wes Palmer <[EMAIL PROTECTED]> writes:
> Any chance of change that
> behavior to scan in physical storage order?
It wouldn't be easy --- there are some locking considerations that say
btbulkdelete needs to scan the index in the same order that an ordinary
scan would do. See the nbtree README for
Jonathan Schreiter wrote:
> i can't seem to connect to the new database using
> pgadmin3. i have the correct IP address of the local
> computer, default port 5432, mydb as the initaldb,
> postgres as the username, and my new password as the
> password. i keep getting the error
>
> Error connecting
On Wed, Mar 02, 2005 at 11:30:58PM +0200, Ioannis Theoharis wrote:
> On Wed, 2 Mar 2005, Martijn van Oosterhout wrote:
> > What makes you think that? Clustering is nice, but postgresql needs to
> > get the right answer and that the table in clustered is not something
> > postgresql can rely on.
>
Wes <[EMAIL PROTECTED]> writes:
> Watching the system as vacuum is running, I can see that we are encountering
> the kswapd/kscand problem in the 2.4.20 kernel. This could very well
> account for the non-linear increase in vacuum time.
Hmm. Looking at the vacuum verbose output you sent me, it's
Watching the system as vacuum is running, I can see that we are encountering
the kswapd/kscand problem in the 2.4.20 kernel. This could very well
account for the non-linear increase in vacuum time.
This problem is fixed in the 2.6 kernel, but we can't upgrade because DELL
is dragging their feet i
Brian Maguire wrote:
> Is anyone currently using pgpool with production high volume use? I
> am interested in your success and challenges.
There isn't much special about high volume use. Just make sure you
configure the pool size appropriately for your application and
configure a corresponding
On Wed, Mar 02, 2005 at 10:08:58PM +0200, Ioannis Theoharis wrote:
> I have a relation like this: (att0 varchar(1000), att1 int4)
>
> i create a b-tree index on att1 ()
> i cluster my raltion according to index
>
> now i have a query
> select*
> form tc20
> where att1<=90
One can, however, simply delete the forgotten password
and create another for temporary usage until the user
in question can create a new one. (At least one could
in 7.4, I have not tried it in 8.0.)
Jeff
--- Bruce Momjian wrote:
> From: Bruce Momjian
> Subject: Re: [GENERAL] [ADMIN] pg_shad
On Wed, 2 Mar 2005, Tatsuo Ishii wrote:
> > An other question:
> >
> > Is there any way to prevent duplicates on btree index attribute,
> > PERMITTING them on table?
>
> I can't think of any usefull usage for such an index. Can you explain
> why you need it?
I have a relation like this: (att0 v
Ioannis Theoharis <[EMAIL PROTECTED]> writes:
> Where can i find a documentation with technical analysis for all (if
> possible) of components of postgres?
Read the source code.
regards, tom lane
---(end of broadcast)---
TIP
On Tue, 1 Mar 2005, Tom Lane wrote:
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > So it seems Ioannis' number was not taken immediately after a CREATE
> > INDEX operation?
>
> I would guess not, but it's up to him to say. If it is a number derived
> after some period of normal operation, then
"Alexandru Coseru" <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] gateway]# psql -U postgres -h 127.0.0.1 template1
> Welcome to psql 7.4.5, the PostgreSQL interactive terminal.
> Type: \copyright for distribution terms
>\h for help with SQL commands
>\? for help on internal sla
Stephane Bortzmeyer <[EMAIL PROTECTED]> writes:
> It is of course very inconvenient to duplicate my LDAP database into
> pg_ident.conf. Is there a better way?
Perhaps you can find a PAM plugin that talks to LDAP, and configure
Postgres to use that.
regards, tom lane
-
Alexandru Coseru wrote:
Hello..
Any ideeas ?
Fraid so and it is not good.
I am no expert in the inner-inner workings of Postgres, but my guess is
that your catalogue is, or has been, corrupt.
If this is the case it is unrecoverable. It is a matter of rescuing
what data you can (using pg_d
pgadmin3 does not seem to want to connect to the server using UNIX
sockets, it only does it through TCP.
Set up the Postgres server to use TCP (as well as UNIX sockets) - i.e. -
starting postmaster with the -i option, sorting it pg_hba.conf etc.
Eddy
Jonathan Schreiter wrote:
hi all,
running am
On 3/2/05 12:16 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Would you post the complete VACUUM VERBOSE log? The CPU/elapsed time lines
> would help us identify where the time is going.
Mailed.
I do see stats like:
CPU 518.88s/25.17u sec elapsed 10825.33 sec.
CPU 884.96s/64.35u sec elapsed 1379
Wes <[EMAIL PROTECTED]> writes:
> It took 5.2 hours again tonight to do the vacuum. I don't see anything out
> of the ordinary - no explanation for the non-linear increases in vacuum
> time.
Would you post the complete VACUUM VERBOSE log? The CPU/elapsed time lines
would help us identify where t
On 3/2/05 12:16 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Would you post the complete VACUUM VERBOSE log? The CPU/elapsed time lines
> would help us identify where the time is going.
I'll send it to you directly - its rather long.
>> DETAIL: Allocated FSM size: 1000 relations + 100 pages
Got it. Thanks!
Scott
On Mar 1, 2005, at 10:52 PM, Ragnar Hafstað wrote:
On Tue, 2005-03-01 at 16:51 -0800, Scott Frankel wrote:
Sweet! And not so sweet.
The natural join worked beautifully with my test schema; but it failed
to yield any rows with my real-world schema. I think I've tracked
down
On Wed, Mar 02, 2005 at 12:23:45PM -0500, Todd Kover wrote:
>
> I have an aggregate function setup (attached) that I'm calling over a
> massive amount of data and am running into:
>
> ERROR: cannot have more than 2^32-1 commands in a transaction
> CONTEXT: PL/pgSQL function "float8_
I have an aggregate function setup (attached) that I'm calling over a
massive amount of data and am running into:
ERROR: cannot have more than 2^32-1 commands in a transaction
CONTEXT: PL/pgSQL function "float8_jitter_add" line 16 at if
error. Since I'm able to do count() and
That particular error message is typically associated with a missing
pg_hba.conf entry that tells the postgreSQL server which remote machines to
allow connections FROM
# If you want to allow non-local connections, you need to add more
# "host" records. Also, remember TCP/IP connections are
"Envbop" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi
>
> I've just inherited a PostgreSQL database, for which I do not have any
> details of, like database name or the users.
> This used to be a library database which was managed via a web page
> written
> in php.
> Its runni
Hi,
Does postgres support any system functions that
decode/decrypt the user passwords stored in pg_shadow
system catalog.
Is there a way to retrieve the passwords, if
forgotten.
Thanks in Advance.
Priya
__
Celebrate Yahoo!'s 10th
Hemapriya wrote:
> Hi,
>
> Does postgres support any system functions that
> decode/decrypt the user passwords stored in pg_shadow
> system catalog.
>
> Is there a way to retrieve the passwords, if
> forgotten.
No. They are MD5 and are designed to be unencryptable.
--
Bruce Momjian
On 2/28/05 6:53 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Again, VACUUM VERBOSE info would be informative (it's sufficient to look
> at your larger tables for this).
It took 5.2 hours again tonight to do the vacuum. I don't see anything out
of the ordinary - no explanation for the non-linear i
Hi,
I tried to test plperl and got the following error with the very first
example from chapter 37:
CREATE OR REPLACE FUNCTION perlmax(integer,integer)
RETURNS integer AS $$
if ($_[0] > $_[1]) { return $_[0]; } return $_[1];
$$ LANGUAGE plperl;
--
error from Perl function: trusted Perl functions
Hello..
I've got this error and I don't know how to fix
it.
Since it's an production database , I can't drop
& recreate it..
Here are some infos below..
[EMAIL PROTECTED] gateway]# psql -U postgres -h
127.0.0.1 template1Welcome to psql 7.4.5, the PostgreSQL interactive
terminal.
Ty
I manage a Debian/Linux machine which runs PostgreSQL 7.4.7.
All the user accounts, including mine, are in a LDAP database. Thanks
to NSS (Name Service Switch) all applications have access to the LDAP
accounts (getpwuid(3) and getpwnam(3) use LDAP). But not PostgreSQL.
When I connect locally (Lin
On Tue, 2005-03-01 at 09:44 +1300, Envbop wrote:
> Hi
>
> I've just inherited a PostgreSQL database, for which I do not have any
> details of, like database name or the users.
> This used to be a library database which was managed via a web page written
> in php.
> Its running on a Linux box.
> Th
Did you set up the pg_hba.conf file with the proper security rights?
"Jonathan Schreiter" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> hi all,
> running amd64 fedora core 3 w/ default postgresql
> 7.4.7-3. did asu - , su postgres and createdb mydb as
> explained in the postgresql
On Wed, 2 Mar 2005, Jonathan Schreiter wrote:
hi all,
running amd64 fedora core 3 w/ default postgresql
7.4.7-3. did asu - , su postgres and createdb mydb as
explained in the postgresql tutorial. installed the
latest pgadmin3 and am trying to connect to this
database. as i wasn't sure what the FC3
Did you start the postmaster using '-i' to allow tcp/ip connections?
Sean
On Mar 2, 2005, at 6:15 AM, Jonathan Schreiter wrote:
hi all,
running amd64 fedora core 3 w/ default postgresql
7.4.7-3. did asu - , su postgres and createdb mydb as
explained in the postgresql tutorial. installed the
latest
hi all,
running amd64 fedora core 3 w/ default postgresql
7.4.7-3. did asu - , su postgres and createdb mydb as
explained in the postgresql tutorial. installed the
latest pgadmin3 and am trying to connect to this
database. as i wasn't sure what the FC3 default
password was for postgres, i changed i
If the number is negative there needs to be room for the minus sign...
On Tue, Mar 01, 2005 at 09:25:02AM -, Ben Trewern wrote:
> >From the docs:
>
> "FM suppresses leading zeroes and trailing blanks that would otherwise be
> added to make the output of a pattern be fixed-width"
>
> It work
On Wed, Mar 02, 2005 at 11:15:52AM +0200, Sim Zacks wrote:
> select name,testcursor(testid) from test; --doesn't work
> select name,testcursor(testid) from test where testid=1; -- works (as does
> testid=2 or 3)
If I add "close crs;" before the function returns, I get this:
SELECT name, testcurs
> Always close your cursors.
>
Thanks.
In my real example I had multiple return points and did not close the cursor
before each one.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining c
> If I add "close crs;" before the function returns, I get this:
>
> SELECT name, testcursor(testid) FROM test;
> name | testcursor
> --+
> Bob | -Comment 1-Comment 2-Comment 3
> Mark | -Comment 1
> Tom |
> (3 rows)
>
You got it.
I was closing th
Sim Zacks wrote:
create or replace function testcursor(thistestid int) returns varchar as
$$
declare
crs Cursor for select comments from test a join test2 b on
a.testid=b.testid where a.TestID=thistestid;
thiscomment varchar;
totalstr varchar;
begin
open crs;
fetch crs into thiscomment;
total
You might want to take a look at
http://www.daffodildb.com/replicator.html
It claims to be able to replicate between different databases, including
"Sql server" and postgres. If you try it pleases share your experience
with us, I haven't seen yet a review involving replication between
different DB
I haven't tried 8.0.1 yet. I am planning on making the upgrade soon, but
since I haven't seen this issue discussed I did not think it had been fixed
just because I am using an older version. I did search the Internet and
found one person who had the same issue and found a workaround that won't
appl
On Wed, Mar 02, 2005 at 09:21:44AM +0200, Sim Zacks wrote:
> PostGreSQL 8.0beta1
That's pretty old. Have you tried 8.0.1?
> I have a function that uses a cursor and it is giving me the error: cursor
> "crsr" already in use when the parameters I pass in come from another table.
>
> The function
43 matches
Mail list logo