Thank you very much for sharing this nohup command. That's really
helpful.
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Friday, April 02, 2010 7:09 PM
To: pgsql-admin@postgresql.org; gna...@zoniac.com
Subject: Re: [ADMIN] Database clone stuck in the
Thank you very much for sharing this screen command. That's really
helpful.
-Original Message-
From: Guillaume Lelarge [mailto:guilla...@lelarge.info]
Sent: Friday, April 02, 2010 7:32 PM
To: Kevin Grittner
Cc: pgsql-admin@postgresql.org; gna...@zoniac.com
Subject: Re: [ADMIN] Database
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
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
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
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 .
On 6 April 2010 15:22, Renato Oliveira renato.olive...@grant.co.uk 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:
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,
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
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
Timothy Madden terminato...@gmail.com 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
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
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
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
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
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:
Timothy Madden terminato...@gmail.com 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
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
Regards,
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
Jordz jordan.d.car...@gmail.com 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
On Thu, Apr 1, 2010 at 8:53 PM, Jordz jordan.d.car...@gmail.com 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
На 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 role CONNECTION LIMIT number;
(http://www.postgresql.org/docs/current/static/sql-alterrole.html)
--
Milen A. Radev
--
Sent via pgsql-admin
Francisco Reyes li...@stringsutils.com 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
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 that and
scheu dba scheu.postgre...@gmail.com 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
Timothy Madden terminato...@gmail.com 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
28 matches
Mail list logo