[GENERAL] broke postgres, how to fix??

I tried copying postgres over to a new directory. it was working until I deleted a bunch of databases from the "old" postgres. Lo and behold this somehow broke the "new" copy too. Now when I start with pg_ctl 2013-02-22 18:36:13 EST DETAIL: The database subdirectory "base/1066060" is missing. 2

Re: [GENERAL] broke postgres, how to fix??

Feb 26, 2013 at 4:02 PM, JD Wong wrote: > > Hi Adrian, yes I completely copied the config-file and data directories > > over. > > > > Lonnie, I don't remember. I might not have shut down the "old" postgres, > > yes I set PGDATA accordingly. > > > That's guaranteed to break everything badly. >

Re: [GENERAL] broke postgres, how to fix??

location of the 'new' files? > > On Fri, Feb 22, 2013 at 3:46 PM, JD Wong wrote: > > I tried copying postgres over to a new directory. it was working until I > > deleted a bunch of databases from the "old" postgres. Lo and behold this > > somehow brok

Re: [GENERAL] broke postgres, how to fix??

Thank you everybody for your help, This problem has been resolved, in part to your insights. All the best, -JD On Fri, Mar 1, 2013 at 4:31 AM, Albe Laurenz wrote: > JD Wong wrote: > >>> Hi Adrian, yes I completely copied the config-file and data directories > >>&g

[GENERAL] Sharing data directories between machines

Hi all! I have two servers, which share a large mounted drive. I would like to share postgres databases between them dynamically so that when one makes changes, they are immediately available in the other. I tried moving the data directory over to the mounted drive, and pointing both postgresql.

[GENERAL] could not connect error

Hey, I'm a first time postgres user. I was able to access yesterday a database I had loaded that same day until the system was shut down without warning. Now I get the error: createdb: could not connect to database postgres: could not connect to server: No such file or directory Is t

[GENERAL] dropdb: database removal failed: active sessions

Hi, I cannot dropdb. Postgres throws me: dropdb: database removal failed: ERROR: database "database1" is being accessed by other users DETAIL: There are 1 other session(s) using the database. the "select datname,current_query,query_start from pg_stat_activity ;" query gives me: datna

[GENERAL] IDLE queries taking up space

Hi, When I run select datname, procpid, current_query from pg_stat_activity; I get 26 rows of queries. How can I set postgres to qutomatically close connections that have finished their queries and now sit idle? Thanks! -JD

[GENERAL] plperl installation

Hey all I'm want to use plperl but directory does not exist and I did not specifically enable it during installation. -Does anybody know how to install it post-install? Thanks -JD

[GENERAL] [PERL DBI] Insertiing data across multiple tables

Does anybody know how to insert data over multiple tables transactionally? The relationship is 1:1 with the latter table having a foreign key constraint. In order to add data to Table2 I need to know the primary key value of the same record in Table1 before it's committed, which in this case is a