Am 05/05/2004 03:03 PM schrieb Luiz Rafael Culik Guimaraes:
Do people think linux 2.6.5 is stable enough yet for a production
PostgreSQL server?
i´m using linux 2.6.5 with postgres 7.4.2 with out problem(conectiva linux
version 10)
I'd like to add here, that I recently tried 2.6.5 / Postgres 7.4.2
On 5/9/04 1:58 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> I am not sure how either of these techniques map into ecpg though.
> If you want to use ecpg then I'd suggest bringing up the question on
> pgsql-interfaces --- the ecpg gurus are more likely to be paying
> attention over there.
I got som
Hi all, I need some pointers. I want to optimize my pgsql databases
hardware-wise. I can do this in Sybase, Oracle, SQL Server, etc. by
putting let's say, indexes on one device, the trasaction logs on
another, data on another drive, etc. Can I do this in Postgresql ? I
have only used the simple
Edmund Dengler <[EMAIL PROTECTED]> writes:
> What I want is an '=' that compares nulls as equal (rather than as
> not-equal, which is the normal case).
IS DISTINCT FROM may help you here. It's a not-equals operator rather
than an equals operator, but it does what you want.
(Unless what you wante
CSN wrote:
I have two machines between which I exchange dumps a
lot. On the first (Windows/cygwin), pgsql was set up
with "Administrator" as the main superuser - who owns
all schemas in template0 and template1. On the second
machine (Linux), "postgres" is pgsql's main superuser.
On whatever machine
On Tue, 11 May 2004, Glenn Sullivan wrote:
> Hi,
>
> I have been trying to get LISTEN/NOTIFY working in with JDBC. I cannot seem
> to get notified. I looked in the e-mail archive and saw a lot of similiar
> questions a couple of years ago. I never could find any answers in the
> e-mail nor i
On Tue, 11 May 2004, [EMAIL PROTECTED] wrote:
> hello,
>
> i'm very new to postgres and have a fundamental question.
> how do i make a pg-db most secure?
> i feel, that pg_user e.g. ist something very dangerous - isn't it? if
> someone hacks into a db, then he has lots of information at his/her
> i'm very new to postgres and have a fundamental question.
> how do i make a pg-db most secure?
> i feel, that pg_user e.g. ist something very dangerous - isn't it? if
> someone hacks into a db, then he has lots of information at his/her
> fingertips. is this so?
>
> what do i do to prevent my
Thanks for all the answers everybody, but I need to know also an answer
to the other question:
Does the bytea make its own files automatically for large objects?
Also, how about backups with tables having bytea columns.?
Jonathan Bartlett wrote:
Also, if I wanted to put a *.pdf file in a bytea
hello,
i'm very new to postgres and have a fundamental question.
how do i make a pg-db most secure?
i feel, that pg_user e.g. ist something very dangerous - isn't it? if
someone hacks into a db, then he has lots of information at his/her
fingertips. is this so?
what do i do to prevent my db fro
On Tue, May 11, 2004 at 20:09:46 +0200,
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>
> i'm very new to postgres and have a fundamental question.
> how do i make a pg-db most secure?
> i feel, that pg_user e.g. ist something very dangerous - isn't it? if
> someone hacks into a db, then he ha
Hi,
>...I'm getting error like this from the java side and the
>application stops working (and wont come back unless I restart...
How is the "application" invoked? Is it a "service" (servlet instance, RMI
object-mediated, etc.), i.e. does a core-component run forever and spawn
helpers to handle
Hi Stijn,
>..By using threading we could let the client do the counting for the
timeout,
>but we can't figure out how exactly you stop/reset a server-side proces
>(or query) from the client...
Check out the test-scenario I've attached. It demonstrates how to use Java,
JDBC, and threads to allow
On Tue, May 11, 2004 at 09:30:15AM -0700, Jonathan Bartlett wrote:
> > Also, if I wanted to put a *.pdf file in a bytea column, what functions
> > do I use to escape any characters in it?
>
> What programming language are you using?
Apparently if you are using C and libpq, you can use the version
> Actually, the database db2 has all ready been created, plus the table names
> are the same, so I can not use pg_dump and restore.
Yes you can, just use pg_dump with the -a flag, and then just use psql
with redirection rather than restore.
Jon
---(end of broadcast)-
> Actually, the database db2 has all ready been created, plus the table names
> are the same, so I can not use pg_dump and restore.
Sure you can:
dropdb db2
createdb db2 ...
> >pg_dump -d db1 -t table1 |psql db2
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B
[EMAIL PROTECTED] wrote:
The back end is pretty much idle. It shows 'idle in transaction'.
Well, is not soo much idle, it's holding a transaction id!
That "idle in transaction" is not your problem but however I suggest you
take a look at why you have idle in transaction backend; do you
have back
I forgot, please CC me, I am on digest.
Dennis Gearon wrote:
when bytea, text, and varchar(no limit entered) columns are used, do
they ALWAYS use an extra table/file? Or do they only do it after a
certain size of input?
Also, if I wanted to put a *.pdf file in a bytea column, what
functions do
On Tue, 11 May 2004, Thomas LeBlanc wrote:
> I have 2 databases. I want to move data from table table1 in database db1 to
> table2 in db2.
>
> When I query 1 table from another database, I get a cross-database
> references are not implemented.
>
> server1% psql db1
> emdata=# select * from db2
Oh, then just edit the dump to point to the right table and don't
bother with the insert into part.
On Tue, 11 May 2004, Thomas LeBlanc wrote:
> Actually, the database db2 has all ready been created, plus the table names
> are the same, so I can not use pg_dump and restore.
>
> INSERT INTO db1.
Thomas LeBlanc wrote:
Actually, the database db2 has all ready been created, plus the table
names are the same, so I can not use pg_dump and restore.
INSERT INTO db1.public.tables SELECT * FROM db2.public.table1
Thanks,
Thomas
From: "scott.marlowe" <[EMAIL PROTECTED]>
To: Thomas LeBlanc <[EMAI
> Also, if I wanted to put a *.pdf file in a bytea column, what functions
> do I use to escape any characters in it?
What programming language are you using?
In Perl, you do something like:
$sth->bind_param(1, $file_data, DBI::SQL_BINARY); #DBI::SQL_BINARY is
deprecated, but it works
In php you
Actually, the database db2 has all ready been created, plus the table names
are the same, so I can not use pg_dump and restore.
INSERT INTO db1.public.tables SELECT * FROM db2.public.table1
Thanks,
Thomas
From: "scott.marlowe" <[EMAIL PROTECTED]>
To: Thomas LeBlanc <[EMAIL PROTECTED]>
CC: <[EMA
when bytea, text, and varchar(no limit entered) columns are used, do
they ALWAYS use an extra table/file? Or do they only do it after a
certain size of input?
Also, if I wanted to put a *.pdf file in a bytea column, what functions
do I use to escape any characters in it?
--
> Dias Bantekas wrote:
>
>> does any one know how to get an md5()-like hash function using
>> pgcrypto for postgresql 7.3 ? without upgrading to 7.4
>>
>> Thanks for any input.
>
> SELECT encode(digest(v_password, 'md5'), 'hex');
BTW,
/usr/share/pgsql/contrib/pgcrypto.sql
is the script that def
I have 2 databases. I want to move data from table table1 in database db1 to
table2 in db2.
When I query 1 table from another database, I get a cross-database
references are not implemented.
server1% psql db1
emdata=# select * from db2.public.table1;
ERROR: Cross-database references are not im
Dias Bantekas wrote:
does any one know how to get an md5()-like hash function using pgcrypto
for postgresql 7.3 ? without upgrading to 7.4
Thanks for any input.
SELECT encode(digest(v_password, 'md5'), 'hex');
hlk
---(end of broadcast)---
TIP 8: ex
I think that's what digest does. It doesn't appear to install in 7.4
since 7.4 has the md5 function. I don't have a 7.3 box to test it on
though...
On Tue, 11 May 2004, Dias Bantekas wrote:
> does any one know how to get an md5()-like hash function using pgcrypto
> for postgresql 7.3 ? withou
does any one know how to get an md5()-like hash function using pgcrypto
for postgresql 7.3 ? without upgrading to 7.4
Thanks for any input.
Dias
scott.marlowe wrote:
On Sun, 11 Apr 2004, Jerry McBride wrote:
T. Relyea wrote:
Mike Cox wrote:
Has anyone created something like that for Postgre
Tom Lane napisał:
> Yeah, that's a bug. The patch is attached if you need it. However, I
> think you will wind up looking for some other way to solve the problem,
> because this query won't scale well to large datasets.
I already did some googling and found two examples of median calculating
fun
30 matches
Mail list logo
