Here is something I just developed to solve the problem of killing
connections prior to dropping:
kill `ps auxww | grep 'postgres: postgres ' | grep -v 'grep'
| perl -F"\s+" -ane 'print "$F[1] ";'`
Basically, this takes a process listing, finds all entries
corresponding to connections to the t
Hello all
My system use version 7.1.2 (OK ! I know it's time to upgrade do 8.0.1
version. But, I'am happy to use yet postgresql)
I had a problem with a hard drive 100% full.
The system is OK now, but I discovered 10 files approximately 1 GB each in a
directory /var/lib/pgsql/data/base/## nam
Can I do a cross tablespaces queries?
If can't, I think that this is a good feature to implement in this
wonderful database.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Michel BELLON wrote:
> Hello all
>
> My system use version 7.1.2 (OK ! I know it's time to upgrade do 8.0.1
> version. But, I'am happy to use yet postgresql)
> I had a problem with a hard drive 100% full.
> The system is OK now, but I discovered 10 files approximately 1 GB each in a
> directory
Michel BELLON <[EMAIL PROTECTED]> writes:
> My system use version 7.1.2 (OK ! I know it's time to upgrade do 8.0.1
> version. But, I'am happy to use yet postgresql)
> I had a problem with a hard drive 100% full.
> The system is OK now, but I discovered 10 files approximately 1 GB each in a
> dire
pkill -f 'postgres: postgres '
Much cleaner than the previous recipe for those with pkill.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
---(end of bro
Am Freitag, 25. Februar 2005 15:42 schrieb Sabio - PSQL:
> Can I do a cross tablespaces queries?
Sure.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settin
On Fri, 2005-02-25 at 08:42, Sabio - PSQL wrote:
> Can I do a cross tablespaces queries?
> If can't, I think that this is a good feature to implement in this
> wonderful database.
Are you sure you mean tablespaces? Maybe you mean cross database (use
dblink) or cross schema?
>From the point of v
Yes, I am working with PostgreSQL 8.0 over linux, and make some
tablespaces but I can't query any other tablespaces with same JDBC
connection.
Scott Marlowe wrote:
On Fri, 2005-02-25 at 08:42, Sabio - PSQL wrote:
Can I do a cross tablespaces queries?
If can't, I think that this is a good feat
I know PostgreSQL favorite platform is Linux. Management at my workplace
might is interested on trying PostgreSQL on Solaris. To me, it's like
moving Oracle from Solaris platform to IBM AIX platform. PostgreSQL
should work fine in either platforms; however the vast majority of
implementation (and
Tomeh, Husam wrote:
> I know PostgreSQL favorite platform is Linux. Management at my workplace
> might is interested on trying PostgreSQL on Solaris. To me, it's like
> moving Oracle from Solaris platform to IBM AIX platform. PostgreSQL
> should work fine in either platforms; however the vast major
I have some questions and would like help.
(1) Audit practice
Is there a good source of information about audit for postgresql
databases?
Specifically I'd like some advice on these:
(2) Associating a statement with a database connection
I'm logging statements and connections, but it seems the
Ben Kim <[EMAIL PROTECTED]> writes:
> Is there a way to associate them so I know which statement came from which
> connection?
Log the PID originating each message.
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe
unsubscribe
Solaris is highly attuned to running threaded applications, and
PostgreSQL is not that sort of application. So you're definitely not
playing to Solaris' strengths.
Solaris is one of the platforms that has been noted for suffering from
context switch slowdowns when hit with a lot of concurrent tra
15 matches
Mail list logo
