[ADMIN] What is the default timeout setting for connections to the db?
Is there a default timeout setting for connections to the database? TIA. __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] Auth users and command pg_passwd
You can assign the password as part of createuser, and it is stored encrypted in the database. --- TooManySecrets wrote: [ PGP not available, raw data follows ] > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Thursday 13 February 2003 20:34, Bruce Momjian wrote: > > pg_password is gone. Few were using it, and now we encrypt the > > passwords stored in pg_shadow. Were you sharing your /etc/password file > > with PostgreSQL, or did you have another reason for using pg_password? > > Not. I before was creating a user with the command "createuser", and then, > like as user "postgres", was executing the command " pg_passwd data/passwd ", > where one was guarding the user and his key encripted. Hereby, in the file > "pg_hba.conf", it was had by place (the authentication ) this way: > password/var/lib/data/passwd > > I will study more held up the documentation. > > Thank you very much. > > - -- > Have a nice day ;-) > TooManySecrets > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.2.1 (FreeBSD) > > iD8DBQE+TKLyICNFwaoqbY8RAqcKAJ9ghIexbX9XMryJkUy2MRA/Mr9ngACeLx8V > lNKlsSlaKTPVWj+6gED8Tkk= > =ismN > -END PGP SIGNATURE- > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > [ End of raw data] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] Still a bug in the VACUUM ??? !!!
Andreas Schmitz <[EMAIL PROTECTED]> writes: > I have a problem with the "vacuum full". every time I run the vacuum command I > loose data from the parent tables. maybe also from the subtables (haven't > checked yet). I tried it a few times up to now an I can reproduce the > phenomena. That sounds ugly ... but are you sure you don't have a hardware problem? I don't think anyone's ever reported such behavior before. If it is a Postgres bug, we can't do much to help you without a lot more detail. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] problem with "DROP TABLE" ..
On Sat, 15 Feb 2003 [EMAIL PROTECTED] wrote: > > Hi , > > i get following error when attempting to drop a table. > > tradein_clients=# DROP TABLE branding_master; > ERROR: DropTrigger: relation branding_nob_bak has reltriggers = 0 > tradein_clients=# Did you make any direct changes to the pg_class row or to the pg_triggers rows associated with this table? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] problem with 'DROP TABLE' ..
yep there is a mismatch . shud i delete the entries from pg_trigger to match reltriggers i am sure i dont' need those triggers. regds mallah. tradein_clients=# SELECT relfilenode,relkind,reltriggers from pg_class where relname='branding_master'; relfilenode | relkind | reltriggers -+-+- 46979870 | r | 0 48724633 | v | 0 (2 rows) tradein_clients=# SELECT count(*) from pg_trigger where tgrelid=46979870; count --- 9 (1 row) tradein_clients=# > > On Sat, 15 Feb 2003 [EMAIL PROTECTED] wrote: > >> >> Hi , >> >> i get following error when attempting to drop a table. >> >> tradein_clients=# DROP TABLE branding_master; >> ERROR: DropTrigger: relation branding_nob_bak has reltriggers = 0 tradein_clients=# > > Did you make any direct changes to the pg_class row or to the pg_triggers rows >associated with > this table? - Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[ADMIN] Authentication using NIS password database
Can anybody tell me how to set up pgsql (v7.1) authentication using NIS password database? I set my pg_hba.conf as following: hostall10.0.1.0255.255.255.0identsameuser But I'm still getting "user does not exist" error. Any suggestion will be very much appreciated. Thanks in advance! Yung-Min Chen ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [ADMIN] problem with 'DROP TABLE' ..
On Sat, 15 Feb 2003 [EMAIL PROTECTED] wrote: > yep there is a mismatch . > shud i delete the entries from pg_trigger to match reltriggers > i am sure i dont' need those triggers. Hmm, I was going to just say yes, but then realized that if any of those are foreign key triggers, you'll need to drop both the triggers on this table and the associated triggers on the other table(s). ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] problem with 'DROP TABLE' ..
yes maybe. thanks for the help. regds mallah. > > On Sat, 15 Feb 2003 [EMAIL PROTECTED] wrote: > >> yep there is a mismatch . >> shud i delete the entries from pg_trigger to match reltriggers >> i am sure i dont' need those triggers. > > Hmm, I was going to just say yes, but then realized that if any > of those are foreign key triggers, you'll need to drop both the > triggers on this table and the associated triggers on the other > table(s). - Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[ADMIN] pg_restore fails when restoring a database view
Hi, I have created a database view by : CREATE VIEW V_EDUCATION_LEVEL ( id, description ) AS SELECT 1, 'College or above' UNION ALL SELECT 2, 'Secondary'; Then I pg_dump(ed) the database by specifying a tar format and tried to pg_restore to a destination database. However, I encountered the following error: pg_restore: creating VIEW v_education_level pg_restore: [archiver (db)] could not execute query: ERROR: CREATE TABLE: attribute "?column?" duplicated pg_restore: *** aborted because of error I am running Postgres 7.2.2. Thanks, Pius _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[ADMIN] postgresql 7.3 will not start, no error message given
I tried installing postgre 7.3... Since the Gentoo distro I'm using is largely automated, there are config scripts to take care of copying the files to the right place and so on, the config is all default values. I should also mention it compiles all the software on the spot. So I installed postgre but I can't seem to be able to start the server. Running /etc/init.d/postgresql start shows a fail code but no error message. Also, there are no logs, the path declared in the conf file at /etc/conf.d/postgresql (/var/lib/postgresql/data/postgresql.log) doesn't exist (file isn't there) so I've no idea how to retrieve the error message. /etc/conf.d/postgresql === # PostgreSQL's Database Directory PGDATA=/var/lib/postgresql/data # Logfile path: (NOTE: This must be uid/gid owned by the value of $PGUSER!) PGLOG=/var/lib/postgresql/data/postgresql.log # Run the PostgreSQL user as: PGUSER=postgres # Extra options to run postmaster with. # If you want to enable TCP/IP for PostgreSQL, add -i to the following: PGOPTS="-N 1024 -B 2048" === /etc/init.d/postgresql... === depend() { need net } start() { ebegin "Starting postgres" su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA' -s -l '$PGLOG' -o '$PGOPTS'" eend $? } stop () { ebegin "Stopping postgres" su - $PGUSER -c "/usr/bin/pg_ctl stop -D '$PGDATA' -s -m fast" eend $? } svc_restart () { ebegin "Restarting postgres" su - $PGUSER -c "/usr/bin/pg_ctl restart -D '$PGDATA' -s -m fast -l '$PGLOG' -o '$PGOPTS'" eend $? } === Running the command from the init file above on the command line gives no return value but it still doesn't start the server. I tried running /usr/bin/pg_ctl status -D '/var/lib/postgresql/data' and it tells me the server isn't running but I still don't know why. $PGDATA and its subdir is owned by postgres:postgres. postgres has an entry in /etc/passwd too. *help* Martin Ps. System is a Gentoo1.4, kernel 2.4.19 on a Pentium 166. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] upgrade requires dump/restore?
> Is a dump/restore required from 7.2 to 7.2.3? What if we were to go > from 7.2 to 7.2.4, or even from 7.2 to the latest, 7.3.2? How can we > tell when a dump/restore is required? In answer to my own question, I found that the HISTORY file within the source archive (http://www.ca.postgresql.org/ftpsite/source/v7.3.2/postgresql-7.3.2.tar.gz) contains all of the necessary information about _exactly_ when a dump/restore is required. Here is a summary of what I found going back to PostgreSQL version 7.2: Migration to version 7.3.2 A dump/restore is *not* required for those running 7.3.*. Migration to version 7.3.1 A dump/restore is *not* required for those running 7.3. However, it should be noted that the main PostgreSQL interface library, libpq, has a new major version number for this release, which will require that client code using libpq be relinked. Migration to version 7.3A dump/restore using pg_dump is required for those wishing to migrate data from any previous release. If your application examines the system catalogs, additional changes will be required due to the introduction of schemas in 7.3; for more information, see: http://www.ca.postgresql.org/docs/momjian/upgrade_tips_7.3. Migration to version 7.2.4 A dump/restore is *not* required for those running 7.2.X. Migration to version 7.2.3 A dump/restore is *not* required for those running 7.2.X. Migration to version 7.2.2 A dump/restore is *not* required for those running 7.2.X. Migration to version 7.2.1 A dump/restore is *not* required for those running 7.2. Migration to version 7.2A dump/restore using "pg_dump" is required for those wishing to migrate data from any previous release. Best regards, Stephane Charette stephanecharette at telus dot net ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] How to restore from pg_dumpall output
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes: Tom> Laura Conrad <[EMAIL PROTECTED]> writes: >> pg_dumpall -p 8050 >/tmp/db.sql >> I then tried to restore (again as the postgres user), as documented in >> the pg_dumpall man page: >> psql -f /tmp/db.sql template1 >> It does a few things, and then says: >> psql:/tmp/db.sql:16: \connect: FATAL 1: IDENT authentication >> failed for user "bostonre" Tom> I believe this will work better if you use "-X Tom> use-set-session-authorization" to pg_dump (which should be Tom> the default, but isn't yet). I tried that, but I still get the same error out of psql, although the pg_dumpall output now says: SET SESSION AUTHORIZATION bostonre; instead of: \connect - bostonre Tom> Without that, you need an authorization configuration that Tom> will let you connect as someone else --- which IDENT won't, Tom> superuser or no. (You could set up an ident map to let that Tom> happen, but it'd be tedious if you have lots of users to keep Tom> track of.) There are only 2. So I tried doing that, but my first guess on how didn't work. But to make that guess, I had to look at pg_hba.conf and it had lots of useful stuff in it. I decided it wasn't going to kill me to just trust everyone on my local machine for 5 minutes, so I did that. Not the kosher thing for a real database administrator to do, but this is my home machine, and the dog doesn't know how to log on. So I have my database back -- thanks for the help. -- Laura (mailto:[EMAIL PROTECTED] , http://www.laymusic.org/ ) (617) 661-8097 fax: (801) 365-6574 233 Broadway, Cambridge, MA 02139 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[ADMIN] Can I make Postgresql to bind to 127.0.0.1:5432, instead of all the available interfaces
Hi guys, I am trying to figure out if I can get Postgres to bind to only the loop-back interface (127.0.0.1) as apposed to binding to all the available interfaces (0.0.0.0) available on the system. 1. The first question is whether this is feasible at all? 2. If yes, what is the configuration (and where) to enable it. Thanks a lot in advance. - Uday
Re: [ADMIN] Users and groups
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes: Tom> Raj Mathur <[EMAIL PROTECTED]> writes: >> ... However, the complementary process, determining all the >> users in group administrators, isn't so clean. Tom> Doesn't select grolist from pg_group where groname = Tom> 'administrators' do it for you? I suppose you might want the Tom> thing to map sysids back to usernames ... Ah, maybe I should have been more explicit: need a list of usename's of users who are admins. Any simple command (set) to do that? Regards, -- Raju -- Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/ It is the mind that moves ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] Auth users and command pg_passwd
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 13 February 2003 20:34, Bruce Momjian wrote: > pg_password is gone. Few were using it, and now we encrypt the > passwords stored in pg_shadow. Were you sharing your /etc/password file > with PostgreSQL, or did you have another reason for using pg_password? Not. I before was creating a user with the command "createuser", and then, like as user "postgres", was executing the command " pg_passwd data/passwd ", where one was guarding the user and his key encripted. Hereby, in the file "pg_hba.conf", it was had by place (the authentication ) this way: password/var/lib/data/passwd I will study more held up the documentation. Thank you very much. - -- Have a nice day ;-) TooManySecrets -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (FreeBSD) iD8DBQE+TKLyICNFwaoqbY8RAqcKAJ9ghIexbX9XMryJkUy2MRA/Mr9ngACeLx8V lNKlsSlaKTPVWj+6gED8Tkk= =ismN -END PGP SIGNATURE- ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] No pg_hba.conf entry
find your postgresql.conf file, look in there to make sure tcpip_socket= true.the directory that file is in should be the same as the $PGDATA thatyour getting asked for, so you'll be able to do pg_ctl -D /path/to/database statusRobert Treat Hello All, Thanks to Robert. I have set the above things but SQL-ledger is giving different error this time like : FATAL 1: No pg_hba.conf entry for host 192.168.168.56, user sql-ledger, database template1 I am using the preinstalled Postgres DB that came along with the default RH Linux Installation. I did not install externally.( so the path will be /usr/bin./usr/lib) I have set the variables as suggested in the postgressql.conf file. But i am now getting this error. $ pg_ctl -D /usr/lib/pgsql startpostmaster successfully startedbash-2.05a$ FATAL 1: data directory /usr/lib/pgsql has group or world access; permissions should be u=rwx (0700) and also bash-2.05a$ initdbThe files belonging to this database system will be owned by user "postgres".This user must also own the server process. initdb: The directory /usr/lib/pgsql exists but is not empty.If you want to create a new database system, either remove or emptythe directory /usr/lib/pgsql or run initdb withan argument other than /usr/lib/pgsql. I have set PGDATA =/usr/lib/pgsql and there is no directory by name data. Should i create a new Directory by name data and initialise this. Please advice. Thank and regards, Vivek Help STOP SPAM with the new MSN 8 and get 2 months FREE*
[ADMIN] Session ID
Dear Milist, 1. I Used 2b using "alter system kill session 'n1,n2'"; on oracle, to kill specified session. Than how do i done this on postgres or there's another solution. And How do i know the user is connected. 2. Sometimes the process is feel so slowly without knowing what's exactly process is working or which tables is busy. Any Idea about this...?? Thank's so Much and GOD Bless You All. Yudha Setiawan.VoIP No. : 628899911223344
[ADMIN] postgresql 7.3 will not start, no error message given
> I tried installing postgre 7.3... Since the Gentoo distro I'm using is > largely automated, there are config scripts to take care of copying the > files to the right place and so on, the config is all default values. I > should also mention it compiles all the software on the spot. So I installed > postgre but I can't seem to be able to start the server. Running > /etc/init.d/postgresql start shows a fail code but no error message. Also, > there are no logs, the path declared in the conf file at > /etc/conf.d/postgresql (/var/lib/postgresql/data/postgresql.log) doesn't > exist (file isn't there) so I've no idea how to retrieve the error message. > > > /etc/conf.d/postgresql > > === > > # PostgreSQL's Database Directory > PGDATA=/var/lib/postgresql/data > > # Logfile path: (NOTE: This must be uid/gid owned by the value of $PGUSER!) > PGLOG=/var/lib/postgresql/data/postgresql.log > > # Run the PostgreSQL user as: > PGUSER=postgres > > # Extra options to run postmaster with. > # If you want to enable TCP/IP for PostgreSQL, add -i to the following: > PGOPTS="-N 1024 -B 2048" > > === > > > /etc/init.d/postgresql... > > === > > depend() { > need net > } > > start() { > ebegin "Starting postgres" > su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA' -s -l > '$PGLOG' -o '$PGOPTS'" > eend $? > } > > stop () { > ebegin "Stopping postgres" > su - $PGUSER -c "/usr/bin/pg_ctl stop -D '$PGDATA' -s -m fast" > eend $? > } > > svc_restart () { > ebegin "Restarting postgres" > su - $PGUSER -c "/usr/bin/pg_ctl restart -D '$PGDATA' -s -m fast -l > '$PGLOG' -o '$PGOPTS'" > eend $? > } > > === > > Running the command from the init file above on the command line gives no > return value but it still doesn't start the server. > > I tried running /usr/bin/pg_ctl status -D '/var/lib/postgresql/data' and it > tells me the server isn't running but I still don't know why. > > $PGDATA and its subdir is owned by postgres:postgres. postgres has an entry > in /etc/passwd too. > > *help* > > > Martin > > Ps. System is a Gentoo1.4, kernel 2.4.19 on a Pentium 166. > > > ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] uppercase = lowercase
Hi!! How can I make selects not sensitive uppercase and lowercase characters? This is possible modifying something of psql configuration? Thanks ___ Lista de correo de la traducción de PostgreSQL [EMAIL PROTECTED] https://listas.hispalinux.es/mailman/listinfo/doc-postgresql-es ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] uppercase = lowercase
On Fri, 2003-02-14 at 08:51, jose antonio leo wrote: > How can I make selects not sensitive uppercase and lowercase characters? > This is possible modifying something of psql configuration? I take it you mean that SELECT x FROM t WHERE x = 'abc'; should also return rows where x = 'ABC' and x = 'Abc' and so on. The answer is to make your condition say what it means: SELECT x FROM t WHERE lower(x) = 'abc'. If you do this a lot, you may well want to create an index on lower(x). -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "God be merciful unto us, and bless us; and cause his face to shine upon us." Psalms 67:1 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] Still a bug in the VACUUM ??? !!!
Hello *, I have a problem with the "vacuum full". every time I run the vacuum command I loose data from the parent tables. maybe also from the subtables (haven't checked yet). I tried it a few times up to now an I can reproduce the phenomena. I am running postgresql 7.3.2 on solaris 8 (E450 4x 400 sun4u 1.5 GB) regards -Andreas -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[ADMIN] problem with "DROP TABLE" ..
Hi , i get following error when attempting to drop a table. tradein_clients=# DROP TABLE branding_master; ERROR: DropTrigger: relation branding_nob_bak has reltriggers = 0 tradein_clients=# can anyone suggest what might be the problem? regds mallah. - Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [ADMIN] No pg_hba.conf entry
On Fri, 2003-02-14 at 03:08, vivek K. wrote: Hello All, Thanks to Robert. I have set the above things but SQL-ledger is giving different error this time like : FATAL 1: No pg_hba.conf entry for host 192.168.168.56, user sql-ledger, database template1 If your using the standard Red Hat rpm, I believe your data file will be in /var/lib/pgsql/data, which should also be you $PGDATA variable. The error above indicates that the user sql-ledger doesn't have authorization. You'll need to look in your pg_hba.conf file and add I line like: host all 192.168.168.56 255.255.255.255 trust (Note, this isn't the tightest configuration; check the docs to see for ways to adjust this once your up and running and ready for production) I am using the preinstalled Postgres DB that came along with the default RH Linux Installation. I did not install externally.( so the path will be /usr/bin./usr/lib) I have set the variables as suggested in the postgressql.conf file. But i am now getting this error. $ pg_ctl -D /usr/lib/pgsql start postmaster successfully started bash-2.05a$ FATAL 1: data directory /usr/lib/pgsql has group or world access; p ermissions should be u=rwx (0700) ISTM you should be doing pg_ctl -D /var/lib/pgsql/data start. BTW, check your ps output. You normally wont receive the error message at the beginning of this email unless the server is already running. and also bash-2.05a$ initdb The files belonging to this database system will be owned by user "postgres". This user must also own the server process. initdb: The directory /usr/lib/pgsql exists but is not empty. If you want to create a new database system, either remove or empty the directory /usr/lib/pgsql or run initdb with an argument other than /usr/lib/pgsql. I have set PGDATA =/usr/lib/pgsql and there is no directory by name data. Should i create a new Directory by name data and initialise this. Please advice. Again, I think you need to set $PGDATA to /var/lib/pgsql/data It wouldn't hurt to do an ls -al in that directory and see what you have, I'm guessing you'll find all of the other components of your server. And again, the first error message indicates that your server is already up and running, so really you probably don't need to run an initdb. Robert Treat Help STOP SPAM with the new MSN 8 and get 2 months FREE* ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [ADMIN] date of creation or last modification
On Thu, 2003-02-13 at 14:48, Hal Lynch wrote: > How do I find the date when a table was created or last modified? > AFAIK there is no way to do this. Most folks that need an audit trail tend to role their own using triggers. Robert Treat ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] postgresql 7.3 will not start, no error message given
what does the output of /usr/bin/postmaster tell you? Robert Treat On Fri, 2003-02-14 at 03:25, Martin Matusiak wrote: > > I tried installing postgre 7.3... Since the Gentoo distro I'm using is > > largely automated, there are config scripts to take care of copying the > > files to the right place and so on, the config is all default values. I > > should also mention it compiles all the software on the spot. So I > installed > > postgre but I can't seem to be able to start the server. Running > > /etc/init.d/postgresql start shows a fail code but no error message. Also, > > there are no logs, the path declared in the conf file at > > /etc/conf.d/postgresql (/var/lib/postgresql/data/postgresql.log) doesn't > > exist (file isn't there) so I've no idea how to retrieve the error > message. > > > > > > /etc/conf.d/postgresql > > > > === > > > > # PostgreSQL's Database Directory > > PGDATA=/var/lib/postgresql/data > > > > # Logfile path: (NOTE: This must be uid/gid owned by the value of > $PGUSER!) > > PGLOG=/var/lib/postgresql/data/postgresql.log > > > > # Run the PostgreSQL user as: > > PGUSER=postgres > > > > # Extra options to run postmaster with. > > # If you want to enable TCP/IP for PostgreSQL, add -i to the following: > > PGOPTS="-N 1024 -B 2048" > > > > === > > > > > > /etc/init.d/postgresql... > > > > === > > > > depend() { > > need net > > } > > > > start() { > > ebegin "Starting postgres" > > su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA' -s -l > > '$PGLOG' -o '$PGOPTS'" > > eend $? > > } > > > > stop () { > > ebegin "Stopping postgres" > > su - $PGUSER -c "/usr/bin/pg_ctl stop -D '$PGDATA' -s -m fast" > > eend $? > > } > > > > svc_restart () { > > ebegin "Restarting postgres" > > su - $PGUSER -c "/usr/bin/pg_ctl restart -D '$PGDATA' -s -m > fast -l > > '$PGLOG' -o '$PGOPTS'" > > eend $? > > } > > > > === > > > > Running the command from the init file above on the command line gives no > > return value but it still doesn't start the server. > > > > I tried running /usr/bin/pg_ctl status -D '/var/lib/postgresql/data' and > it > > tells me the server isn't running but I still don't know why. > > > > $PGDATA and its subdir is owned by postgres:postgres. postgres has an > entry > > in /etc/passwd too. > > > > *help* > > > > > > Martin > > > > Ps. System is a Gentoo1.4, kernel 2.4.19 on a Pentium 166. > > > > > > > > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] autocommit
On Thu, 2003-02-13 at 18:48, Laurette Cisneros wrote: > > Using 7.3.2 now. > > I noticed a slew of messages in my pgsql log like this: > WARNING: COMMIT: no transaction in progress > > I'm wodering if this is related to the fact that there is now an option in > the postgresql.conf file: > autocommit=true > > Did 7.3.2 change the default behavior of the pgsql server in regards to > soloton transactions? > > Pre 7.3.* version issued "NOTICE: COMMIT: no transaction in progress" instead of "WARNING". The different log level is probably why you didn't see it before. Robert Treat ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] How can i port data from SQL-Server 2000 to Postgre.
How can i port data from SQL-Server 2000 to Postgre. If I use SQL-Server DTS, I got ODBC call failure error. Which version of ODBC is appropriate for this. Regards, Sreedhar "Faith, faith, faith in ourselves, faith, faith in God, this is the secret of greatness. If you have faith in all the three hundred and thirty millions of your mythological gods, and in all the gods which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. " (III. 190) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[ADMIN] Is there any UNIT TESTING tool for postgre
Hi All, Is there any UNIT TESTING tool for postgre like PLSQLUNIT for ORACLE Regards Sreedhar "Faith, faith, faith in ourselves, faith, faith in God, this is the secret of greatness. If you have faith in all the three hundred and thirty millions of your mythological gods, and in all the gods which foreigners have now and again introduced into your midst, and still have no faith in yourselves, there is no salvation for you. " (III. 190) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster