Re: [ADMIN] Checking Postgres Version Question

2008/8/28 John <[EMAIL PROTECTED]>: > Hi, > > Is there a way to check which version of Postgres is installed on a > particular Linux box without query the RPM database? > > For instance, is there a "psql --version" command, or something similar, > that I can use? > > Thanks, > John > > -- > Sent vi

Re: [ADMIN] How to re-own db cluster

On 15/02/2008, Vikram Vincent <[EMAIL PROTECTED]> wrote: > > Hello, > I was trying to install a student information system called Centre which > failed to connect to postgres for reasons I have still been unable to > isolate. In order to restart the entire procedure of installation of > database an

Re: [ADMIN] 8.3.0 upgrade, confused by documentation

lso cause problems as the reload may take much longer than the dump and the two together will be slower. Peter Childs Regards, > > Tena Sakai > [EMAIL PROTECTED] > > > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] <[EMAIL PROTECTED]>] > Sen

Re: [ADMIN] jumpstart - pgsql.v824

On 02/11/2007, dx k9 <[EMAIL PROTECTED]> wrote: > > Hi Everyone, > > Is there any way to trick an instance into starting when you just have > base, global, pg_clog, pg_mulitxact, pg_subtrans, pg_tblspc, & pg_twophase, > but no pg_xlog? > > We weren't backing up the pg_xlog, because we didn't thin

Re: [ADMIN] Catalog insertion

On 10/07/07, Carmen Martinez <[EMAIL PROTECTED]> wrote: I know all you say, but we actually are trying to extend the postresql with new data types, and they must be theorically in the system catalog. Also, these new data types go with some functions for manage it. We have also implemented this

Re: [ADMIN] online tape backup

On 13/02/07, Michael Monnerie <[EMAIL PROTECTED]> wrote: On Samstag, 10. Februar 2007 01:51 Eduardo J. Ortega wrote: > 1) pg_start_backup > 2) tar to my tape device /data/postgresql excluding > /data/postgresql/pg_xlog 3) pg_stop_backup > 4) delete WAL files under /data/pg_trans_log/ (which is th

Re: [ADMIN] Drop All Index

On 27/11/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote: Marcelo Costa wrote: > Hi to all, > > Anybody can help me how to proced to delete all index from my database, > exists any command to this ? Sure, you can create a PL/pgSQL function that loops around a "select relname from pg_class where rel

Fwd: [ADMIN] COPY FROM command v8.1.4

Sorry Tom, Somone had not put the reply to header in correctly.. -- Forwarded message -- From: Peter Childs <[EMAIL PROTECTED]> Date: 12-Sep-2006 10:16 Subject: Re: [ADMIN] COPY FROM command v8.1.4 To: Tom Lane <[EMAIL PROTECTED]> On 11/09/06, Tom Lane <[

Re: [ADMIN] Running Postgres on CD - With Win32

If all you want is a client you should just be able to write it and it will connect to the server and work. The client does not need to write just the server. Peter ChildsOn 29/12/05, Dennis Wagner <[EMAIL PROTECTED]> wrote: Hi everybody!I was using Postgres for quite some time now without any pr

Re: [ADMIN] 7.4 <-> 8.0

does an index lookup. Peter Childs -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDKvMKJWgkOaNnHdMRAsBEAKCv3ZWdy1a4+qQG0U9Ov85TPCembQCfazPH QVPj5xEDPSumy1Z4FUSTgf4= =As1l -

[ADMIN] Debian Install 7.4

I better off using source code like I did under Redhat... Peter Childs ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Trigger to call an external program

On Thu, 4 Dec 2003, Alan Graham wrote: > I'm doing a low cost, low performance roll your own replication project, > between various offices around Australia. The replication is > asynchronous, and peer to peer. I've looked at the various replication > projects, and for one reason or another, t

Re: [ADMIN] see previous queries

ake a long time. The logs go either to file or the system message log. depending on how you set it up in postgresql.conf. The log can not be used to rebuild your database :( psql also has a shell like history function. Peter Childs ---(end of broadcast)-

Re: [ADMIN] PK and FK relation ship

d list or double linked list. Find any standard algorithims book and try and implement the lot in a database. (Its not easy as SQL has a lot of missing features that even C, C++ or even VB has!) Peter Childs ---(end of broadcast)--- TIP

Re: [ADMIN] postgreSQL users = LDAP users?

tion on ldap and pam. As I've been try to set it up for months unsucsessfully. All the web sites I've seen are a little uncomprohensable. Sorry this is a little off topic. Peter Childs ---(end of broadcast)--- TIP 6

Re: [ADMIN] interpret vacuum verbose output

Keep (Not Sure) CPU Time taken to complete vacuum. So Tuples + Unused = Total Tuples used in table. Hence (Tuples + Unused)/Pages = Number of Records per page hence record size If deleted gets too big you should be vacuuming more often If unused gets too big try and increase your f

Re: [ADMIN] list schema

rd because currently sql is a broken standard with out this meta infomation. Peter Childs ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])