Thanks for the information.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Friday, January 14, 2005 5:36 PM
To: [EMAIL PROTECTED]
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Limiting size and number of transaction logs
"Chris White (cjwhite)" <[EMAIL PROTECTE
Hello, Jaider
The build instructions for solaris seem to be lost from the techdocs site, but
I just found
out today that there's a binary pkg on sunfreeware.com for sparc 5.9. If it
works it will be a
real time saver
Jaider Sousa Fraga wrote:
My name is Jaider. I live in Brazil, and I need one i
My name is Jaider. I live in Brazil, and I
need one instalation the postgres at sun solaris.
I need help about that.
Ok thanks for that.
[EMAIL PROTECTED]
JAIDER SOUSA FRAGA
ANALSITA DE SISTEMAS
MS/DATASUS/CGDSI
Ramal: 2937
--
No virus found i
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> In the documentation for 7.4 for WAL configuration, I see the following
> statement:
> There will be at least one 16 MB segment file, and will normally not be more
> than 2 * checkpoint_segments + 1 files.
> So if I have 1 checkpoint segment
On Fri, Jan 14, 2005 at 06:11:27PM +, Bradley Kieser wrote:
> Okay, Michael gets that trophy! Thanks Michael, it needed a commit.
> However, this is odd. I get a "No transaction in progress" error coming
> out on the commit, but at least it works, so I am happy!
What version of the client an
In the documentation
for 7.4 for WAL configuration, I see the following
statement:
There will be at least one 16 MB segment file, and will
normally not be more than 2 * checkpoint_segments + 1
files.
So if I have 1
checkpoint segment configured, does this mean there will be a max of 4
We are doing "real" backups using pg_dump every night. The problem is
that we need to provide for an absolute minimum data loss. We are using
the logging of the sql for this. Right now, we can not change the
version of the db we are on (7.3.4), so we are trying to make the most
of what we have.
unsuscribme
-
This mail sent through IMP: http://horde.org/imp/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hi, I'm running postgresql 8.0.rc5 on SUSE.
I have the pg_hba.conf file configured with
local all smith ident sameuser
hostall smith ident sameuser
The way authentication works with that is that configuration is that if
I'm logged in as smith with my company ldap server I can
Michael, I didn't see the last comment in my previous replies. I know
that the variable isn't set because I embedded \set into the psql
commands so that they would output what is set.
Thanks,
Brad
Michael Fuhr wrote:
On Fri, Jan 14, 2005 at 12:03:02PM +, Bradley Kieser wrote:
I have an ad
Okay, Michael gets that trophy! Thanks Michael, it needed a commit.
However, this is odd. I get a "No transaction in progress" error coming
out on the commit, but at least it works, so I am happy!
Thank you!
This works:
psql -U$dba $db << END
drop schema $repschema cascade;
commit;
create schema
Michael Fuhr wrote:
On Fri, Jan 14, 2005 at 12:03:02PM +, Bradley Kieser wrote:
I have an admin script that drops a schema and then recreates it (quick
way to refresh from backup). However, if the schema doesn't exist, the
drop errors, as you would expect. The next SQL command, the schema
On Fri, Jan 14, 2005 at 12:03:02PM +, Bradley Kieser wrote:
> I have an admin script that drops a schema and then recreates it (quick
> way to refresh from backup). However, if the schema doesn't exist, the
> drop errors, as you would expect. The next SQL command, the schema
> create, is ne
"Chris Hoover" <[EMAIL PROTECTED]> writes:
> We are having an issue here trying to automate our db log rotations.
What PG version is this? On what platform?
> We were using the Apache rotatelogs program and we thought it was
> working fine. However, when we had a server crash and had to recover
Hi Chris,
In the rotate_logs.sh I would replace the first sleep 150 with a call to
fuser (in a sleeping loop) to make sure there is no file access to the log
file. I don't understand the second sleep 150.
Rick
Scott,
Now add two managers who are more at home with HP MPE or VAX VMS
and a CIO whose more comfortable in software development & you'll see
why I am the way I am. Paranoia & irrational thought are everywhere.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message
Hi all,
We are having an issue here trying to automate our db log rotations. We were
using the Apache rotatelogs program and we thought it was working fine.
However, when we had a server crash and had to recover and roll forward using
the postgresql logs (we are logging all sql), we discovere
* Kavan, Dan (IMS) <[EMAIL PROTECTED]> [0122 05:22]:
> Hi,
>
> I configured Postgres with PAM. I was wondering how to implement this.
> Does this mean I will still need to create individual users on the
> database or can I assign users rights from a LDAP server?
in my experience, you sti
I have an admin script that drops a schema and then recreates it (quick
way to refresh from backup). However, if the schema doesn't exist, the
drop errors, as you would expect. The next SQL command, the schema
create, is never executed.
I do not have ON_ERROR_STOP set so why is this happening?
Hello!
I don't beleive this necessarily indicates an error in
GetAvailebleLocales() - a crash usually exits with code 3. And the
MSIHANDLE leak is known, we've just been unable to pinpoint where it is.
And since it's just one handle, it's not all that important. Could we
get a couple of more line
On Thu, Jan 13, 2005 at 07:16:28PM +0530, Ramachandra Putti wrote:
> Why did I get this error?
You're trying to index a value that's larger than 1/3 of your page
size. What is the column used for? Do you really need to index
such a large value? There might be other ways to index the column,
su
21 matches
Mail list logo
