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

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 PostgreSQL compiles

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

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] Training

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

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

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] How to determine if ODBC was compiled in?

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

Re: [ADMIN] Postgresql ssl mode

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

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

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] initdb problem (cygwin)

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 4:

Re: [ADMIN] Problems installing 7.4.2

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?

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

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

Re: [ADMIN] Creating DB at alternate location

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] windows-1250 encoding

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] Problems with select lower()

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

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

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

Re: [ADMIN] SSL client configuration ...

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 correct jar.

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

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 schemes aren't

Re: [ADMIN] password accessibility

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

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 believe that

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

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 sharing

Re: [ADMIN] installation problem

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 do

Re: [ADMIN] Out of space

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/data/

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

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 latest

Re: [ADMIN] Explain Analyze help

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 in

Re: [ADMIN] tcp port

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 running

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

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.html

Re: [ADMIN] pgsql initial superuser

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: [ADMIN] Postgresql 7.4.1 and TCP/IP

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] Installation procedure

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 need

Re: [ADMIN] error on build from source

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

Re: [ADMIN] psql Automatic login In Bash Script

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] Missing Schema

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: if

Re: [ADMIN] Missing Schema

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, just schemas. I'm also rather curious

Re: [ADMIN] about set autocommit

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

Re: [ADMIN] psql Automatic login In Bash Script

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] pg_dump problem

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

Re: [ADMIN] Debian Install 7.4

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

Re: [ADMIN] createuser problem in 7.3.4 on Linux

Am Mittwoch, 17. Dezember 2003 09:39 schrieb Paul Power: But if I try DROP USER Administratornbsp;nbsp;I getBR BR ERROR: DROP USER: user administrator does not existBR BR Note the last error has administrator rather than Administrator.BR You need to double quote the name to preserve case.

Re: [ADMIN] createuser problem in 7.3.4 on Linux

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 admin) in

Re: [ADMIN] GRANT in pg7.2

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 don't

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

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

Re: [ADMIN] Trigger to call an external program

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 to

Re: [ADMIN] pg_dump and schemas

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 get off all

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

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 YourEmailAddressHere to [EMAIL

Re: [ADMIN] Upgrade from 7.2 to 7.4

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 your joining column's datatypes do

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

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_restore appears to use internally the same

Re: [ADMIN] Problem with compilation 7.3.4

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. -- Peter Eisentraut

Re: [ADMIN] Modify a database user

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 [EMAIL PROTECTED

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

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)--- TIP 8: explain analyze

Re: [ADMIN] Moving Database Directory

. 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

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

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] ---(end of broadcast

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

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] Upgrading to Solaris 9

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 extensive FAQ

Re: [ADMIN] CREATE DATABASE

. 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] ---(end of broadcast

Re: [ADMIN] Authentication Problems

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 broadcast)--- TIP 4: Don't 'kill

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

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 [EMAIL PROTECTED

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

[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] point in time recovery: status?

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] solaris

can I work around this? I do not have the right to change to default setting in Kernel. How to reduce the requested shared memory? http://www.postgresql.org/docs/7.3/static/kernel-resources.html#SYSVIPC -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: [ADMIN] setting default date format

work, though. -- Peter Eisentraut [EMAIL PROTECTED] ---(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

Re: Fw: [ADMIN] Case Insensitive Test

forces __USE_POSIX). What exact system is this on? I've compiled PG on a number of Linux systems since struct addrinfo started to appear, and I've never had a problem. Neither have others. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: Fw: [ADMIN] Case Insensitive Test

in case someone tries to compile with -ffreestanding. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: Fw: [ADMIN] Case Insensitive Test

Tom Lane writes: Peter Eisentraut [EMAIL PROTECTED] writes: I don't agree with cluttering the compile line with -D_GNU_SOURCE just for the case when someone adds additional unsupported compiler flags. Like --with-perl? The reason that got in there was not to deal with weird compiler

Re: [ADMIN] Actual function name

Gaetano Mendola writes: is there a way to know the name of current function, somethink like $0 for a shell script ? In a C function, you can get the OID of the function from fcinfo-flinfo-fn_oid. From that you can get the name and the argument types. -- Peter Eisentraut [EMAIL PROTECTED

Re: [ADMIN] help needed!!!

packet, so this whole discussion is not the solution to the original question. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [ADMIN] object creation date

Marie G. Tuite writes: How can I identify table creation date as opposed to last modified? Not unless you keep track of it yourself. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [ADMIN] upgrade

, test your applications. -- 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] enabling multibyte ...

of existing databases. It's up to you whether the data stored in them actually matches the encoding. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [ADMIN] pg_recvbuf : unexpected EOF on client

, or the client just died. -- 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] Backup - Restore (pg-dump)

clearer if you showed us the exact sequence of your commands, not dumbed-down versions. For example, in your case the dump files where clearly not named newdatafile. Also, where did you install the new and old versions? Are you sure that running just psql will get you the right version? -- Peter

