[ADMIN] help with recovery of deleted table
Hello,everyone. sorry to ask again. I deleted one of my table using delete * from mytable, anyway to recover it, I searched the mail list archive last week, there's someone ask this queston before,and someone reply with a python code to recover it,but I can't search the archive (the search result doesn't come out£©¡£ Can someone help me? thanks! solar2000 2002/01/09 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] Is this list working?
On 10 Jan 2002 17:37:25 -0800, Tony Reina [EMAIL PROTECTED] wrote: I'm reading the list through Google groups, but I haven't seen much activity on admin, hackers, sql, etc. over the last few weeks. Are there just not any posts or is something screwy with Google groups newsserver? I was hoping to see the status of 7.2. -Tony [EMAIL PROTECTED] if this posting arrives you may safely conclude that the list is working :) i [complete newbie] agree that there isn't much activity. there is a lot more on the postgresql mailing lists, you may want to try them. subscribe at postgresql.org. HTH, HAND -- Jules Alberts ---(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
[ADMIN] REQUEST: database security issues in PHP manual
Hello, I' m currently working with the PHPDOC team on maintaining and keeping up-to-date the PHP manual. I proposed in the PHPDOC list to include some information about database security issues. It aims to be an introduction into the very basics of how to access and manipulate databases within PHP scripts. (the SQL injection was that started up this idea.) If you have any spare time to write a short paragraph or expose a commonly used bad practise which can be hascked easily or knowing a site or page that's worth reading it, please let me know! I hope you may share your valuable knowledge about this topic, because I'm not a security professional who has been around a very lot (but not a newbie). I' m about to gather as much information as possible to formulate the startings. As an ex member of this mailing list I expect your proposals, but please note that the primary goal of this article will be an overview about how to use _any database_ in a _web based_ application what to allow and what to resist, not specifically PostgreSQL. However I'm happy to receive such information, too. (I've personally never used anything else but postgres :)) If a reasonable amount of tips and hints were received related to postgres, then a database specific section would be opened in the PHP manual, too. Best regards, -- Gyozo Papp - [EMAIL PROTECTED] PS please CC me your replies! ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[ADMIN] template database
Does anyone know how I can delete a second template database without blowing all the databses away? What happened was I was running initdb and the user postgres didn't hvae rights to the db directory or something and so I had to run it again, and there ended up being two template databases, template0 and template1. Not that it's a big deal but I can't drop the first one cause it says it isn't there but it still lists it. thanks Tyson Oswald ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [ADMIN] Is this list working?
Try pointing your news reader at news.postgresql.org itself ... we just fixed a permissions problem wiht the posts goign to the lists, so Google and all them might get a better flow now too ... On 11 Jan 2002, Jules Alberts wrote: On 10 Jan 2002 17:37:25 -0800, Tony Reina [EMAIL PROTECTED] wrote: I'm reading the list through Google groups, but I haven't seen much activity on admin, hackers, sql, etc. over the last few weeks. Are there just not any posts or is something screwy with Google groups newsserver? I was hoping to see the status of 7.2. -Tony [EMAIL PROTECTED] if this posting arrives you may safely conclude that the list is working :) i [complete newbie] agree that there isn't much activity. there is a lot more on the postgresql mailing lists, you may want to try them. subscribe at postgresql.org. HTH, HAND -- Jules Alberts ---(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 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] [GENERAL] Need help
On 01/08/2002 09:17:03 PM Jason Earl wrote: Why do you want a database where two tables have the same name? When you do a SELECT * from Table1 what table do you expect PostgreSQL to use? I suspect Shamik is trying to do something like having a separate 'schema' (Oracle) for every user, and in Oracle it is possible to create tables with the same name but in different schemas. Maarten Maarten Boekhold, [EMAIL PROTECTED] Reuters Consulting / TIBCO Finance Technology Inc. Dubai Media City Building 1, 5th Floor PO Box 1426 Dubai, United Arab Emirates tel:+971(0)4 3918300 ext 249 fax:+971(0)4 3918333 mob:+971(0)505526539 -- -- Visit our Internet site at http://www.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
Re: [ADMIN] [GENERAL] Need help
Why do you want a database where two tables have the same name? When you do a SELECT * from Table1 what table do you expect PostgreSQL to use? Now, that being said, it's possible to create temporary tables in different connections with the same name. These tables will dissapear when the connection is terminated, however. For example you could have something like this: conn1: CREATE TEMP TABLE foo (bar text); conn2: CREATE TEMP TABLE foo (bar text); conn1: INSERT INTO foo (bar) VALUES ('baz'); conn2: SELECT * from foo; [returns zero rows] conn1: SELECT * from foo; [returns 'baz'] If you actually want two permanent tables with the same name, you are going to have to put them in separate databases. Otherwise use temporary tables. Jason Shamik Majumder [EMAIL PROTECTED] writes: Hi , We are facing some problems with the creation of tables of same name but owned by different user . We followed the following steps . Lets say, we have a database DBTest and this database was created by the user postgres. We created tables - Table1, Table2 and Table3 in it. Now, by using the createuser command - one more database user is created, say dbuser1. Now, when I login as dbuser1 on the DBTest database, I can see all the tables Table1, Table2 and Table3 by /dt command. Even, I am able to create new tables ( i.e table with new names ) in the same database DBTest but with the owner dbuser1. Now, when I try to create the same table like Table1 ( which has been created by the postgress user previously ) as dbuser1 user - the create table command fails with the following o/p : ERROR: Relation 'Table1' already exists My question - is it possible in Postgres, to create the tables with same name but with different users ? i.e we create Table1 table both as postgres as well as dbuser1 . Is it possible kindly let me know . Thanks and Regards, Shamik ---(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] Primary Key Problems
Tony / Phil, my 2c on the Primary Key definition / usage. If you have any SQL / DDL code that disagrees with the definitions below could you please repost them. Tony Reina [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... [EMAIL PROTECTED] (Phill Kenoyer) wrote in message news:[EMAIL PROTECTED]... Here is a good one. I have three fields set for my primary key. Now I thought that a primary key was unique, and dups can not be inserted. I don't think primary keys per se are unique, but rather can be made unique by specifying that option. IIRC primary keys just allow you to index searches within the database. So to make a unique primary key from your db schema: The definition of a primary key was that it WAS a unique identifier for the table Definition: The primary key of a relational table uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique (such as Social Security Number in a table with no more than one record per person) or it can be generated by the DBMS (such as a globally unique identifier, or GUID, in Microsoft SQL Server). Ref: http://databases.about.com/library/glossary/bldef-primarykey.htm Also PRIMARY KEY This column is a primary key, which implies that uniqueness is enforced by the system and that other tables may rely on this column as a unique identifier for rows. See PRIMARY KEY for more information. AND The PRIMARY KEY column constraint specifies that a column of a table may contain only unique (non-duplicate), non-NULL values. The definition of the specified column does not have to include an explicit NOT NULL constraint to be included in a PRIMARY KEY constraint. Ref: http://www.ninthwonder.com/info/postgres/user/sql-createtable.htm Regards sb CREATE TABLE inventory ( stock character varying(50) NOT NULL, inventory_type character varying(20) DEFAULT 'unknown' NOT NULL, client_id integer NOT NULL, [...] UNIQUE (stock, inventory_type, client_id) Constraint inventory_pkey Primary Key (stock, inventory_type, client_id) ); HTH, -Tony BTW, I'm using Google newsgroups to view the Postgres messages, but haven't seen posted messages in several days on the Hackers list. Does anyone know if this is a Google glitch or is the hackers list just not very active during the holiday? ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[ADMIN] Vaccum and 24/7/365 database
Hi all, we use postgresql 7.2 for a data logging/supervisor application running 24 hours a day, 7 days a week and 365 (and 6 hours) a year. Data are inserted/deleted/updated each 1,5 minutes and for performance reason we have to vacuum each day some tables. The problem is that vacuum stops inserts, updates and deletes for the table it performs (well in fact, I understood this). This way of working for the database does not fit our needs of 24/7/365 availability. So my question is : is there a way to get all the things work together (good performances availability)? Thanks a lot. -- Jean-Christophe ARNU s/w developer Paratronic France ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[ADMIN] sorting of chinese data
Dear Alls I cannot get reasonable result for sorting on field with chinese data Setting as follows : linux locale : zh_TW.Big5 postgresql client and server : EUC_TW please advise what's wrong with my setting and what should I do in order to overcome this sorting problem. Thanks a lot in advance. ---(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] Is this list working?
On Fri, 11 Jan 2002 17:39:06 +0900, Yasuo Ohgaki [EMAIL PROTECTED] wrote: Jules Alberts wrote: On 10 Jan 2002 17:37:25 -0800, Tony Reina [EMAIL PROTECTED] wrote: I'm reading the list through Google groups, but I haven't seen much activity on admin, hackers, sql, etc. over the last few weeks. Are there just not any posts or is something screwy with Google groups newsserver? I was hoping to see the status of 7.2. -Tony [EMAIL PROTECTED] if this posting arrives you may safely conclude that the list is working :) i [complete newbie] agree that there isn't much activity. there is a lot more on the postgresql mailing lists, you may want to try them. subscribe at postgresql.org. True, but I don't see Tom's posts even in hackers list. I'm accessing via. news server. Should I subscribe actual e-mail list to read them? you could try that. i subscribed to the mailing lists, and there is a lot more feed there. i subscribed to everything but ODBC, and from the last weekend there were about a 100 postings. -- Jules Alberts ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[ADMIN] Using Database, 2 or more filesystem
Hi all My problem is, my filesystem is full and I can't extend it, so can i use a secondary filesystem ? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[ADMIN] I have a Question
help me please, I am using Postgresql, I want to know if exists a limit in the number of rows to create a function. I created a function using pgaccess, but when I try to see it using PgAdmin, I can not see all the lines I wrote. Thank you for your answers. I am writting from Colombia (I am still learning english) __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[ADMIN] Installing Postgres with support for Greek Characters
Greetings, Is there support for Greek characters using ISO-8859-7 in the latest production version of Postgres, v7.1.3? I can see that it is possible to use ./configure --enable-multibyte[=encoding_system] --enable-locale but the list of available encodings does not seem to include ISO-8859-7? I see that in version 7.2, ISO-8859-7 is listed as being available, but v7.2 is not currently a production version. Is there some way that support for Greek characters can be installed in v7.1.3?, or do I just need to set the locale to be el_GR? Regards Peter Wood ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[ADMIN] HELP: language option software package not installed
Hello Everyone, It has been sometime since I have installed PostgreSQL. It has been running great with no crashes for like a year! But alas, my faithful Sparc 20 turned belly-up. It is sad to loose an old friend @* | *@ I now have a Ultra10 :o) I've loaded Solaris 8 with the companion disk that loaded Perl5. Everything appears to be loaded into /usr/Perl5/5.00503. It looks OK to me but this happens: ./configure --with-perl --enable-odbc --enable-syslog --enable-cassert Then during the gmake: cp Pg.pm blib/lib/Pg.pm AutoSplitting blib/lib.Pg.pm (blib/lib/auto/Pg) /usr/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503 /usr/perl5/5.00503/ExtUtils/xsubpp -typemap /usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs xstmp.c mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -x03 -xdepend -DVERSION=\1.8.0\ -DXS_VERSION=\1.8.0\ -KPIC -I/usr/perl5/5.00503/sun4-solaris/CORE Pg.c /usr/ucb/cc: language optional software package not installed gmake[4]: *** [Pg.o] Error 1 gmake[4]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5' gmake[3]: *** [Install] Error 2 gmake[3]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5' gmake[2]: *** [Install] Error 2 gmake[2]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces' gmake[1]: *** [Install] Error 2 gmake[1]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src' gmake: *** [Install] Error 2 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[ADMIN] Monitoring database
Hello everybody. Is there any way to check database status, or who is currently connected to it. I tried to drop database and got an error saying that other users using this database. So Iwanted to see who is connected right now to the database. One more question is how can I see all tables in the template1 ? Thanks allot. -- - Roman Gavrilov Aduva Inc., Web Development Services. work +972-3-7534324 mobile +972-54-834668 [EMAIL PROTECTED], [EMAIL PROTECTED]
[ADMIN] Insert Performance with WAL and Fsync
Hi All, Our application needs to do a moderate level of inserts into the database as it runs. We can hit 100-200 inserts a second under certain conditions - and it is not something we can batch up for later processing. While testing out postgres I noticed some trobling performance data under this sort of workload. I've got a run of pgbench which exhibits the behavior. This variant of pgbench is a good approximation of our application and the results mirror those of tests I did with our app - so changing the scaling, client factors, etc of pgbench is not relevant. I tried changing most other parameters of postmaster.conf (log files, buffers, etc) and none have such dramatic effects as illustrated below. It appears the CPU utilization on both machines is very low (15%)- so I'm guessing it is mostly I/O overhead. At the bottom of the message is the detailed result of pg_bench -t 500 under the following conditions: wal_sync_method = open_sync wal_sync_method = fsync OS FSYNC OFF FSYNC ONFSYNC ON Solaris 74/75 22/22 30/30 Win2k 112/113 124/127 21/21 so the following questions arise: 1) How can I improve the Solaris performance without disabling fsync? 2) What are others getting for TPS on Solaris machines with fysnc on? Are my numbers low/high/right in the ballpark? 3) Why does the Solaris performance with fysnc on/off differ by a factor of 3.4x while the windows fsync on/off differs by only 1.1x? I thought WAL was supposed to dramatically reduce the cost of fsyncs? 4) Why does the Win2k behavior with fsync and open_sync differ so greatly? Is fysnc on cygwin slow or does OPEN_SYNC not work properly (i.e. is not really syncing) 5) Assuming the Win2k open_sync implementation is working why is my Win2k laptop with a much slower harddrive with fsync on 5.6x faster than the solaris box. 6) Is there anything I could have done in the building of postgres from source to cause problems on Solaris? Any help or insight would be greatly appreciated. Mike Here's the specs: Win2k Sp2 PIII 1.2G/512 mb Cache 512mb Ram 1 4400RPM IDE disk (its a laptop) Postgres 7.1.3 on cygwin postmaster.conf default execpt where noted below Solaris 8 01/01 with relatively recent patch sets E220R 2x450Mhz USII 2GB Ram 1 36Gig 1RPM SCSI Disk Postgres 7.1.2 compiled using gcc postmaster.conf default execpt where noted below Here are the results of pg_bench: Solaris: wal_sync_method = open_sync fsync = false starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 1 number of transactions per client: 500 number of transactions actually processed: 500/500 tps = 74.825791(including connections establishing) tps = 75.418729(excluding connections establishing) Solaris: wal_sync_method = open_sync fsync = true transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 1 number of transactions per client: 500 number of transactions actually processed: 500/500 tps = 22.691402(including connections establishing) tps = 22.745163(excluding connections establishing) Solaris: wal_sync_method = fsync fsync = true transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 1 number of transactions per client: 500 number of transactions actually processed: 500/500 tps = 30.489359(including connections establishing) tps = 30.591695(excluding connections establishing) Windows: wal_sync_method = open_sync fsync = true starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 1 number of transactions per client: 500 number of transactions actually processed: 500/500 tps = 124.409521(including connections establishing) tps = 127.591055(excluding connections establishing) Windows: wal_sync_method = open_sync fsync = false transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 1 number of transactions per client: 500 number of transactions actually processed: 500/500 tps = 112.103652(including connections establishing) tps = 113.250950(excluding connections establishing) wal_sync_method = fsync fsync = true scaling factor: 1 number of clients: 1 number of transactions per client: 500 number of transactions actually processed: 500/500 tps = 21.191655(including connections establishing) tps = 21.232517(excluding connections establishing) ---(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] [SQL] replication
I want to add replication capabilities to my postgresql installation. Can anyone recommend a good way (open source or otherwise) to do so? Basically, I have a web tracking application that must quickly and reliably store massive amounts of tracking data. Later, I run complex queries to analyze this tracking data. These complex queries tend to be very resource intensive, so I'd like to have them run on a separate machine altogether. I need a simple and reliable method to 'copy' any data added to the tracking database to the analysis database. Preferably, I'd be able to configure this copy process to defer to high priority queries or to be considerate of the time of day. How closely does the replicated data have to track your live data. I my installation I have an cron job that runs at 2:30am daily. It backs up the database (using pg_dump) and loads it on another machine. I can then run queries the next day on the backup machine without hurting performance on the primary. It also has the side effect of producing the backup file for saving to tape or whatever. It also veryfies daily that the backup file is not corrupt because the load would fail on the secondary machine. This is not true replication but it might serve your needs. I looked at the replication solutions for PostgreSQL a while ago and got the impression they were not ready for primetime. In may have changed since then. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] Primary Key Problems
I did have this problem in the past. I have a table with three fields set for the primary key. Somehow I would get dups in that table. I'm not sure how as I am too busy to test it. I changed my insert queries to check for existing data before the insert so I could get back to work. Someone did reply that it was from a bug in vacuum. I run vacuum each night on my database. I'm running: PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.95.4 from Debian packages On: Linux 2.4.17 #1 SMP Sat Dec 22 09:18:33 PST 2001 i686 unknown Debian Sid (unstable) and Woody (testing). Hope this helps. |On 020114 13:01 |steve boyle ([EMAIL PROTECTED]) wrote the following... | |Tony / Phil, | |my 2c on the Primary Key definition / usage. If you have any SQL / DDL code |that disagrees with the definitions below could you please repost them. | |Tony Reina [EMAIL PROTECTED] wrote in message |[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | [EMAIL PROTECTED] (Phill Kenoyer) wrote in message |news:[EMAIL PROTECTED]... | Here is a good one. I have three fields set for my primary key. Now I | thought that a primary key was unique, and dups can not be inserted. | | | I don't think primary keys per se are unique, but rather can be made | unique by specifying that option. IIRC primary keys just allow you to | index searches within the database. So to make a unique primary key | from your db schema: | | |The definition of a primary key was that it WAS a unique identifier for the |table | |Definition: The primary key of a relational table uniquely identifies each |record in the table. It can either be a normal attribute that is guaranteed |to be unique (such as Social Security Number in a table with no more than |one record per person) or it can be generated by the DBMS (such as a |globally unique identifier, or GUID, in Microsoft SQL Server). | |Ref: http://databases.about.com/library/glossary/bldef-primarykey.htm | |Also | |PRIMARY KEY | |This column is a primary key, which implies that uniqueness is enforced by |the system and that other tables may rely on this column as a unique |identifier for rows. See PRIMARY KEY for more information. | |AND | |The PRIMARY KEY column constraint specifies that a column of a table may |contain only unique (non-duplicate), non-NULL values. The definition of the |specified column does not have to include an explicit NOT NULL constraint to |be included in a PRIMARY KEY constraint. | |Ref: | |http://www.ninthwonder.com/info/postgres/user/sql-createtable.htm | |Regards | |sb | | | CREATE TABLE inventory ( | stock character varying(50) NOT NULL, | inventory_type character varying(20) DEFAULT 'unknown' NOT | NULL, | client_id integer NOT NULL, | [...] | UNIQUE (stock, inventory_type, client_id) | Constraint inventory_pkey | Primary Key (stock, inventory_type, client_id) | ); | | HTH, | -Tony | | | BTW, I'm using Google newsgroups to view the Postgres messages, but | haven't seen posted messages in several days on the Hackers list. Does | anyone know if this is a Google glitch or is the hackers list just not | very active during the holiday? -- BOFH Reason of the day: Maintence window broken _ | _ (_()(|('.|)('||.|()|`|( ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] HELP: language option software package not installed
On Mon, 14 Jan 2002 18:11:59 +0100 Allan C. Huffman [EMAIL PROTECTED] wrote: Hello Everyone, It has been sometime since I have installed PostgreSQL. It has been running great with no crashes for like a year! But alas, my faithful Sparc 20 turned belly-up. It is sad to loose an old friend @* | *@ I now have a Ultra10 :o) I've loaded Solaris 8 with the companion disk that loaded Perl5. Everything appears to be loaded into /usr/Perl5/5.00503. It looks OK to me but this happens: ./configure --with-perl --enable-odbc --enable-syslog --enable-cassert Then during the gmake: cp Pg.pm blib/lib/Pg.pm AutoSplitting blib/lib.Pg.pm (blib/lib/auto/Pg) /usr/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503 /usr/perl5/5.00503/ExtUtils/xsubpp -typemap /usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs xstmp.c mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -x03 -xdepend -DVERSION=\1.8.0\ -DXS_VERSION=\1.8.0\ -KPIC -I/usr/perl5/5.00503/sun4-solaris/CORE Pg.c /usr/ucb/cc: language optional software package not installed gmake[4]: *** [Pg.o] Error 1 gmake[4]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5' gmake[3]: *** [Install] Error 2 gmake[3]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5' gmake[2]: *** [Install] Error 2 gmake[2]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces' gmake[1]: *** [Install] Error 2 gmake[1]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src' gmake: *** [Install] Error 2 Hi, You don't have a C compiler installed. Or if you do, it is not picking it up. This is a OS problem. It looks like it has not changed since the SunOS 5.X days...:( GB -- GB Clark II | Roaming FreeBSD Admin [EMAIL PROTECTED] | General Geek CTHULU for President - Why choose the lesser of two evils? ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [ADMIN] HELP: language option software package not installed
It looks like the user you are when you install postgres does not know the path to your compiler. Try installing gcc and use it instead of cc to compile postgres. Make sure your user's .profile has the path to gcc before installing. Heather - Original Message - From: Allan C. Huffman [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 14, 2002 12:11 PM Subject: [ADMIN] HELP: language option software package not installed Hello Everyone, It has been sometime since I have installed PostgreSQL. It has been running great with no crashes for like a year! But alas, my faithful Sparc 20 turned belly-up. It is sad to loose an old friend @* | *@ I now have a Ultra10 :o) I've loaded Solaris 8 with the companion disk that loaded Perl5. Everything appears to be loaded into /usr/Perl5/5.00503. It looks OK to me but this happens: ./configure --with-perl --enable-odbc --enable-syslog --enable-cassert Then during the gmake: cp Pg.pm blib/lib/Pg.pm AutoSplitting blib/lib.Pg.pm (blib/lib/auto/Pg) /usr/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503 /usr/perl5/5.00503/ExtUtils/xsubpp -typemap /usr/perl5/5.00503/ExtUtils/typemap -typemap typemap Pg.xs xstmp.c mv xstmp.c Pg.c cc -c -I/usr/local/pgsql/include -x03 -xdepend -DVERSION=\1.8.0\ -DXS_VERSION=\1.8.0\ -KPIC -I/usr/perl5/5.00503/sun4-solaris/CORE Pg.c /usr/ucb/cc: language optional software package not installed gmake[4]: *** [Pg.o] Error 1 gmake[4]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5' gmake[3]: *** [Install] Error 2 gmake[3]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces/perl5' gmake[2]: *** [Install] Error 2 gmake[2]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src/interfaces' gmake[1]: *** [Install] Error 2 gmake[1]: Leaving directory '/opt/pgsql/postgresql-7.1.3/src' gmake: *** [Install] Error 2 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(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] Monitoring database
On Wednesday, January 9, 2002, at 10:31 PM, Roman Gavrilov wrote: Hello everybody. Is there any way to check database status, or who is currently connected to it. I tried to drop database and got an error saying that other users using this database. So I wanted to see who is connected right now to the database. Take a look here maybe: http://gborg.postgresql.org/project/pgmonitor/projdisplay.php One more question is how can I see all tables in the template1 ? Thanks allot. in the psql client: psql template1 \dt \h is definately worth reading too. == David Stanaway Personal: [EMAIL PROTECTED] Work: [EMAIL PROTECTED]
[ADMIN] How do I get off this mailing list
How do I get off this mailing list? -- Andy Gussie Network Administrator eFruit International, Inc. http://www.efruitinternational.com President VI Massive, Inc. http://www.vimassive.net
Re: [ADMIN] How do I get off this mailing list
On Tuesday, January 15, 2002, at 03:24 PM, Andy Gussie wrote: How do I get off this mailing list? You should have received an email like this when you subscribed: From: [EMAIL PROTECTED] Date: Tue Jul 03, 2001 10:31:54 AM Australia/Sydney To: [EMAIL PROTECTED] Subject: Welcome to the pgsql-admin mailing list! Reply-To: [EMAIL PROTECTED] X-Mailer: MIME-tools 5.409 (Entity 5.404) Welcome to the pgsql-admin mailing list! Your password at postgresql.org is XYZpassword Please save this message for future reference. Thank you. If you ever want to remove yourself from this mailing list, send the following command in email to [EMAIL PROTECTED]: approve XYZpassword unsubscribe pgsql-admin [EMAIL PROTECTED] Note that this works even if your address changes; for that reason (among others) it is important that you have this message handy when it comes time for you to leave the the list. If you ever need to get in contact with the owner of the list, (if you have trouble unsubscribing or have questions about the list itself) send email to [EMAIL PROTECTED] This is the general rule for most mailing lists when you need to contact a human. Put the text of the welcome message here. -- Best Regards David Stanaway Technology Manager Australia's Premier Internet Broadcasters Phone: +612 9357 1699 Fax: +612 9357 1169 Web: http://www.netventures.com.au Support: [EMAIL PROTECTED] The Inspire Foundation is proudly supported by Net Ventures through the provision of streaming solutions for it's national centres. The Inspire Foundation is an Internet-based foundation that inspires young people to help themselves, get involved and get online. Please visit Inspire at http://www.inspire.org.au
[ADMIN] Problem with create postgres user.
Hi to All, Can anyone tell me how to create useable postgres user ID? Problem I create the postgres user ID through postgres's CREATEUSER command. After the creation, I try to usepsql -U userIDto login this user ID to postgresql database server. But the server refuse the ID with some kind of this message 'The user ID is not in the system id context'. Thank you in advance Lim