Dear all,
I would love to have things covered, but I have inherited this setup.
I am sure we will improve it, but I have to make the most with what I have got,
I am afraid.
I am grateful for all the help so far, I really appreciate it.
Ps I think there should be an easier way, maybe doing as fol
The machine is a mini-laptop running almost all day time (actually
there are many of them) and if the machine is captured it is likely to
be captured while running. With an encrypted file system if the
machine is already booted you already have access to the file system
and can simply copy it and e
Dear all,
I know to get a list of all databases on the system one can use: \l or (back
slash) (ell)
Is there a specific 'STATEMENT' to display the same thing?
For example on MySQL, one would use: show databases;
Ps I can't seem to find this anywhere.
Thank you very much in advance.
Renato
R
On Tue, 2010-04-06 at 12:22 +0100, Renato Oliveira wrote:
>
> I know to get a list of all databases on the system one can use: \l or
> (back slash) (ell)
>
> Is there a specific 'STATEMENT' to display the same thing?
Run psql with -E parameter, and then run \l. You'll see the query
there .
Reg
On 6 April 2010 15:22, Renato Oliveira wrote:
> Is there a specific ‘STATEMENT’ to display the same thing?
Try this
SELECT datname FROM pg_database;
--
Sergey Konoplev
Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray...@gmail.com / Skype: gr
Sergey,
Thank you very much, this is more is great.
Best regards
Renato
Renato Oliveira
Systems Administrator
e-mail: renato.olive...@grant.co.uk
Tel: +44 (0)1763 260811
Fax: +44 (0)1763 262410
http://www.grant.co.uk/
Grant Instruments (Cambridge) Ltd
Company registered in England, regist
Devrim,
Thank you very much
Renato
Renato Oliveira
Systems Administrator
e-mail: renato.olive...@grant.co.uk
Tel: +44 (0)1763 260811
Fax: +44 (0)1763 262410
http://www.grant.co.uk/
Grant Instruments (Cambridge) Ltd
Company registered in England, registration number 658133
Registered office
On Tue, 6 Apr 2010 12:45:52 +0300 Timothy Madden wrote:
> The machine is a mini-laptop running almost all day time (actually
> there are many of them) and if the machine is captured it is likely to
> be captured while running. With an encrypted file system if the
> machine is already booted you al
Timothy Madden wrote:
> With an encrypted database, you need the password anytime you
> connect, even if another application already has an open
> connection.
How is the database server supposed to start up and become ready to
accept connections without reading the database?
Also, as previou
The machine does not have internet and it will not be trivial for the
bad guy to install anything there.
And my idea is exactly that the database is inaccessible, even if the
server starts. Unless the password is provided upon connecting or
selecting the database. You can think of it as if all col
On Tue, 6 Apr 2010 12:45:52 +0300 Timothy Madden wrote:
> The machine is a mini-laptop running almost all day time (actually
> there are many of them) and if the machine is captured it is likely to
> be captured while running. With an encrypted file system if the
> machine is already booted you al
Hello
This is Steve Nayam from MRS. I am looking for Postgresql DBA consultant.
I just want to know if you can help me in this regard, can I post jobs here.
Thank you
Regards,
Steve Nayam
Business Development Manager
Maple Resource Specialists (MRS)
973-494-5751 - USA
How do I configure postgres to lock a user's account after X failed login
attempts, where X is an arbitrary number.
Also is there a way to limit the number of concurrent connections on a per
account basis?
-Kevin
I have just moved to rackspacecloud and created a Ubuntu 9.10 server.
Moved everything over all fine (7-10 wordpress sites). Now I have a
couple rails apps that need to move over and run on postgresql 8.4.
I installed postgresql via sudo apt-get as per usual. Usually at this
point the postgresql s
Hi
Using Postgresql 8.2 on Linux, I am trying to use dblink contrib to connect
to a remote Postresql 8.2 database. I am using the following SQL :
select dblink_connect('host=remote_server port=5432 dbname=remote_bdd
user=remote_user password=remote_pwd');
The problem is :
- when remote_server en
TrueCrypt is a free open source application, can encrypt any drive or create
a virtual encrypted drive.
-Mensaje original-
De: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] En nombre de Scott Marlowe
Enviado el: lunes, 05 de abril de 2010 05:35 p.m.
Para: T
Timothy Madden wrote:
> The machine does not have internet and it will not be trivial for the
> bad guy to install anything there.
> [...]
Then why bother encrypting the database if $BADGUY cannot
access it without your installed application anyhow?
Tim
--
Sent via pgsql-admin mailing list (
On Fri, 2010-04-30 at 18:51 -0400, STEVE NAYAM wrote:
> Hello
>
You want to post to pgsql-jobs
>
>
> This is Steve Nayam from MRS. I am looking for Postgresql DBA
> consultant.
>
> I just want to know if you can help me in this regard, can I post jobs
> here.
>
>
>
> Thank you
>
>
>
Will PG start at all? Manually, even? I'd say "go back to clean," first of all
by removing your from-source install, and reinstall the apt-get packages.
At that point, can you start postgres at all? If not, what do you system logs
and postgres startup logs say?
- "Jordz" wrote:
> I have
Jordz writes:
> I have just moved to rackspacecloud and created a Ubuntu 9.10 server.
> Moved everything over all fine (7-10 wordpress sites). Now I have a
> couple rails apps that need to move over and run on postgresql 8.4.
> I installed postgresql via sudo apt-get as per usual. Usually at this
Kevin Crain writes:
How do I configure postgres to lock a user's account after X failed login
attempts, where X is an arbitrary number.
Don't think there is a way to do that.
Perhaps using an authentication mechanism that supports that and then using
it to connect to Postgres..
This page may
On Thu, Apr 1, 2010 at 8:53 PM, Jordz wrote:
> I have just moved to rackspacecloud and created a Ubuntu 9.10 server.
> Moved everything over all fine (7-10 wordpress sites). Now I have a
> couple rails apps that need to move over and run on postgresql 8.4.
>
> I installed postgresql via sudo apt-g
На 05.4.2010 23:11, Kevin Crain написа:
[...]
Also is there a way to limit the number of concurrent connections on a per
account basis?
ALTER ROLE CONNECTION LIMIT ;
(http://www.postgresql.org/docs/current/static/sql-alterrole.html)
--
Milen A. Radev
--
Sent via pgsql-admin mailing list
Francisco Reyes writes:
> Kevin Crain writes:
>> How do I configure postgres to lock a user's account after X failed login
>> attempts, where X is an arbitrary number.
> Don't think there is a way to do that.
> Perhaps using an authentication mechanism that supports that and then using
> it to
Le 06/04/2010 20:45, Francisco Reyes a écrit :
> Kevin Crain writes:
>
>> How do I configure postgres to lock a user's account after X failed
>> login attempts, where X is an arbitrary number.
>
> Don't think there is a way to do that.
> Perhaps using an authentication mechanism that supports tha
scheu dba wrote:
> - when remote_server entry exists in /etc/hosts file, the
> connexionis immediate
> - but when remote_server entry does not exists in /etc/hosts file,
> the connexion take 1 minute
You might want to check that the server has a reverse DNS entry (to
map the IP address back to
Timothy Madden wrote:
> The machine does not have internet
It would be very unusual for a machine never to be connected to a
network which has Internet access, at least for periodic OS updates
or to get new versions of the database or software. But OK, if you
say they are never, ever connecte
27 matches
Mail list logo
