Re: Re(2): [ADMIN] db server is too slow, real slow

2000-10-19 Thread Stephan Szabo
On Fri, 20 Oct 2000, pgsql-admin wrote: > The postgres server was started with the command: > /usr/bin/postmaster -i -S -D/var/lib/pgsql Have you tried changing the values of -B to see if increasing the number of buffers helps? > Here is just one query executed from Embperl pages with Perl DBI:

Re: [ADMIN] binding to a specific IP address

2000-10-19 Thread Peter Galbavy
> No, not yet. I have a patch against 7.0, but it does not apply. I hope > to merge it in before 7.1 beta. Thanks - I'll wait :) Peter

Re: [ADMIN] binding to a specific IP address

2000-10-19 Thread Bruce Momjian
No, not yet. I have a patch against 7.0, but it does not apply. I hope to merge it in before 7.1 beta. > I think this ability has been put in place for 7.1. (Anyone confirm?) > > > -Original Message- > > From: Peter Galbavy [SMTP:[EMAIL PROTECTED]] > > Sent: Thursday, Oc

RE: [ADMIN] binding to a specific IP address

2000-10-19 Thread Matthew
I think this ability has been put in place for 7.1. (Anyone confirm?) > -Original Message- > From: Peter Galbavy [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, October 19, 2000 10:42 AM > To: [EMAIL PROTECTED] > Subject: [ADMIN] binding to a specific IP address > > This may be an FA

RE: [ADMIN] Automation/scheduling of Backup stratetgy

2000-10-19 Thread Matthew H. North
Let me clarify: By 'hot backup' I mean some kind of method we can use to keep a live mirror of a PostgreSQL database as it's being updated. As it is, the pg_dump method has quite a large granularity - we currently have a cron job that runs pg_dumpall once per day, in the early morning. This me

Re: [ADMIN] pg7.0.2 on Sol8

2000-10-19 Thread Peter Eisentraut
Alexander Tait Brotman writes: > I am trying to use Postgres on Solaris8(SPARC). Upon > using make i get an error on $SRC/backend/lib/stringinfo.c on lines > 104,121,124 stemming from va_list,va_start, and va_end that they are all > undeclared. Any thoughts on how I might fix this. If you nee

Re(2): [ADMIN] db server is too slow, real slow

2000-10-19 Thread pgsql-admin
The postgres server was started with the command: /usr/bin/postmaster -i -S -D/var/lib/pgsql Here is just one query executed from Embperl pages with Perl DBI: officedata=> explain SELECT * FROM office, office_application officedata-> WHERE office.code = office_application.office_code officedata->

[ADMIN] MDOPEN

2000-10-19 Thread Rommel B. Abaya
hi, im trying to dump a db via pg_dump but i keep getting an mdopen error, how can i fix this when the dumping doesn't go beyond the affected table. Im getting 19Kb of dumped data whereas im expected around 6Mb of it.

RE: [ADMIN] Automation/scheduling of Backup stratetgy

2000-10-19 Thread Trewern, Ben
Title: RE: [ADMIN] Automation/scheduling of Backup stratetgy It is already built in.  Use pg_dump or pg_dumpall when online. Only problem is OIDs and large objects.  pg_dump -o to keep OIDs not sure about large objects. Hope this is what you mean by live/hot backup. Ben > -Original Me

[ADMIN] pg7.0.2 on Sol8

2000-10-19 Thread Alexander Tait Brotman
I am trying to use Postgres on Solaris8(SPARC). Upon using make i get an error on $SRC/backend/lib/stringinfo.c on lines 104,121,124 stemming from va_list,va_start, and va_end that they are all undeclared. Any thoughts on how I might fix this. If you need any more info please let me know. Th

Re: [ADMIN] db server is too slow, real slow

2000-10-19 Thread Stephan Szabo
We'll probably need some additional information: What settings did you start the server with, what queries are you running that are slow (with schema, index information), what does explain show for the queries? Stephan Szabo [EMAIL PROTECTED] On Thu, 19 Oct 2000, pgsql-admin wrote: > I'm usin

[ADMIN] binding to a specific IP address

2000-10-19 Thread Peter Galbavy
This may be an FAQ but 5 minutes on the docs part of the site didn't enlighten me. Is there any way currently to get the postmaster to only answer requests on a specific IP address. My server has a number of addresses, and I don't really want the overhead of running ipfilter or similar for a serve

[ADMIN] Automation/scheduling of Backup stratetgy

2000-10-19 Thread Matthew H. North
Any word on when (if?) live/hot backup will be available? Matthew H. North Software Engineer CTSnet Internet Services t (858) 637-3600 f (858) 637-3630 mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Michel Decima Sent: Thursday

Re: [ADMIN] help

2000-10-19 Thread nataraj
Hi, I don't know if it's too late to answer this question, but anyway. Please see the attached text file. In step 11 it tells you how to create the symbolic link that starts up postgres database server when the system boots up. Hope it helps. Nataraj Sonika Malhotra wrote: > please help in star

Re: [ADMIN] Automation/scheduling of Backup stratetgy

2000-10-19 Thread Michel Decima
>Is it posible to schedule / automate a backup task and functions to execute >at a pre-defined time at a pre-defined recurrence rate? yes, using the cron daemon and the commands pg_dump or pg_dumpall. The following entry in the postgres user crontab will backup the database every day at 03:01 A

[ADMIN] Automation/scheduling of Backup stratetgy

2000-10-19 Thread Corne Scheepers - MWeb
Is it posible to schedule / automate a backup task and functions to execute at a pre-defined time at a pre-defined recurrence rate? Cornè Scheepers SQL DBA/Developer Mindport BIS 021 9150327

[ADMIN] db server is too slow, real slow

2000-10-19 Thread pgsql-admin
I'm using PostgreSQL 6.5.3 on i686-pc-linux-gnu. I have a backup of our database (sql dump and large object) backup.tar.bz2 with the size of 10121985. We have users accessing our database from http and odbc (ms excel). Can someone pls tell how to solve this problem? Thank you very much. Sherwi