http://bytes.com PostgreSQL ORDBMS database - Get answers to questions about PostgreSQL development, administration replication, clustering, connection pooling, tables, indexes, databases, performance, SQL, queries and more. en Fri, 20 Nov 2009 22:28:43 GMT vBulletin 60 http://bytes.com/images/misc/rss.jpg http://bytes.com http://bytes.com/topic/postgresql/answers/877367-multiple-instances-postgresql-same-server Fri, 20 Nov 2009 15:16:49 GMT I need to compile PostgreSQL 8.3.5 on CentOS 4.2. The CentOS already has PostgreSQL 7 installed as part of its default installation. For some reason,... I need to compile PostgreSQL 8.3.5 on CentOS 4.2. The CentOS already has PostgreSQL 7 installed as part of its default installation. For some reason, I cannot touch the existing PostgreSQL (upgrading, etc) --I really need to use my own compilation of PostgreSQL.

Is it possible to have multiple installations of PostgreSQL (and different version too) on the same server?

At least in theory, I should use a different port for my own PostgreSQL -- that's not a problem. I also need to use different database cluster, and that's not a problem either, since my data directory will be /usr/local/pgsql/data instead of /var/lib/pgsql/data.

But again, is it possible to have two installations of PostgreSQL on the same server? Port and database cluster aside, what else should I consider? Could you share tips and warnings? ]]> answers Kreshna http://bytes.com/topic/postgresql/answers/877367-multiple-instances-postgresql-same-server http://bytes.com/topic/postgresql/answers/877141-what-good-approach-postgresql-database-backups Tue, 17 Nov 2009 05:20:09 GMT Hello, *What is a good approach to PostgreSQL backups?* (yep, a newbie) (The server crashed and IT was not able to bring it back from the... Hello,

What is a good approach to PostgreSQL backups? (yep, a newbie)

(The server crashed and IT was not able to bring it back from the Acronis images - so rebuilding from scratch - ugh! - want to have a secondary system, that lesson is learnt!)

Ideally, having the compressed backup that pgAdmin is able to do run on some sort of Task Scheduler would be ideal... but seemingly no functionality for this...

So presumably write a DOS (sic) script to do a pg_dump once a week for every database and a pg_dumpall for the whole cluster (so I get the groups, roles, etc) say every month?? (to a separate network location)

Is there a 'lessons learned' style documentation online that I can ingest?

I was reading about Slony - but for the size of the database cluster (at least presently) it seems overkill? Or should I look at that?

Thanks in advance for any pointers, documentation links, etc...

Cheers:
GREG... ]]> answers scubak1w1 http://bytes.com/topic/postgresql/answers/877141-what-good-approach-postgresql-database-backups http://bytes.com/topic/postgresql/answers/877139-pgadmin-maintenance-cannot-open-logfile Tue, 17 Nov 2009 05:09:19 GMT Hello,

Did a search here, manuals and Googled, etc generally, so apologies if I did not find the answer to my issue - that is, I try and 'self help' as mush as I can...

I adjusted my postgresql.conf file to set as on 'explain_pretty_print'

Now in pgAdmin (1.10.0) when I right-click a database in the 'usual' way, Maintenance, any of the tasks, its starts OK, but I get a dialogue box up every (seeming) operation that the Maintenance is doing "Fatal Error - Cannot open the logfile - OK", click OK, it moves on - and then again, again, again... as you can imagine, clicking OK >>100 times is "not efficient"... :-)

I stopped the PostgreSQL service in Windows Server 2008, replaced the postgresql.conf file with the pre-change backup I made, restarted the Windows PostgreSQL service - same error

Did a reboot of the server - same error

Help! What is the log file it is referring to? How come it is not able to see it all of a sudden? I am (now) using the default postgresql.conf and so not verbose logs or some such... No permissions were changed in Windows - and no other changes were made in the PostgreSQL settings...

The databases otherwise appear to be working fine (e.g., I have some web pages writing data to them via PHP, all seems good..)

Thanks in advance...

Cheers,
GREG... ]]> answers scubak1w1 http://bytes.com/topic/postgresql/answers/877139-pgadmin-maintenance-cannot-open-logfile http://bytes.com/topic/postgresql/answers/875957-pg_type Fri, 23 Oct 2009 07:43:48 GMT I want to see the type created for running a function. please tell me the query for this. i tried for : select * from pg_type where... I want to see the type created for running a function.

please tell me the query for this.

i tried for :

select * from pg_type where typname=' ';

is it right or wrong. if wrong please send me the appropriate query.


thank you ]]> answers jesmi http://bytes.com/topic/postgresql/answers/875957-pg_type