Re: Porting from MySQL to PostgreSQL (was: [HACKERS] pgsql 7.2.3

2002-12-09 Thread Devrim GUNDUZ
Hi,

On Mon, 2002-12-09 at 10:24, SEGUERRA FRANCIS TED ARANAS wrote:

> how do i port from mysql to postgresql?..

http://techdocs.postgresql.org/#convertfrom

Best regards,
.

-- 
Devrim GUNDUZ 
TR.NET Sistem Destek Uzmani

Tel : (312) 295 93 18  Fax : (312) 295 94 94 Tel : (216) 542 90 00


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



[HACKERS] PostgreSQL Password Cracker

2002-12-31 Thread Devrim GUNDUZ

Hi,

Some guys from Turkey claim that they have a code to crack PostgreSQL
passwords, defined in pg_hba.conf .

http://www.core.gen.tr/pgcrack/

Maybe some of you want to get the code...

Best regards,
--
Devrim GUNDUZ
www.gunduz.org



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] PostgreSQL Password Cracker

2002-12-31 Thread Devrim GUNDUZ
Hi,

On Sal, 2002-12-31 at 19:38, Tom Lane wrote:
>
> This is not a cracker, this is just a brute-force "try all possible
> passwords" search program (and a pretty simplistic one at that).

Ah, you're right.

> I'd say all this proves is the importance of choosing a good password.
> Using only lowercase letters is a *bad* idea, especially if you're only
> going to use five of 'em...

I had no time to search throug the code; but as far as I understood, it
*attacks* the database servers with TCP/IP on, right?

Best regards,
--
Devrim GUNDUZ
www.gunduz.org
[EMAIL PROTECTED]


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Re: [HACKERS]

2003-01-16 Thread Devrim GUNDUZ
Hi,


On Thu, 2003-01-16 at 10:13, Christopher Kings-Lynne wrote:

> In postgresql 7.3.1, if I do pg_dumpall -c, at the top of the dump file is
> this:
> 
> DROP DATABASE au_shipping
> ;CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE = template0
> ENCODING = 'SQL_ASCII';
> DROP DATABASE au_test
> ;CREATE DATABASE au_test WITH OWNER = chriskl TEMPLATE = template0 ENCODING
> = 'SQL_ASCII';
> DROP DATABASE australia
> ;CREATE DATABASE australia WITH OWNER = auadmin TEMPLATE = template0
> ENCODING = 'SQL_ASCII';
> DROP DATABASE geeklog
> ;CREATE DATABASE geeklog WITH OWNER = chriskl TEMPLATE = template0 ENCODING
> = 'SQL_ASCII';
> DROP DATABASE keystone
> ;CREATE DATABASE keystone WITH OWNER = chriskl TEMPLATE = template0 ENCODING
> = 'SQL_ASCII';
> 
> Why are all the CREATE DATABASE statements commented out?  Surely that will
> make the restore fail?

Just guessing:

The first line does not have a ; at the end; so the first semicolon (at
the beginning of second line) will end the first line; will not comment
the CREATE DATABASE line...

I mean, it might work as below:
DROP DATABASE au_shipping;

CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE = template0
ENCODING = 'SQL_ASCII';

?

Best regards,
-- 
Devrim GUNDUZ 
TR.NET Sistem Destek Uzmani

Tel : (312) 295 93 18  Fax : (312) 295 94 94 Tel : (216) 542 90 00


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html