Re: [GENERAL] Using pg_start_backup() and pg_stop_backup() - using 9.1.2.2

-Original Message- From: Kevin Grittner [mailto:kgri...@ymail.com] Sent: Saturday, June 14, 2014 8:16 PM To: Khangelani Gama; pgsql-general@postgresql.org Subject: Re: [GENERAL] Using pg_start_backup() and pg_stop_backup() - using 9.1.2.2 Khangelani Gama wrote: > I am doing the following

Re: [GENERAL] Designing a DB for storing biological data

Thank you both for the valuable input. I was not aware of EPA's STORET, EMAP projects nor ITIS. Beginning of next week I'll search for details and probably I'll get back with some questions. Regarding diploma theses or master, etc. > I may be wrong, but this looks like a question from a student

Re: [GENERAL] Using pg_start_backup() and pg_stop_backup() - using 9.1.2.2

On 06/14/2014 06:44 AM, Khangelani Gama wrote: Hi all Please help me here. I would say the best way to help is to figure out what it is you want out of the master/standby/archive setup before getting into the actual configuration. What do you want to do with the standby/archive? 1) Do yo

Re: [GENERAL] Using pg_start_backup() and pg_stop_backup() - using 9.1.2.2

On 06/14/2014 11:15 AM, Kevin Grittner wrote: Khangelani Gama wrote: I am doing the following between master and the backup server using archive_command, I'm not sure what that means. Do you mean that while performing the steps you describe, an archive command was active, copying WAL files

Re: [GENERAL] Designing a DB for storing biological data

On Sat, 14 Jun 2014, Damir Dezeljin wrote: I am designing a database for storing various biological and ecological data. Although there is no clear dividing line, it is possible to group the data into two groups, namely the measured (physical) and quantitative (mostly biological) data; I lef

Re: [GENERAL] Designing a DB for storing biological data

On Sat, 14 Jun 2014, Damir Dezeljin wrote: This is more a theoretical or better to say, conceptual question; still, I hope to get some feed backs from you folks. Additionally this is going to be a very long post :) off-topic: I asked a similar question on the MySQL forum as I'm still undecided i

Re: [GENERAL] Using pg_start_backup() and pg_stop_backup() - using 9.1.2.2

Khangelani Gama wrote: > I am doing the following between master and the backup server > using archive_command, I'm not sure what that means.  Do you mean that while performing the steps you describe, an archive command was active, copying WAL files to an archive directory? > On backup or secon

Re: [GENERAL] Designing a DB for storing biological data

On 06/14/2014 08:52 AM, Damir Dezeljin wrote: Hello. This is more a theoretical or better to say, conceptual question; still, I hope to get some feed backs from you folks. Additionally this is going to be a very long post :) off-topic: I asked a similar question on the MySQL forum as I'm still u

[GENERAL] Designing a DB for storing biological data

Hello. This is more a theoretical or better to say, conceptual question; still, I hope to get some feed backs from you folks. Additionally this is going to be a very long post :) off-topic: I asked a similar question on the MySQL forum as I'm still undecided if going with PostgreSQL or MySQL << I'

[GENERAL] Using pg_start_backup() and pg_stop_backup() - using 9.1.2.2

Hi all Please help me here. I am doing the following between master and the backup server using archive_command, I am using O/S - Red Hat Enterprise Linux Server release 5.3 (Tikanga) On backup or secondary server I did the following: 1. Stopped postgres in backup server