2010/7/15 David Bear david.b...@asu.edu:
this doesn't make sense. why go through the overhead of smb to get to a
database cluster over a network connection when pg can already work over
tcpip sockets and work much more switfly on a local file system?
Lets say you have to boxes:
#1: lots of
David Bear ha scritto:
this doesn't make sense. why go through the overhead of smb to get to
a database cluster over a network connection when pg can already work
over tcpip sockets and work much more switfly on a local file system?
2010/7/15 Silvio Brandani silvio.brand...@tech.sdb.it
Remove me from your email chain please
I will react very badly if I recieve any more emails from you.
From: wult...@gmail.com
Date: Fri, 16 Jul 2010 00:14:45 -0700
Subject: Re: [ADMIN] postgres data permission
To: david.b...@asu.edu
CC: silvio.brand...@tech.sdb.it;
Hi,
I need to take backup of my postgresql DB, but not all records from a few
tables.
My DB contains more than 700 tables, out of which 15 tables i need to take
this conditional backup
Example:
Table: C_order
I need to take backup from table C_order where period=2009 and org A
This is done to
Hi...
I have the following table:
CREATE TABLE test
(
id SERIAL PRIMARY KEY,
val VARCHAR(32) NOT NULL
);
INSERT INTO test VALUES
(DEFAULT, '##34''),
(DEFAULT, '##32'),
(DEFAULT, '##31'),
(DEFAULT, '2ff'),
(DEFAULT, '##26'),
Hi
Can someone suggest the best monitoring tool we can use in out enterprise db
running on version 8.3 with Linux Redhat 5.
We just need something that can tell us if there is any activity inside the
database and what that activity is.
Thanks in Advanced
Khangelani (Junior DBA)
pgadmin3 could be an option.
Server status will tell you what queries are being running, from what
clients, and what tables are being locked.
It should come with your linux distro.
-Original Message-
From: Khangelani Gama khangelani.g...@ucs-software.co.za
To: pgsql-admin@postgresql.org
Hello,
I could solve one of the questions myself :)
I have also problems shutting down the secondary server while it is in
standby (i.e. recovery) mode
This works fine when using -m fast instead of -m immediate.
I would still like an answer on these questions:
What is the recommended way
Robert Voinea robert.voi...@topex.ro wrote:
Why is it that when running the query:
SELECT * FROM test ORDER BY val;
I get the following result?
id | val
+---
1 | 200
2 | 201
3 | 202
4 | 203
5 | 210
6 | 211
7 | 2##23
8 | 2##24
9 | 2##25
10 | 2##33
suhailck suhai...@gmail.com wrote:
I need to take backup of my postgresql DB, but not all records
from a few tables.
You can exclude particular tables from a database backup using the
-T option (which can be included multiple times). You can dump just
the schema for particular tables with
It's ignoring the hash marks. It's like they are invisible characters.
Tested on 8.1.16
Original Message
Subject: [ADMIN] Weird sorting order
Date: Fri, 16 Jul 2010 15:14:09 +0300
From: Robert Voinea robert.voi...@topex.ro
Organization: Topex
To: pgsql-admin@postgresql.org
This isn't exactly a Postgres question, but I hope someone in the community has
solved it.
I want to encrypt some data in Postgres that arrives from Apache. How do you
store an encryption key in such a way that Apache CGIs can get it, but a hacker
or rogue employee who manages to access the
And to restore it.. Can I use pg_restore -d new_db_name ??
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: sexta-feira, 16 de julho de 2010 14:47
To: ENGEMANN, DAYSE; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How to move a database from HP server
ENGEMANN, DAYSE dayse.engem...@hp.com wrote:
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
pg_dump | psql
And to restore it.. Can I use pg_restore -d new_db_name ??
I usually pipe the output of pg_dump to psql, and thereby avoid
making a copy of the dump output entirely. If you want
I am not sure if I can do it in this way.. As the are in diferent servers and
network.
I found a paper that suggest to use pg_dump -Ft -b db_name file.tar
Transfer it to new server and you ther the pg_restore -d new_db file.tar
But as the servers have different SO.. I am not sure if it
Hi all...
I joined this list in an effort to solve a puzzle I fail to understand.
Thank you in advance for taking the time to read.
I've been managing a domain for the last eight years as an erstwhile
administrator. Erstwhile meaning it is largely a matter of setting up and
automating the
On 7/16/10 3:31 PM, Patric Michael wrote:
Hi all...
I joined this list in an effort to solve a puzzle I fail to understand.
Thank you in advance for taking the time to read.
I've been managing a domain for the last eight years as an erstwhile
administrator. Erstwhile meaning it is largely a
On Fri, Jul 16, 2010 at 4:31 PM, Patric Michael bluesta...@gmail.com wrote:
Hi all...
I joined this list in an effort to solve a puzzle I fail to understand.
Thank you in advance for taking the time to read.
I've been managing a domain for the last eight years as an erstwhile
administrator.
On Fri, Jul 16, 2010 at 4:08 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Fri, Jul 16, 2010 at 4:31 PM, Patric Michael bluesta...@gmail.com
wrote:
Everything came back up as expected, with the exception of postgres.
When I
went to start it manually, I got an error warning of an
Patric Michael bluesta...@gmail.com writes:
HI Scott. I think if anything, the reverse is true. It is entirely
possible that I started 7.4 in a different directory by hand and that the
7.4 server had been running all this time. Since I can't find any other
instances pf pg_ctl, I may well
Thank you Tom, and I do agree in theory, but I am still unconvinced that
something else isnt amiss because I do recall having to rewrite the web
scripts which access the database, after I upgraded. Seems there was a
change where an empty field no longer returned a zero but a null (or vice
versa)
* Patric Michael (bluesta...@gmail.com) wrote:
Is there any way for me to tell *without* postmaster or psql running, aside
from the contents of PG_VERSION?
pg_controldata, as Tom suggested...
Stephen
signature.asc
Description: Digital signature
On Fri, Jul 16, 2010 at 6:08 PM, Patric Michael bluesta...@gmail.com wrote:
Thank you Tom, and I do agree in theory, but I am still unconvinced that
something else isnt amiss because I do recall having to rewrite the web
scripts which access the database, after I upgraded. Seems there was a
Scott...
On Fri, Jul 16, 2010 at 5:48 PM, Scott Marlowe scott.marl...@gmail.comwrote:
So what does
sudo locate postgresql.conf
say?
That I am irredeemably lazy as an admin? :)
/usr/share/pgsql/postgresql.conf.sample
/var/lib/pgsql/data/postgresql.conf
/home/archives/db/postgresql.conf
On Fri, Jul 16, 2010 at 11:10 PM, Patric Michael bluesta...@gmail.com wrote:
Scott...
On Fri, Jul 16, 2010 at 5:48 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
So what does
sudo locate postgresql.conf
say?
That I am irredeemably lazy as an admin? :)
Lazy isn't always bad.
On Fri, Jul 16, 2010 at 10:14 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Fri, Jul 16, 2010 at 11:10 PM, Patric Michael bluesta...@gmail.com
wrote:
Scott...
On Fri, Jul 16, 2010 at 5:48 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
So what does
sudo locate
Patric Michael wrote:
/usr/share/pgsql/postgresql.conf.sample
/var/lib/pgsql/data/postgresql.conf
/home/archives/db/postgresql.conf
/home/postgres/data/postgresql.conf
The first line is the --datadir as reported by pg_configure --configure
The second line is the 7.4 data dir according to its
Hi Greg...
On Fri, Jul 16, 2010 at 10:29 PM, Greg Smith g...@2ndquadrant.com wrote:
Patric Michael wrote:
/usr/share/pgsql/postgresql.conf.sample
/var/lib/pgsql/data/postgresql.conf
/home/archives/db/postgresql.conf
/home/postgres/data/postgresql.conf
The first line is the --datadir as
28 matches
Mail list logo
