In my further discussion with Andrew offline, we came up with a joint
suggestion to have PostgreSQL do automatic auditing. This would be VERY
NICE, imho. Any input?
Scott wrote:
> It seems like it would be nice if you could flip a toggle on a
> table and have it automatically build audit entr
Hi all:
Let's say I'm designing a database (Postgres 7.3) with a list of all
email accounts in a certain server:
CREATE TABLE emails (
clienteid INT4,
direccion VARCHAR(512) PRIMARY KEY,
login varchar(128) NOT NULL,
password VARCHAR(128),
dominio VARCHAR(256)
);
The PHBs want to have a log of
"Edwin Quijada" <[EMAIL PROTECTED]> writes:
> I got error about a length field varchar. I have a table with a field type
> varchar(20) but if I try to set to this field more than 20 characters I got
> error.
> I did a function to control the length of data and put it on trigger but
> when it ocu
You can use -t to specify a table:
% pg_dump -s database -t tablename
-Rick
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Patrick
Hatcher
Sent: Wednesday, October 29, 2003 12:57 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] dump schema schema only?
I
At 05:06 PM 10/29/03 +, Edwin Quijada wrote:
wHAT IS unconstrained varchar???
Define the column as just varchar. This allows a string of any
length. Then have a trigger truncate it after it is inserted.
--- Adam Kavan
--- [EMAIL PROTECTED]
---(end of broadcast)-
wHAT IS unconstrained varchar???
*---*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*---
I'd say yes based on the SSL and pg_dump fixes that were back patched ...
On Wed, 29 Oct 2003, Tom Lane wrote:
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Yeah, I think we have accumulated enough changes in the 7.3 branch to
> >> justify a 7.3.5, but I'm not sure when we'll
"Patrick Hatcher" <[EMAIL PROTECTED]> writes:
> I have a development server where I, well, do my development. Occasionally,
> I will create a new schema within an existing database that I would like to
> use on my production machine. I know that doing a pg_dump -s
> > somefile.sql will dump the
On Wed, 2003-10-29 at 11:46, Edwin Quijada wrote:
>
> Hi!!
> I wanna take a whole database running in a box1 pg7.3.4 and moving to
> another box2 with 7.3.4 too.
> There is a fast way to do that??
> Which??/
oldserver:~ pg_dumpall foo.dmp && scp foo.dmp newserver:.
oldserver:~ ssh newserver
news
On Wed, 29 Oct 2003, Edwin Quijada wrote:
>
>
>
> Hi!!
> I wanna take a whole database running in a box1 pg7.3.4 and moving to
> another box2 with 7.3.4 too.
> There is a fast way to do that??
> Which??/
The way I do it is:
pg_dumpall -h source_machine |psql -h dest_machine
-
I have a development server where I, well, do my development. Occasionally,
I will create a new schema within an existing database that I would like to
use on my production machine. I know that doing a pg_dump -s
> somefile.sql will dump the entire schema of the database, but is there a
way to e
What is that I have to return in a delete trigger??
return OLD or NEW
_
Add MSN 8 Internet Software to your current Internet access and enjoy
patented spam control and more. Get two months FREE!
http://join.msn.com/?page=dep
Hi!!
I wanna take a whole database running in a box1 pg7.3.4 and moving to
another box2 with 7.3.4 too.
There is a fast way to do that??
Which??/
*---*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas logr
>Firstly, have you run ANALYZE across the database?
ANALYZE not, only EXPLAIN. And it looks pretty normal :( There is basically
nothing interested in soo simple SQL.
>Secondly, the queries that are varying so much, can you post the EXPLAIN
>ANALYZE output so we can see what is actually going on.
Jan Wieck <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Yeah, I think we have accumulated enough changes in the 7.3 branch to
>> justify a 7.3.5, but I'm not sure when we'll get around to it.
> On 10/03/2003 Bruce was the only one responding to my question if the
> namespace fix I had for PL/T
Alex wrote:
Hi,
I have a test system that is setup the same as a production system and
would like to frequently copy the database over.
pg_dump takes a few hours and even sometimes hangs.
Are there any reasons not to simply just copy the entire data directory
over to the test system? I could n
I am looking for an experienced DBA in the North Texas area who would be
available for a brief (probably about a day) consultation on database
design and optimization in PostgreSQL.
Please contact me if interested,
Stuart Johnston
[EMAIL PROTECTED]
---(end of broadcast)-
Hi!!
I got error about a length field varchar. I have a table with a field type
varchar(20) but if I try to set to this field more than 20 characters I got
error.
I did a function to control the length of data and put it on trigger but
when it ocurrs I got the error anyway and the trigger no
Firstly, have you run ANALYZE across the database?
Secondly, the queries that are varying so much, can you post the EXPLAIN
ANALYZE output so we can see what is actually going on.
Note also that the query log can be very helpful in finding out if the delay
is in the database or not.
Hope this he
Hi,
I have a test system that is setup the same as a production system and
would like to frequently copy the database over.
pg_dump takes a few hours and even sometimes hangs.
Are there any reasons not to simply just copy the entire data directory
over to the test system? I could not find any p
Alex <[EMAIL PROTECTED]> writes:
> Hi,
>
> I have a test system that is setup the same as a production system and
> would like to frequently copy the database over.
> pg_dump takes a few hours and even sometimes hangs.
>
> Are there any reasons not to simply just copy the entire data
> directory
Wrong list. Please post this to the [EMAIL PROTECTED] list.
I am sure there are people there that can help you with this.
Regards,
Fernando
Aleksey wrote:
Hello,
I have the following problem working with DatabaseMetaData. There is a
database with table and attribute names in Russian. Databas
Tom Lane wrote:
Bruno Wolff III <[EMAIL PROTECTED]> writes:
I think that a 7.3.5 release should be done a bit after 7.4 is released,
but my opinion doesn't count for much.
Yeah, I think we have accumulated enough changes in the 7.3 branch to
justify a 7.3.5, but I'm not sure when we'll get around t
Dear list,
First of all I want to say sory, if my question was answered somewhere.
Or if it is my fault. If so, please, give me link/hint. My own search fails
:( I have experimence with MySql, MsSql and Oracle (and MS Access huch :) I
am new to PgSql.
We are running server - OpenBSD 2.9,
John DeSoi <[EMAIL PROTECTED]> writes:
> What version of OS X are you running? I thought I replicated the
> problem after upgrading to 10.2.8, but now I'm not certain I ran initdb
> again (I may have just rebuilt beta 5). So possibly it could be a
> difference between 10.2.6 and 10.2.8. If not,
Victor Spång Arthursson wrote:
> Are presently converting from mysql to postgresql, and my first
> newbiequestion is how to make all the rows in a result from a select
> just "swosh" by? That is, I dont want to see them page for page; just to
> scroll by so I can se the last line with the number
On Tue, Oct 28, 2003 at 01:04:27PM -0500, Greg Stark wrote:
> If it runs out of spare blocks, then you're in trouble. And there's no warning
> that you're running low on spare blocks in any particular region unless you
> use special utilities to query the drive. Also if the failure is caused by
> e
27 matches
Mail list logo
