[ADMIN] Database diagram
I have a postgres database with many tables. How do I create database diagram? Are there any free tools available to create database diagram from pgsql database? Regards, Ganesan ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[ADMIN] Shutdown pg db
How to properly shutdown pg db server? Is the below command safe to shutdown the pg db server? #killall -9 postmaster pg_ctl does not seems work on server? Regards, Ganesan
[ADMIN] Field Size
Can anyone tell me, what harm would setting a field size to 1000 characters do to the size? By increasing the size, will the database require more space? Or does it only consume space if there is data in the field only? Regards, Ganesan
Re: [ADMIN] Field Size
Can anyone tell me, what harm would setting a field size to 1000 characters do to the size? By increasing the size, will the database require more space? Or does it only consume space if there is data in the field only? Regards, Ganesan
[ADMIN] pg_dump still requires password
I want to do auto backup for pg with cronjob. The problem is it equesting for password. I have tried with pgpass but still it does not work. I created the pgpass as per below: echo your_host:5432:your_user:your_db:your_pass > ~/.pgpass bash$ chmod 600 ~/.pgpass My cronjob entry is as below: /usr/local/pgsql/bin/pg_dump --no-owner -d helpdesk -U ganesh > /www/htdocs/sg/backup/helpdesk.dump When I issue the command it is asking for passwd which I cannot used for cronjob to run at midnight. Please help. How I do solve this problem. I have posted this earlier the suggestion was to use pgpass but that does not help. What other way can I achive this. Regards, Ganesan
Re: [ADMIN] pgAdmin
pgAdmin is installed on linux redhat 8. Regards, Ganesan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ganesan Kanavathy Sent: Sunday, November 02, 2003 17:03 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [ADMIN] pgAdmin How do I uninstall pgAdmin III? Please help Regards, Ganesan
[ADMIN] pgAdmin
How do I uninstall pgAdmin III? Please help Regards, Ganesan
Re: [ADMIN] File system level backup
Please help me with question. So far no replies. Regards, ganesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ganesan Kanavathy Sent: Friday, October 17, 2003 5:14 PM To: [EMAIL PROTECTED] Subject: [ADMIN] File system level backup Dear all, All the while I was doing pg_dump as backup method for my pgsql db. Today I came across File system level backup on Postgresql Documentation. After reading it, I am quite unsure whether File system level backup is better than pg_dump. Furthermore, do we really need to do File system level backup or pg_dump is good enough? Any suggestion is much appreciated. Regards, ganesh
Re: [ADMIN] File system level backup
Please help me with question. So far no replies. Regards, ganesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ganesan Kanavathy Sent: Friday, October 17, 2003 5:14 PM To: [EMAIL PROTECTED] Subject: [ADMIN] File system level backup Dear all, All the while I was doing pg_dump as backup method for my pgsql db. Today I came across File system level backup on Postgresql Documentation. After reading it, I am quite unsure whether File system level backup is better than pg_dump. Furthermore, do we really need to do File system level backup or pg_dump is good enough? Any suggestion is much appreciated. Regards, ganesh
[ADMIN] File system level backup
Dear all, All the while I was doing pg_dump as backup method for my pgsql db. Today I came across File system level backup on Postgresql Documentation. After reading it, I am quite unsure whether File system level backup is better than pg_dump. Furthermore, do we really need to do File system level backup or pg_dump is good enough? Any suggestion is much appreciated. Regards, ganesh
[ADMIN] pg_dump.. auto backup
I am doing a cronjob to dump pg database everyday. Below is my script for cronjob. #!/bin/sh /usr/local/pgsql/bin/pg_dump -U ganesh --no-owner -d mq > /backupdb/mq.dump cd / cd /backupdb/ tar -czf /backupdb/mq-`date '+%d-%m-%Y'`.tar.gz -R * This cronjob is schedule to run everyday at 3.30am. The problem I am facing is the when running the cronjob it is asking for password. If I remove –U ganesh, it is still prompting for password but this time root password. How do I solve this, when running the pg_dump I don’t want it to prompt for password. Regards, ganesh
Re: [ADMIN] Pgsql crashes frequently
Title: Message When I check the logfile it is stated there:"pcMemoryCreate: shmget(key=5432001, size=1466368, 03600) failed: Invalid argumentThis error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. You can either reduce the request size or reconfigure the kernel with larger SHMMAX.To reduce the request size (currently 1466368 bytes), reduce PostgreSQL's shared_buffers parameter (currently 64) and/or its max_connections parameter (currently 32).If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising the request size or reconfiguring SHMMIN is called for.The PostgreSQL Administrator's Guide contains more information about shared memory configuration."I really got no idea what this means. How do I solve this?What SHMMAX and SHMMIN and how I calculate this value? I have a 1GB of memory.Regards,ganesh-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of scott.marloweSent: Tuesday, October 07, 2003 10:36 PMTo: Ganesan KanavathyCc: [EMAIL PROTECTED]Subject: Re: [ADMIN] Pgsql crashes frequentlyOn Tue, 7 Oct 2003, Ganesan Kanavathy wrote:> We are running Postgresql db and it crashes almost every hour Unable> to load up pgsql after a crash.> > We need to restart the server to start back pg.> > What would be the cause of this problem. Please help.Bad hardware. Check for bad memory, CPU, or hard drive.Or, your machine is running low on memory and the kernel is killingprocesses randomly to free up memory. That's not as likely, but it doeshappen in some setups.www.memtest86.com for a decent free memory tester for X86 architecture.---(end of broadcast)---TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[ADMIN] Pgsql crashes frequently
Title: Message We are running Postgresql db and it crashes almost every hour Unable to load up pgsql after a crash. We need to restart the server to start back pg. What would be the cause of this problem. Please help. Regards, ganesh
[ADMIN] Checking Postgres Database
Title: Message Dear all, How to check database size for Posgresql db. I need give hardisk utilization of the database on daily basis. Regards, ganesh