Re: [ADMIN] point in time recovery: status?

2003-10-05 Thread Peter Eisentraut
Mailing List writes: > 7.4 was rumored to include such a feature. Those rumors are false. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] How to create cluster-wide functions

2003-10-06 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > Is it possible to do something like that in postgresql? No. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] Can I configure to authenticate PGSQL 7.3.4 by LDAP

2003-11-02 Thread Peter Eisentraut
Le Ngoc Thach writes: > I'm using Open LDAP in RedHat Linux 9.0. Now, I would like to setup > PGSQL 7.3.4 using authentication by Open LDAP. Can I do that? And how? Use PAM authentication and set up PAM to authenticate through LDAP. -- Peter Eisentraut [EMAI

Re: [ADMIN] Authentication Problems

2003-11-06 Thread Peter Eisentraut
: > psql: FATAL: IDENT authentication failed for user "testing" Are you sure you're connecting to the right server? Did you restart or HUP the server after you have changed the configuration file? -- Peter Eisentraut [EMAIL PROTECTED] ---(end of br

Re: [ADMIN] CREATE DATABASE

2003-11-10 Thread Peter Eisentraut
t language bindings for the same functionality. You could also claim that Unix is not consistent because C programs and shell scripts provide different ways to do the same thing. You would be right, but it's nevertheless quite intended that way. -- Peter Eisentraut [EMAIL PROTECTED] ---

Re: [ADMIN] Upgrading to Solaris 9

2003-11-11 Thread Peter Eisentraut
Danielle Cossette writes: > Could you please let me know if Postgres 7.1.3 will run on Solaris 9. Why don't you try it out? -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our exten

Re: [ADMIN] dropped users appear as numbers in ACL

2003-11-13 Thread Peter Eisentraut
have to perform this same procedure for ACLs? Yes. > Are there any plans to handle these issues transparently when a user is > dropped? "Wishlist" maybe, but no concrete plans. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)---

Re: [ADMIN] Moving Database Directory

2003-11-13 Thread Peter Eisentraut
base already at /data/dbA1. Not possible. Either the whole cluster or nothing. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] pg_restore and FK constraints with large dbs

2003-11-13 Thread Peter Eisentraut
it in the right order. -- Peter Eisentraut [EMAIL PROTECTED] ---(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] pg_restore and FK constraints with large dbs

2003-11-13 Thread Peter Eisentraut
g_dump and dump schema and data together, then there is some magic to temporarily disable foreign key constraints. Try it out. Perhaps you can adopt the statements to your particular restoration method as well, if it turns out necessary. -- Peter Eisentraut [EMAIL PROTECTED]

Re: [ADMIN] dropped users appear as numbers in ACL

2003-11-13 Thread Peter Eisentraut
ch suffer from a similar can't-look-into-other-databases problem. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] Problem with compilation 7.3.4

