Re: [ADMIN] Using the /var/lib/pgsql/data directory in the absense

On Tue, 22 Jul 2003, Srinivas Kotapally wrote: > I am a newbie PostgreSQL DB admin. I have the following problem: > 1. I have a redhat 8 box which has postgres installed. > 2. I have reinstalled postgresql 7.2.1-5 (native postgres installation on > RedHat 7.3) on the redhat 8.0 > 3. I don't have

Re: [ADMIN] using ssl some of the time

On Wed, 23 Jul 2003, Bruce Momjian wrote: > Charles Hornberger wrote: > > Am I right in interpreting this to mean that I either have to use SSL > > all the time or none of the time? I'm especially tempted to believe > > this might be the case after seeing this item in the "Clients" section > >

Re: [ADMIN] using ssl some of the time

Charles Hornberger wrote: > Am I right in interpreting this to mean that I either have to use SSL > all the time or none of the time? I'm especially tempted to believe > this might be the case after seeing this item in the "Clients" section > of http://developer.postgresql.org/todo.php: > >

Re: [ADMIN] Replication/Failover/HA solution

Does it just slightly depend on java or is the whole package developed in java. I generally prefer solutions based on C and C++ because of the performance advantage and they are nice and compact and can be packaged up into a nice executable or shared library. I have had very bad experiences

Re: [ADMIN] [PERFORM] Wrong plan or what ?

