Re: [ADMIN] Stumped by a version conflict.

Hi Greg... On Fri, Jul 16, 2010 at 10:29 PM, Greg Smith 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 reported

Re: [ADMIN] Stumped by a version conflict.

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 PG_

Re: [ADMIN] Stumped by a version conflict.

On Fri, Jul 16, 2010 at 10:14 PM, Scott Marlowe wrote: > On Fri, Jul 16, 2010 at 11:10 PM, Patric Michael > wrote: > > Scott... > > > > On Fri, Jul 16, 2010 at 5:48 PM, Scott Marlowe > > wrote: > >> > >> So what does > >> > >> sudo locate postgresql.conf > >> > >> say? > > > > That I am irredeem

Re: [ADMIN] Stumped by a version conflict.

On Fri, Jul 16, 2010 at 11:10 PM, Patric Michael wrote: > Scott... > > On Fri, Jul 16, 2010 at 5:48 PM, Scott Marlowe > wrote: >> >> So what does >> >> sudo locate postgresql.conf >> >> say? > > That I am irredeemably lazy as an admin?  :) Lazy isn't always bad. Sometimes it makes you an effici

Re: [ADMIN] Stumped by a version conflict.

Scott... On Fri, Jul 16, 2010 at 5:48 PM, Scott Marlowe wrote: > > 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 /home/postgres/da

Re: [ADMIN] Stumped by a version conflict.

On Fri, Jul 16, 2010 at 6:08 PM, Patric Michael 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 > change where an em

Re: [ADMIN] Stumped by a version conflict.

* 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

Re: [ADMIN] Stumped by a version conflict.

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) w

Re: [ADMIN] Stumped by a version conflict.

* Tom Lane (t...@sss.pgh.pa.us) wrote: > On most modern Unixen it's perfectly possible for an existing process to > continue to run an executable that's been deleted from the filesystem. Indeed, but it's not generally a good thing. I'd recommend installing something which checks for such things a

Re: [ADMIN] Stumped by a version conflict.

Patric Michael 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 have deleted the ol

Re: [ADMIN] Stumped by a version conflict.

On Fri, Jul 16, 2010 at 4:08 PM, Scott Marlowe wrote: > On Fri, Jul 16, 2010 at 4:31 PM, Patric Michael > 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 unrecognized > > tcpip_socket parame

Re: [ADMIN] Stumped by a version conflict.

On Fri, Jul 16, 2010 at 4: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 me

Re: [ADMIN] Stumped by a version conflict.

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 ma

[ADMIN] Stumped by a version conflict.

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 routin

Re: [ADMIN] How to move a database from HP server to Linux Server that had already one database.

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 ca

Re: [ADMIN] How to move a database from HP server to Linux Server that had already one database.

"ENGEMANN, DAYSE" wrote: > Kevin Grittner 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 to dump in custom format, yeah, you would

Re: [ADMIN] How to move a database from HP server to Linux Server that had already one database.

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

Re: [ADMIN] How to move a database from HP server to Linux Server that had already one database.

"ENGEMANN, DAYSE" wrote: > I have a HP Server with a postgres database, and I need to > transfer it to another server > What is the easy way to do it? pg_dump | psql -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.

[ADMIN] How to move a database from HP server to Linux Server that had already one database.

Hi, I have a HP Server with a postgres database, and I need to transfer it to another server, but it is a Linux server and there is a database that needs be preserved. Both have PGDATA=/postgres The database is about 150 MB. What is the easy way to do it? thanks

Re: [ADMIN] secret key for encryption

On Fri, Jul 16, 2010 at 10:26 AM, Craig James wrote: > On 7/16/10 10:14 AM, Kris Deugau wrote: >> >> Craig James wrote: >>> >>> 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.

Re: [ADMIN] secret key for encryption

Kris, [Replying to list, too.] On 7/16/10 10:14 AM, Kris Deugau wrote: Craig James wrote: 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 w

[ADMIN] secret key for encryption

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 m

Re: [ADMIN] Weird sorting order

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 Organization: Topex To: pgsql-admin@postgresql.org Hi... I have the followin

Re: [ADMIN] conditional backup

suhailck 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 the -s and -t swit

Re: [ADMIN] Weird sorting order

Robert Voinea 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 > 11

Re: [ADMIN] Setting up a warm standby server - some questions

On Fri, 2010-07-16 at 15:06 +0200, Thomas Kellerer wrote: > 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".

Re: [ADMIN] Setting up a warm standby server - some questions

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 recommende

Re: [ADMIN] Postgres Monitoring Tool we can use

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 To: pgsql-admin@postgresql.org Subject: [ADMIN] Postgres Monitorin

[ADMIN] Postgres Monitoring Tool we can use

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) Confide

[ADMIN] Weird sorting order

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'), (DEFAULT

[ADMIN] conditional backup

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 do

Re: [ADMIN] postgres data permission

On Fri, Jul 16, 2010 at 12:30 AM, Jim Montgomery wrote: > Remove me from your email chain please > I will react very badly if I recieve any more emails from you. > Jim Montgomery, This is the second message of this form I have received from you. Tom Lane recently suggested that you unsubscribe fr

Re: [ADMIN] postgres data permission

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; pgsql-admin@postgre

Re: [ADMIN] postgres data permission

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

Re: [ADMIN] postgres data permission

2010/7/15 David Bear : > 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 disk but not much