Re: [GENERAL] Postgres HA

Here is the option for HA i.e. EDB failover manager. https://www.enterprisedb.com/docs/en/2.1/edbfm/EDB_Failover_Manager_Guide.1.02.html On Thu, Feb 23, 2017 at 10:08 AM, Venkata B Nagothi wrote: > > On Thu, Feb 23, 2017 at 9:58 AM, Dylan Luong >

[GENERAL] : :Full text search query ::

Hi All, please find herewith the following query 1. select * from partdetails where scode=118 and (to_tsvector('english'::regconfig, part_number::text)) @@ to_tsquery('104') it is showing only 1 record as output, it is expected to give 17 records as output. 2. select * from partdetails where

[GENERAL] Sharing data directories between machines

postgresql.confs to that one. I was able to have both access the same databases, but they can't share changes. It's like they're running on two separate data directories, even though show data_directory reports the same path for each. How can I make them play nicely? Thanks! -JD

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 laurenz.a...@wien.gv.atwrote: JD Wong wrote: Hi Adrian, yes I completely copied the config-file and data directories over

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

Hi Adrian, That's guaranteed to break everything badly. Even if I read only style copied the files? Do you mind elaborating on why this happens? ( or point me to relevant documentation ) Thanks, -JD On Tue, Feb 26, 2013 at 7:04 PM, Lonni J Friedman netll...@gmail.comwrote: On Tue, Feb 26

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

the new one. Thanks! -JD On Tue, Feb 26, 2013 at 6:32 PM, Lonni J Friedman netll...@gmail.comwrote: Did you shut down the 'old' postgres before copying these files? Did you (re)configure the 'new' postgres to set its $PGDATA directory to the location of the 'new' files? On Fri, Feb 22, 2013 at 3

[GENERAL] broke postgres, how to fix??

postgres didn't work... Also, why did this happen? I created a new data directory for the new postgres, this should be impossible I have no ideas left, can anyone help? Thanks in advance, -JD

[GENERAL] IDLE queries taking up space

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

[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: datname

[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

[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] could not connect error

Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PGSQL.5432? I reinstalled the database with no difference, does anyone know how I may resolve the issue? Thanks in advance. JD