Gaetano, > SELECT * from user_logs where id_user in ( > 10943, 10942, 10934, 10927, 10910, 10909 > ); > [SNIPPED] > Why the planner or the executor ( I don't know ) do not follow > the same strategy ? It is, actually, according to the query plan. Can you post the EXPLAIN ANALYZE fo

[ADMIN] Using the /var/lib/pgsql/data directory in the absense of a backup for recovery

Hello all I am a newbie PostgreSQL DB admin. I have the following problem: 1. I have a redhat 8 box which has postgres installed. 2. I have reinstalled postgresql 7.2.1-5 (native postgres installation on RedHat 7.3) on the redhat 8.0 3. I don't have the database backups from my 7.3 installation -

Re: [ADMIN] Documentation of Concepts

You will find it in the following links. It may not be as polished as Oracle's books, but still good. http://developer.postgresql.org/ * Flowchart of the PostgreSQL backend * Database Internals Presentation

Re: [ADMIN] Replication/Failover/HA solution

On Tue, Jul 22, 2003 at 05:25:28PM -0400, Andrew Biagioni wrote: > Sorry -- by "production", what release version do you mean? eRServer v1.0 A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <[EMAIL PROTECTED]>

[ADMIN] using ssl some of the time

I'm having a bit of trouble understanding exactly how SSL-encrypted connections are supposed to work -- and specifically whether it's possible to "use SSL some of the time." Here's what I want to do: 1) I want one of my web servers to be able to connect to the database without the overhead of

[ADMIN] slow table updates

I'm trying to update a table but it's taking a very long time. I would appreciate any tips folks may have about ways to speed it up. The table is paprospect2, as below: \d paprospect2    Column    |  Type   | Modifiers -+-+-

Re: [ADMIN] pg_restore problem!!!

Hi David- I don't use the -Fc or -Ft format exclusively because I ran into dependency problems with the order of object creation when trying to do a full database restore using pg_restore and these formats. Since we have a fair amount of space, I do both a tar format and a plain-text format dump

Re: [ADMIN] Replication/Failover/HA solution

Sorry, was an error... -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Santiago Matiz Enviado el: martes, 22 de julio de 2003 16:53 Para: Andrew Biagioni; [EMAIL PROTECTED]; Andrew Sullivan Asunto: Re: [ADMIN] Replication/Failover/HA solution psql [dbname a

Re: [ADMIN] Replication/Failover/HA solution

psql [dbname and various options] -f [filename] -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Andrew Biagioni Enviado el: martes, 22 de julio de 2003 16:25 Para: [EMAIL PROTECTED]; Andrew Sullivan Asunto: Re: [ADMIN] Replication/Failover/HA solution 7/22/03

Re: [ADMIN] Replication/Failover/HA solution

7/22/03 3:32:03 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote: >On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote: >> I am having a hard time selecting a Replication/Failover/HA solution for >> PGSQL. What is troubling is the number of solutions available in various >> states of deve

Re: [ADMIN] pg_restore problem!!!

Nick, > pg_dump dbname | gzip > dbdumpfile.gz > > gunzip -c dbdumpfile | psql dbname If you're compressing why not use: pg_dump -Fc dbname -f dbdumpfile pg_restore dbdumpfile ? Don't take this the wrong way, I'm genuinely curious! When I first started I didn't realize we did our dumps this w

Re: [ADMIN] How can I set a default schema for a session

On Tuesday 22 July 2003 22:52, Dilan Arumainathan wrote: > Hi, > Every time I have to specify a table name in a query I find myself > prefixing the name of the table with the schema name as in schema.table. Is > there a way to force the queries to look in one particular schema whenever > I do not s

Re: [ADMIN] pg_restore problem!!!

> To nit-pick, this is a "useless use of cat". > > In UNIX-land, simple input redirection will work much better: > > psql [dbname and various options] < [filename] Good point... to elaborate further, the reason I was in a piping mindset is that with a large database, it also makes sense to comp

Re: [ADMIN] How can I set a default schema for a session

On Tue, 22 Jul 2003, Dilan Arumainathan wrote: > Hi, > Every time I have to specify a table name in a query I find myself prefixing > the name of the table with the schema name as in schema.table. Is there a > way to force the queries to look in one particular schema whenever I do not > specify a

Re: [ADMIN] pg_restore problem!!!

Thank you. You saved my day!!! That command restores all my data into my DB.   MAGO  ---Mensaje original---   De: David Olbersen Fecha: Martes, 22 de Julio de 2003 03:02:48 p.m. A: [EMAIL PROTECTED] Asunto: Re: [ADMIN] pg_restore problem!!!  Nick,> To restore from a plain-text dump f

Re: [ADMIN] pg_restore problem!!!

Nick, > To restore from a plain-text dump file, just pipe it into > psql like so: > > cat [filename] | psql [dbname] To nit-pick, this is a "useless use of cat". In UNIX-land, simple input redirection will work much better: psql [dbname and various options] < [filename] It's also less to t

[ADMIN] How can I set a default schema for a session

Hi, Every time I have to specify a table name in a query I find myself prefixing the name of the table with the schema name as in schema.table. Is there a way to force the queries to look in one particular schema whenever I do not specify a schema name? thanks dilan ---(e

Re: [ADMIN] pg_restore problem!!!

Mago- pg_restore is used to restore a dump file created in one of the non-text formats such as tar format. To restore from a plain-text dump file, just pipe it into psql like so: cat [filename] | psql [dbname] -Nick - Nick Fan

[ADMIN] pg_restore problem!!!

I made a back up file with this sentence:   pg_dump -U [superusername] -C -D -f [filename]  [dbname]   It seems to work fine. I opened the file and I saw all the commands to insert every piece of data and reconstruct my schema. However when I try to restore that file it gets me the following

Re: [ADMIN] Replication/Failover/HA solution

On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote: > I am having a hard time selecting a Replication/Failover/HA solution for > PGSQL. What is troubling is the number of solutions available in various > states of development. Does the fact that dbmirror and rserv appear in > the con

Re: [ADMIN] [PERFORM] Wrong plan or what ?

"Josh Berkus" <[EMAIL PROTECTED]> > Gaetano, > > > QUERY PLAN > > Hash Join (cost=265.64..32000.76 rows=40612 width=263) (actual > > time=11074.21..11134.28 rows=10 loops=1) > >Hash Cond: ("outer".id_user = "inner".id_user) > >-> Seq Scan on user_logs ul (cost=0.00..24932.65 rows=125896

Re: [ADMIN] [PERFORM] Wrong plan or what ?

Forget my PS to last message. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] [PERFORM] Wrong plan or what ?

"Josh Berkus" <[EMAIL PROTECTED]> > Gaetano, > > > SELECT * from user_logs where id_user in ( > > 10943, 10942, 10934, 10927, 10910, 10909 > > ); > > [SNIPPED] > > > Why the planner or the executor ( I don't know ) do not follow > > the same strategy ? > > It is, actually, according to th

Re: RE : [ADMIN] common_fields: permission denied

On Tue, Jul 22, 2003 at 13:28:24 +0200, Olivier Reuland <[EMAIL PROTECTED]> wrote: > Hi Nick, > > I have done a "GRANT ALL PRIVILEGES ON DATABASE db1 TO user1". The message I > had back was "GRANT". But this was not enough, I had to give access to all > tables... The above granted user1 the abi

[ADMIN] Wrong plan or what ?

Hi all, I'm running Postgres7.3.3 and I'm performing this simple select: select * from user_logs ul, user_data ud, class_default cd where ul.id_user = ud.id_user and ud.id_class = cd.id_class and cd.id_provider = 39; these are the number of rows for each table: user_logs

RE : [ADMIN] common_fields: permission denied

Hi Nick, I have done a "GRANT ALL PRIVILEGES ON DATABASE db1 TO user1". The message I had back was "GRANT". But this was not enough, I had to give access to all tables... It's working now, thanks. Oliver > -Message d'origine- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] De la p