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 > wrote: > >> Hi >> >> >> >> I am a DBA at the Un

[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 s

[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 wrote: > JD Wong wrote: > >>> Hi Adrian, yes I completely copied the config-file and data directories > >>&g

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

tgres and pg_ctl to start the "new" one. Thanks! -JD On Tue, Feb 26, 2013 at 6:32 PM, Lonni J Friedman wrote: > 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

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 wrote: > On Tue,

[GENERAL] broke postgres, how to fix??

#x27;t start... How can I fix this? re-creating these databases with the old 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 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: datna

[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