1. Why i do
this:
I try to migrate a database with
a 200 tables from Sybase SQL Anywhere to PostgreSQL,
but SQL Anywhere escapes special
characters like a HEX values ( like \x0D \x2C . ).
PostgreSQL COPY FROM recognize
only OCT values ( lie \001 ... )
2. How-to it' easy :)))
2.1 -
Is there any way to prevent superuser to acces the
database ?
I mean something like "GRANT /
REVOKE CONNECT" MECHANISM
I have no idea how to prevent root from access data
in one of this ways :
root @ linux:~#su
- postgres
postgres @
linux:/usr/local/pgsql/bin$pg_dump
or
edit
edit *pg_hba.conf *
# Allow any user on the
local system to connect to any
# database under any
username, but only via an IP connection:
host
all
127.0.0.1 255.255.255.255
trust
# The same, over
Unix-socket connections:
local
all
trust
what about reading pg_hba.conf
They can just read the raw database files as
well.
wow I'm not sure
how about this
edit pg_hba.conf
# Allow any user on the local system to connect to
any # database under any
username
local
all
trust
su - posgres
psql test -U dba
or
pg_dump test
You have to be able to
Next your going to ask what will stop root
from stopping your PostgreSQL, compiling a second copy with
authentication disabled and using your data directory as it's source
:)
He he i'm enough paranoic :))
If you want to prevent root from
accomplishing these things, you're going to have
Next your going to ask what will stop root from stopping your
PostgreSQL, compiling a second copy with authentication disabled and
using your data directory as it's source :)
He he somebody can blow up ur home with C4, but this don't stop you from
locking ur door !?!
Native Windows port
Plz don't forget poor victims of Microsoft
!!!
I am working on getting a shrink-wrapped version of PostgreSQL for
WindowsCurrently it installs a customized version of Cygwin, PostgreSQL
7.2.3, cygipc, psqlodbc, and pgadminIII currently have the setup
done.
Cool :)
I'm now working on postmaster windows shell. It's
not finished yet but
- Original Message -
From:
mlw
To: Igor Georgiev
Cc: [EMAIL PROTECTED]
Sent: Thursday, December 05, 2002 6:52
PM
Subject: Re: Shrinkwrap Windows Product,
any issues? Anyone? (postmaster windows shell)
Hey this is a cool project. I have been thinking
- Original Message -
From: Igor
Georgiev
To: mlw
Sent: Friday, December 06, 2002 4:57 PM
Subject: Re: Postmaster windows shell
- Original Message -
From: "mlw" [EMAIL PROTECTED]
To: "Igor Georgiev" [EMAIL PROTECTED]
Sent: Friday, December 06, 2002
- Original Message -
From: Devrim GÜNDÜZ [EMAIL PROTECTED]
To: PostgreSQL-development [EMAIL PROTECTED]
Sent: Saturday, December 14, 2002 4:58 PM
Subject: Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
Also, I have something to say about win32 port.
I'm a Linux user. I'm
http://www.janwieck.net/win32_port/notes.win32-ports.txt
How to compile this Win32 port
1) Requirements and 1-time settings:
1.1) Visual C++
You need VC++ 6.0 on ServicePack 5.
Oooh no, not MS stuff plz :(
Dev-Cpp is cool open source IDE, tha using a mingw port of gcc.
- Original Message -
From: Justin Clift [EMAIL PROTECTED]
To: Curt Sampson [EMAIL PROTECTED]
Cc: Peter Eisentraut [EMAIL PROTECTED]; Curtis Faith
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, February 02, 2003 4:42 AM
Subject: Re: [mail] Re: [HACKERS] Windows Build System
+ It
13 matches
Mail list logo