2003-11-14 Thread Peter Eisentraut
jacek writes: > [EMAIL PROTECTED] postgresql-7.3.4]$ ./configure --infodir=/usr/share/info > configure: error: unrecognized option: --infodir=/usr/share/info > Try `./configure --help' for more information. There is no info documentation, so you don't need this option. -

Re: [ADMIN] Modify a database user

2003-11-14 Thread Peter Eisentraut
Ajay Prabhakar writes: > I want to modify an existing database user. This user doesnot have > postgres super user rights(rights to create another user) and I want > to update its rights without dropping and creating it again. Help me > out. ALTER USER -- Peter Eisentraut [EMA

Re: [ADMIN] pg_restore and FK constraints with large dbs

2003-11-16 Thread Peter Eisentraut
ow writes: > --- Peter Eisentraut <[EMAIL PROTECTED]> wrote: > > If you you pg_dump and dump schema and data together, then there is some > > magic to temporarily disable foreign key constraints. Try it out. > > Dunno. Don't see any magic so far. In fact, pg_res

Re: [ADMIN] Upgrade from 7.2 to 7.4

2003-11-17 Thread Peter Eisentraut
ce would go with it. What is that > thing called? Is it included in the 7.4 tarball? Yes, contrib/adddepend. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if y

Re: [ADMIN] How to interact with the db using java

2003-11-24 Thread Peter Eisentraut
stgresql.org/ -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] Sending a libpq C function variables through function

2003-12-02 Thread Peter Eisentraut
a client; SPI performs database actions from within a server-side function. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourE

Re: [ADMIN] pg_dump and schemas

2003-12-04 Thread Peter Eisentraut
ow writes: > If a *schema* is dumped and then restored on a different server, will it be > necessary to also restore system schemas, e.g. pg_catalog? No. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can g

Re: [ADMIN] Trigger to call an external program

2003-12-05 Thread Peter Eisentraut
On Thursday 04 December 2003 16:36, Stephan Szabo wrote: > > I thought I was onto a winner with pgplsh, but I can't get it to > > compile with 7.3.4, although it compiled beautifully with 7.2.1. > > It takes a little bit of work to get pgplsh to compile for my devel > system (notably that I needed

Re: [ADMIN] lost database

2003-12-09 Thread Peter Eisentraut
Jodi Kanter wrote: > Is there anyway that I can assist him in retreiving his tables from > backup tapes? I am not sure how or where that data is stored. Tell us more about how the backup was made, then we can tell you more about how to restore it. ---(end of broadcast)--

Re: [ADMIN] Postgres grabbing an old shared object

2003-12-09 Thread Peter Eisentraut
Kris Kiger wrote: > Is there a way to force a shared object to reload? I've compiled a > new version of a .so, but postgres seems to be pulling the old > version out of memory. I've tried deleting the .so and recompiling > it, but postgres is insistant, for some reason, of using the old > version

Re: [ADMIN] lost database

2003-12-09 Thread Peter Eisentraut
Jodi Kanter wrote: > I am not sure I understand your question. why does the type of backup > matter? It is a tape backup and it includes the entire /var directory > where the pgsql directory exists. That was the missing piece of information. > I am trying to determine what > particular files need

Re: [ADMIN] 2CPU 4GBRAM

2003-12-09 Thread Peter Eisentraut
Jose Mendoza wrote: > How can be efectivly configured the PostgreSQL to run in a machine > with 2 CPUs Xeon 2.4 GHz and 4GB of RAM? The PostgreSQL work with the > 2 processors? I had run tests and the tiems is always the same that > in a computer with 1 CPU pentium 4 2.4GHz and 2GB RAM. PostgreS

Re: [ADMIN] pg 7.4 on debian

2003-12-09 Thread Peter Eisentraut
Erwin Brandstetter wrote: > people.debian.org has been down since the debian hack. > I am also desperately looking for postgresql 7.4 on debian woody. > Is there a trusted mirror of people.debian.org or any other source to > get these .debs? For the time being, I've copied Oliver Elphick's 7.4/woo

Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4

2003-12-11 Thread Peter Eisentraut
Sai Hertz And Control Systems wrote: > Please vote for this > http://bugs.php.net/26592 Please don't. See my comment. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Moving a database AND changing the superuser

2003-12-16 Thread Peter Eisentraut
Rich Cullingford wrote: > Well, I was gonna use pg_dumpall to avoid the tedium of individual > dumps, but (gotcha!) pg_dumpall doesn't accept > --use-set-session-authorization (tho' it does run pg_dump!). It supplies that option automatically. > If I use > pg_dumpall, will pg_restore (with --use-

Re: [ADMIN] createuser problem in 7.3.4 on Linux

2003-12-17 Thread Peter Eisentraut
Am Mittwoch, 17. Dezember 2003 09:39 schrieb Paul Power: > But if I try DROP USER Administrator  I get > > ERROR: DROP USER: user "administrator" does not exist > > Note the last error has "administrator" rather than "Administrator". You need to double quote the name to preserve case.

Re: [ADMIN] createuser problem in 7.3.4 on Linux

2003-12-17 Thread Peter Eisentraut
Am Mittwoch, 17. Dezember 2003 12:18 schrieb A.Bhuvaneswaran: > > You need to double quote the name to preserve case. > > IMO, in 7.3.4, these two scripts (createuser & dropuser) preserve the > case by default even without double quote. For example, 'createuser > Admin' makes an entry Admin(not adm

Re: [ADMIN] GRANT in pg7.2

2003-12-17 Thread Peter Eisentraut
Anjan Dave wrote: > Is there a way I can assign EXECUTE privilege for a user-defined > function in the GRANT command in 7.2? (7.3 has it) No. > Also, how do I list all the user-defined functions/stored procedures. > Once listed, how to give UPDATE privilege to a user on all of them? Functions do

Re: [ADMIN] Debian Install 7.4

2003-12-18 Thread Peter Eisentraut
Peter Childs wrote: > deb > ftp://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/binary/v7.4/deb >ian woody main > > to my sources.list which failed. I think someone else mentioned that you need to put a slash at the end of the path. ---(end of broadcast)--

Re: [ADMIN] pg_dump problem

2004-01-11 Thread Peter Eisentraut
Likit Younboon wrote: > How to bypass Username and Password for use pg_dump with crontab. Preferrably, set your client authentication (pg_hba.conf) not to require passwords. In newer versions you can also store user passwords in a file ~/.pgpass. ---(end of broadcast)-

Re: [ADMIN] about set autocommit

2004-01-13 Thread Peter Eisentraut
Vasilis Ventirozos wrote: > i sow that in postgres 7.4.x set autocommit to off is not supported > but as i was searching in web i saw : > " If you prefer autocommit-off, you may wish to set it in your > .psqlrc file." > > How can i do that ? man psql ---(end of broa

Re: [ADMIN] psql Automatic login In Bash Script

2004-01-13 Thread Peter Eisentraut
Sai Hertz And Control Systems wrote: > Agreed and now we decided to use it but will ~/.pgpass work for > pg_dump > pg_restore Yes, it works for all libpq programs. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [ADMIN] Missing Schema

2004-01-14 Thread Peter Eisentraut
James Neville wrote: > Does anyone have a clue as to how this may have happened, and an > approach to remedying the problem with a reinstall? Well, perhaps you have simply dropped them? You can just recreate them. ---(end of broadcast)--- TIP 3: i

Re: [ADMIN] Missing Schema

2004-01-14 Thread Peter Eisentraut
James Neville wrote: > Peter Eisentraut wrote: > >Well, perhaps you have simply dropped them? You can just recreate > > them. > > Well, thats a relief, but what tables do I need to recreate, and what > are their schemas? You don't need to create any tables, jus

Re: [ADMIN] psql Automatic login In Bash Script

2004-01-16 Thread Peter Eisentraut
Sai Hertz And Control Systems wrote: > What I need is since password be stored in the bash variable for > once I may pass on the variable with password to > psql > pg_dump > pg_restore > and my database migration would go smothly That would be a security hole because then other users can read the

Re: [ADMIN] error on build from source

2004-01-18 Thread Peter Eisentraut
[EMAIL PROTECTED] wrote: > Internal error: Killed (program cc1) > Please submit a full bug report. > See http://gcc.gnu.org/bugs.html> for instructions. There you go. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [ADMIN] Test Suite

2004-02-02 Thread Peter Eisentraut
rep34 wrote: > I am migrating a database from SQLServer to PostgreSQL and I want to > know if exists some tool to execute tests to see if the functionality > of the triggers and stored procedures still the same? The stored procedure syntax of MS SQL Server and PostgreSQL is not at all the same, s

Re: [ADMIN] Installation procedure

2004-02-05 Thread Peter Eisentraut
Ivan Zenzerović wrote: > I have a problem. After i installed the apache2 web server i wanted > to install pgsql. I run ./configure and after that i tried to run > make but then it outputs an error which said to run configure first. Probably an error happened during the run of configure. If you nee

Re: [ADMIN] Postgresql 7.4.1 and TCP/IP

2004-02-07 Thread Peter Eisentraut
Peter Georgi wrote: > I compiled Postgressql 7.4.1 and installed it. Every thing was fine. > Starting the postmaster I got the message, that the port 5432 was > already in use and no IPV4 connection could be established. Well, the > port is not in use and with an other port number I got the same >

Re: [ADMIN] pgsql initial superuser

2004-02-16 Thread Peter Eisentraut
Pedro Almeida wrote: > So I need someway to add a user so I can add others. There should be a predefined user named "postgres". ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: Solution! (was: Re: [ADMIN] Linux (Debian Woody)...)

2004-02-27 Thread Peter Eisentraut
Phillip R. aka Qbert wrote: > I found out the following: > It's not possible to delete a database when logged on to the database > server via psql. > > Shouldn't this be documented somewhere? It is. Read the "Notes" section on this page: http://www.postgresql.org/docs/7.4/static/sql-dropdatabase

Re: [ADMIN] PostgreSQL and phppgadmin woody backports

2004-03-01 Thread Peter Eisentraut
Am Montag, 1. März 2004 14:49 schrieb Christian Frabel: > I look for theese backports, someone could help? For postgresql, see http://people.debian.org/~elphick/. About phppgadmin, I don't know of one. I happened to look at building one yesterday, but it would seem to entail an update of php4,

Re: [ADMIN] tcp port

2004-03-09 Thread Peter Eisentraut
philippe haas wrote: > port 5432 (postmaster postgres reserved) on my machine(suze 8.2), > with PostgreSQL 7.4.1 ) is unreachable > When i launche postmaster with tcp/op option, i've the message : > LOG: could not bind IPv4 socket: Address already in use. > HINT: Is another postmaster already run

Re: [ADMIN] Explain Analyze help

2004-03-11 Thread Peter Eisentraut
Mark Lubratt wrote: > Obivously, I have a lot of sequential scans going on, at about what > cost does it start to make sense to make an index? Or, should I just > put in a bunch of indexes and let the optimizer decide whether or not > to use them? Read the chapters on Indexes and Performance Tips

Re: [ADMIN] Glibc upgrade for postgres

2004-04-05 Thread Peter Eisentraut
Am Montag, 5. April 2004 07:18 schrieb JM: > Im planning to upgrade glibc because of a reported bug... My database > server was installed via source.. do I have to recompile postgres just > incase I upgrade glibc? are the anything I need to worry about? You should read the documentation acc

Re: [ADMIN] Use 7.4.1's pg_dump in 7.2.4?

2004-04-05 Thread Peter Eisentraut
Anjan Dave wrote: > Purpose is to dump/restore a pretty good-sized db (19GB) on 7.2.4, so > I can upgrade it to 7.4.1. pg_dump should be able to dump databases back to about 7.1, so you should be good to go. As always, if you have problems, we would like to hear about it. By the way, the lates

Re: [ADMIN] installation problem

2004-04-07 Thread Peter Eisentraut
mopeace pliz wrote: > i have a problem adding a user i.e > addusr does not exist in my redhut linux. Try useradd. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes d

Re: [ADMIN] Out of space

2004-04-07 Thread Peter Eisentraut
Tom Bakken wrote: > I've been running a postgres for 2 or 3 years without a problem. > This morning my disk space for the database filled up. I need to > know what transaction/log files I can truncate or delete without > compromising the system. These files are located under > /var/lib/pgsql/dat

Re: [ADMIN] password accessibility

2004-04-12 Thread Peter Eisentraut
Greg Steffensen wrote: > I'd like to construct a view containing the usernames, passwords, etc > in jabber's required format, but system catalog information doesn't > seem to be accessible to views. That is not correct. ---(end of broadcast)--- TIP

Re: [ADMIN] log_min_cost_statement

2004-04-13 Thread Peter Eisentraut
Nichlas Löfdahl wrote: > Would it be possible to have an option "log_min_cost_statement", > similar to "log_min_duration_statement" except that it logs all > statement that has an minimum cost estimated by the planner? I think > it would be easier to find unoptimized queries that way. If you belie

Re: [ADMIN] Real time replication of PG DBs accross two servers - any experiences?

2004-04-13 Thread Peter Eisentraut
Bradley Kieser wrote: > I desperately need to set up a real time replication of several > databases (for failover) between two servers. Last time I looked at > the PG replication it wasn't yet production level. I wonder if anyone > on this list is doing this successfully and if you won't mind shari

Re: [ADMIN] Real time replication of PG DBs accross two servers - any experiences?

2004-04-14 Thread Peter Eisentraut
Christopher Browne wrote: > > To ensure high availability, using DRBD to replicate the storage or > > using a shared storage (e.g., EMC^2) does the job. That saves you > > the trouble of having to set up and manage a database replication > > solution at all. > > Regrettably, "disk replication" sch

Re: [ADMIN] SSL client configuration ...

2004-04-15 Thread Peter Eisentraut
GP wrote: > Then when I tried to connect (via jdbc driver) I get the following > error from the postmaster: > FATAL: no pg_hba.conf entry for host ":::212.205.129.107", user > "dbuser", database "template1", SSL off Make sure you have the latest JDBC driver, the 1.4 JDK, and you use the corr

Re: [ADMIN] Going from a DB using SQL_ASCII to UNICODE

2004-04-21 Thread Peter Eisentraut
Am Dienstag, 20. April 2004 07:05 schrieb Frank Finner: > I answered to a similiar problem on the [GENERAL] list a few days ago. In > short: You can use "recode" in a pipe between dump and restore like > "pg_dump database|recode ascii..utf8|psql newdatabase" to get rid of > unicode problems while t

Re: [ADMIN] Problems with select lower()

2004-04-22 Thread Peter Eisentraut
Am Donnerstag, 22. April 2004 10:55 schrieb Andreas Schmitz: > I have a problem with select lower() using capital letters with diaeresis. > I tried with encoding SQL_ASCII und UNICODE. You need to set your locale to something useful (de_DE), not the encoding. And lower() doesn't work with Unicod

Re: [ADMIN] Creating DB at alternate location

2004-05-03 Thread Peter Eisentraut
Peter Schmid wrote: > Hello all, > > Trying to create a DB at an alternate location fails. I am not > succeding with relativ or absolute path and even not with environment > variables. Also changing from a normal user to root dosn't change > result. What do I wrong. > Can anybody give me a complete

Re: [ADMIN] installation of postgresql-7.2.3-2PGDG

2004-05-03 Thread Peter Eisentraut
kandiah ratnavale wrote: > I downloaded postgresql (client, server and libs) but cannot complete > installation for want of the libraries listed below > > libcrypto.so.2 is needed by postgresql-7.2.3-2PGDG > libssl.so.2 is needed by postgresql-7.2.3-2PGDG > libcrypto.so.2

Re: [ADMIN] windows-1250 encoding

2004-05-03 Thread Peter Eisentraut
Martin Zdila wrote: > How can one set character encoding in the database to windows-1250? Evidently you cannot. > I just need to order selected rows by some column witch windows-1250 > encoded text. If you have windows-1250 data on the client side, then declare your client encoding, create your

Re: [ADMIN] initdb problem (cygwin)

2004-05-16 Thread Peter Eisentraut
Robert wrote: > creating template1 database in /usr/shared/postgresql/data/base/1... > FATAL: invalid value for parameter "lc_messages": "3079" Perhaps you should set your locale environment to something less bizarre. ---(end of broadcast)--- TIP

Re: [ADMIN] Problems installing 7.4.2

2004-05-16 Thread Peter Eisentraut
John D. Tiedeman wrote: > With a dying hard disc, I backed up my db files from 7.4.1 and > installed 7.4.2 on my new disc after installing Fedora Core 1. Two > problems: 1. User postgres seems to have been set up automatically, > and I can't find a password that works. There probably isn't one.

Re: [ADMIN] How to determine if ODBC was compiled in?

2004-05-16 Thread Peter Eisentraut
Jared Evans wrote: > How would I determine if the Debian Postgresql package I installed > was configured with --enable-odbc option? This is fairly uninteresting, since all this switch controls is whether the ODBC driver gets built. Clearly, there is a Debian package for the ODBC driver. -

Re: [ADMIN] Limiting user access to a view only

2004-05-05 Thread Peter Eisentraut
Richard Colman wrote: > How would I set up a new user on PostgreSQL so that the new user is > limited to reading a particular view, and can do nothing else. A new user normally can't do anything. Just grant the privileges on the view to him. You may also want to revoke all permissions on databa

Re: [ADMIN] How do I grant access to entire database at once(schemas,tables,sequences,...)?

2004-05-17 Thread Peter Eisentraut
Ulrich Meis wrote: > 1. Write a script that queries the postgres internal tables for all > tables,schemas,sequences,views,functions,... and then executes grant > statements for each one of them. This would have to repeated each > time a new object is created. Yes, that's the most popular method so

Re: [ADMIN] How to determine if ODBC was compiled in?

2004-05-18 Thread Peter Eisentraut
Jared Evans wrote: > perhaps you misunderstood my question. I downloaded a binary package > off the Debian website. How do I determine what options it was > compiled with? That is my question. Look inside the source package in debian/rules. ---(end of broadcast)---

Re: [ADMIN] Postgresql ssl mode

2004-05-18 Thread Peter Eisentraut
Mario Alberto Soto Cordones wrote: > I have installed a postgresql 7.4.2, and when try to up in ssl mode > this not up. then comment the ssl line in postgresql.conf and this > start correctly. Tell us the error messages, then we can maybe help you. ---(end of broadcast)--

Re: [ADMIN] how do i log events for postgresql 7.0.3

2004-05-28 Thread Peter Eisentraut
Shivaprasad Pavoor wrote: > i have RH7.1 box with postgres 7.0.3. i searched the internet for > above mentioned subject in vain. now i'm totally confused about > postgres.conf (i'm not able to find in my installation) and > pg_options. cud anybody let me know how do i setup logging of > postgres.

Re: [ADMIN] Training

2004-06-09 Thread Peter Eisentraut
Richard Dockery wrote: > I am interested in Postgres training but there doesn't appear to be > much of it out there for resources. Can anyone point me in a good > direction? Googling for postgresql+training should give you enough choices. Alternatively, go to http://techdocs.postgresql.org/com

Re: [ADMIN] which system tables govern access privileges?

2004-06-13 Thread Peter Eisentraut
Harry Stangel wrote: > Which system table(s) govern access privileges, as reported by the > '\dp' command? pg_class ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] initdb problem (Win2K Pro, cygwin)

2004-06-20 Thread Peter Eisentraut
Harry wrote: > creating template1 database in > /usr/local/postgresql7.4.1/data/base/1... DEBUG: > invoking IpcMemoryCreate(size=1081344) > FATAL: could not create shared memory segment: Function not > implemented DETAIL: Failed system call was shmget(key=1, > size=1081344, 03600). DEBUG: proc_

Re: [ADMIN] problem with 7.4.2 for RH-9

2004-06-20 Thread Peter Eisentraut
frank wrote: > Dear Sir: > > After complied my postgresql-7.4.2 with the RH-linux9 operation > system, > > there showed a problem on my configure.log as the file below with > bold type word, . > . > . > configure: failed program was: > #ifndef __cplusplus > choke me > #endif As long as PostgreSQ

Re: [ADMIN] Password with libpq

2004-06-28 Thread Peter Eisentraut
Tony and Bryn Reina wrote: > Thanks Tom. I found the relevant bit of code in the psql files. Looks > like it's just a simple loop that compares the error with the phrase > "fe_sendauth: no password supplied" and then prompts for the password > and tries again. Of course, if someone in the future de

Re: [ADMIN] pg_ctl question

2004-06-28 Thread Peter Eisentraut
Jeff Stout wrote: > I am using the /contrib/start-scripts/linux file to set > up postgres to automatically restart upon reboot. > > I set it up /etc/init.d/postgres which calls pg_ctl > > pg_ctl invokes postmaster > > where do I set the -i option to allow tcp connection? In /usr/local/pgsql/data/p

Re: [ADMIN] PITR Error Message assistance

2004-06-30 Thread Peter Eisentraut
Simon Riggs wrote: > + elog(WARNING, "could not set notify for archiver to read log file > %u, segment %u", Reason? (disk full, network down, leap year?) I think elog() calls don't get translated. You should always use ereport. Tom would know more about the distinction. > + ereport(LOG, > +

Re: [ADMIN] C function from 7.3.2 to 7.4.3

2004-07-01 Thread Peter Eisentraut
Lee Wu wrote: > I have some C functions (was compiled against 7.3.2, I think) Recompile against 7.4.*. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Peter Eisentraut
Christopher Browne wrote: > Jan Wieck puts it fairly nicely: > > "The number of different replication solutions available supports >the theory that ``one size fits all'' is not true when it comes to >database replication." The fact that all but one or two replication solutions out there

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Peter Eisentraut
Marc G. Fournier wrote: > Christopher is correct ... if there was such a thing as an 'end all, > be all' replication solution, there wouldn't be a half a dozen > different ones out there ... Which ones are you thinking of in your count? I don't get anywhere near half a dozen. -

Re: [ADMIN] Turning of case sensitivity for identifiers?

2004-07-14 Thread Peter Eisentraut
t; generates the queries. The table and column names are not actually case sensitive; they are just folded to lower case while you apparently expect upper case. If you write the names the same way in each command, there should not be a problem. What problem are you actually seeing? -- Pete

Re: [ADMIN] adding defaults

2004-07-14 Thread Peter Eisentraut
Jodi Kanter wrote: > Can field specific defaults easily be added to a table that is > already in existence and has data in it? I cannot seem to locate the > correct ALTER command in any of my books. ALTER TABLE a ALTER COLUMN b SET DEFAULT c; -- Peter Eisentraut http://developer.postg

Re: [ADMIN] execute user-defined BKI

2004-07-21 Thread Peter Eisentraut
Howard Bagcat wrote: > How can I execute my BKI script? I suggest that you don't, and you explain us your problem from in more general terms. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5:

Re: [ADMIN] execute user-defined BKI

2004-07-21 Thread Peter Eisentraut
s with the right user IDs. The user IDs are shown in the owner column of the respective system tables (e.g., pg_trigger). -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 3: if posting/reading through Us

Re: [ADMIN] Seq scan with a like operator

2004-07-23 Thread Peter Eisentraut
Am Freitag, 23. Juli 2004 14:50 schrieb Jouneau Luc: > I don't understand why with a like operator, PostgreSQL 7.4.2 does not > behave the same as with an equal operator : LIKE requires a different kind of index. See <http://www.postgresql.org/docs/7.4/static/indexes-opclass.htm

Re: [ADMIN] Seq scan with a like operator

2004-07-23 Thread Peter Eisentraut
lso mean that support both exact generic queries double the > indexing task on update/insert/delete. Well, if you want to optimize lots of different queries, the system needs to provide lots of different support. -- Peter Eisentraut http://developer.postgresql.org/~petere/ -

Re: [ADMIN] Can't increase max connections

2004-07-25 Thread Peter Eisentraut
want relevant help. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] no dup rows

2004-08-02 Thread Peter Eisentraut
ement. Is there a > more appropriate way to accomplish this or am I on the right track?> In "linking tables" you should usually make the entire set of columns the primary key. This would solve your problem. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---

Re: [ADMIN] Adding multiple instances to 7.4

2004-08-11 Thread Peter Eisentraut
hey serve different data) and different ports (so you can address them separately). An alternative might be to run only one instance but put each of your separate databases into its own PostgreSQL database under the same instance. -- Peter Eisentraut http://developer.pos

Re: [ADMIN] PostgreSQL equivalent to MySQL's HEAP tables?

2004-08-15 Thread Peter Eisentraut
Use a ramdisk. PostgreSQL only has one storage engine. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAd

Re: [HACKERS] [ADMIN] SRPM for 8.0.0 beta?

2004-08-18 Thread Peter Eisentraut
init script is a different matter. That in principle could be > taken from the upstream package. I'm not sure if all the Linux > distributions could agree on a single init script, though That can be answered with a plain and simple "no". -- Peter Eisentraut h

Re: [ADMIN] slower every day

2004-09-01 Thread Peter Eisentraut
; asking the table schema, so...why is this so slow?!?!? My last > administrative action into this table was a reindex to all the indexes via > the BKI in standalone mode. I thought I suceed, but this was las saturday. Do you regularly vacuum and analyze the database? -- Pet

Re: [ADMIN] Help understanding locale

2004-09-01 Thread Peter Eisentraut
will be different. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] Help understanding locale

2004-09-02 Thread Peter Eisentraut
ented characters appear at their correct place, whitespace is ignored. The latter in principle applies to all other language-specific locales as well, except that the particular relative order of the letters may be different. -- Peter Eisentraut http://developer.postgr

Re: RES: [ADMIN] Revoke owner's privilege on the table

2004-09-17 Thread Peter Eisentraut
Maximiliano Araujo Pedatella wrote: > Jonh is really a superuser. Then, for this reason, cannot I revoke > your privilege in the referred table? You can revoke all you want, but a superuser ignores all privilege checks. -- Peter Eisentraut http://developer.postgresql.org/~

Re: [ADMIN] Restrictions for system tables

2004-09-18 Thread Peter Eisentraut
[EMAIL PROTECTED] wrote: > Is there any chanse to restrict access to pg_database, which gives in > result of querying pg_database only database which is owned by my > restricted user? No. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of

Re: [ADMIN] allowing users to change the IP-addresses that are allowed to connect to postgresql

2004-09-18 Thread Peter Eisentraut
stig erikson wrote: > is there some way to avoid the pg_hba.conf-file? No. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.

Re: [ADMIN] High Availability for PostgreSQL

2004-10-11 Thread Peter Eisentraut
ow maintenance, and it works. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] How to store jpeg files in Postgres Database

2004-10-15 Thread Peter Eisentraut
Am Freitag, 15. Oktober 2004 08:37 schrieb macdickson: > Can any one tell me how to store jpegh files in Postgres Database Use the data type "bytea". -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)-

Re: [ADMIN] postgresql 8 in jail - LOG: could not create socket for statistics collector: Protocol not supported

2004-10-04 Thread Peter Eisentraut
about whether your system or your jail, respectively, needs that. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail comm

Re: [ADMIN] Failover Solution for Postgres

2004-10-04 Thread Peter Eisentraut
ween the two. (I think the Red Hat cluster mentioned elsewhere amounts to the first variant, more or less.) -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go t

Re: [ADMIN] Installing Postgres - newbie

2004-11-04 Thread Peter Eisentraut
Pallav Kalva wrote: > How do i know which one is for installing the Postgres server and > what are the other packages for ? rpm -qpi packagefile -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP

Re: [ADMIN] evil characters #bfef cause dump failure

2004-11-15 Thread Peter Eisentraut
account has a reasonable locale set (presumably chosen somewhere during the system installation), everything will work out. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: Have you searched our

<    1   2   3   4   5   6   >