Re: [ADMIN] SQL slower when running for the second time

faster than the first time. What happens the third time? -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Prompts in psql

Sam Barnett-Cormack writes: I've just looked in the manpage - does anyone know where psql looks for a system-wide psqlrc? Nowhere. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire

Re: [ADMIN] oids

from table1. -- 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] Question

Manuel Haroldo writes: I want to know if there are companies than bring support of PostgreSQL. Searching for PostgreSQL and support on Google will show you hundreds of them. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP

Re: [ADMIN] Version number question

Villalba, Juan Jose - (Col) writes: Hi all. I have just installed PostgreSQL 7.0 Version 7.0 is ancient. The current version is 7.3.4. In fact, that's the version included in the Cygwin distribution itself. Use the online setup tool to install it. -- Peter Eisentraut [EMAIL PROTECTED

Re: [ADMIN] pg_atoi: error in.....: can't parse...

. -- 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] System Tables

Andrzej Schulz writes: Hi, I would Like to get information abort tables existing In PostgreSQL via PHP. I would like to know the names, their description and of course how they are build. http://www.postgresql.org/docs/7.3/static/catalogs.html -- Peter Eisentraut [EMAIL PROTECTED

Re: [ADMIN] pg_ctl won't start postgres, but postmaster will?!

on the console. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] readline-4.2a compile ,installation problem

Archie MacDonald (rsh) writes: I am following the instructions in the techdocs for solaris 8 ( see link below) and I am trying to instal readline 4.2a first. It has not went well so far ...:-( You should probably ask in a forum dedicated to readline, not to PostgreSQL. -- Peter Eisentraut

Re: [ADMIN] locale problems

: Failed to initialize lc_messages to '' FATAL: invalid value for option 'LC_MESSAGES': 'en_US.UTF-8' pg_ctl: cannot start postmaster Examine the log output. Install the en_US.UTF-8 locale on your system. Try dpkg-reconfigure locales. -- Peter Eisentraut [EMAIL PROTECTED

Re: [ADMIN] storage calculations

. There is some information about that in the FAQ, but keep in mind that rows may be compressed or moved to secondary storage automatically. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go

Re: [ADMIN] configure readline error

John McGloughlin writes: config.log (sorry for the BIG file ... wasn't sure if you wanted the whole thing or not Looks like you need to install (or make available) the termcap library. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: [ADMIN] Create Rule/trigger

crank up the log level to log all statements in the server log. -- 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] pg_dump restore problem

. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] [ Possible problem with Postgres ]

5 FindExec: found /iG/dbms/postgres/bin/postgres using argv[0] This is a error ? No, it's just normal output if you have a high debug level. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists

Re: [ADMIN] About sorting rows randomly

Marc Soler writes: It's possible to return rows randomly sorted? select * from table order by random(); -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] UNICODE - SJIS problem

as unicode (UTF-8). Then your attempts to try to display the data as SJIS were unsuccessful, but it's hard to tell why if you don't provide a lot more detail than this. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you

Re: [ADMIN] list schema

Tom Lane writes: I was going to add one for schemas, but \ds and \dS are already taken, and there was no good proposal for what to use instead. Any thoughts? \dschema Pretty soon we'll have too many things for 'c' as well, so maybe we should go with full words. -- Peter Eisentraut [EMAIL

Re: [ADMIN] enable iscii in postgres

it is), the answer is no. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] pg_hba.conf on win32

Guide. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] libreadline.so.3

libreadline.so libreadline.so.4.2 what should I do to make pgsql recognize the library files in my system, while not just the one it expectes? Recompile PostgreSQL (after doing make distclean in your old tree). -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: [ADMIN] server error messages language

. export LC_MESSAGES=C in your server's environment. There's a full description of this in the Administrator's Guide. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

Re: [ADMIN] Error building on SCO

the test program yourself (including all the libraries) and see what it does. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] command line client on windows?

Laurette Cisneros writes: Is there a command line client to run sql against a postgresql server (on a linux box elsewhere) available for windows? psql runs natively on Windows. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast

Re: [ADMIN] Problem compiling PostgreSQL 7.2.1 on RedHat 7.2

ant is going to use. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [ADMIN] postgres 7.2.1 and pam

considered. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] databases and RAID ...

are: 0 Nonredundant 1 Mirrored 2 Memory-style ECC 3 Bit-interleaved parity 4 Block-interleaved parity 5 Block-interleaved distributed parity [Hennessy Patterson] There are also other levels. One poster talked about RAID 10 which appears to be a mirrored RAID 5. -- Peter Eisentraut [EMAIL

Re: [ADMIN] psql command line history not working

such. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] New User - options and other get going questions.

a symlink from the standard location to your desired location. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

<    1   2   3   4   5   >