[ADMIN] [pgsql-ayuda] Copiar tablas (fwd)

1999-02-08 Thread Peter
Hi, I have a table with 100 registers in Postgres with Linux RH5.1 and I want to copy it to other Linux machine with Postgres, my question is may be a little dummy: is there a command in Postgres that allows this copy or I have to re-do the tables and write again the registers that I have in the o

[ADMIN] how to do???

2001-07-20 Thread peter
Hi administrtors I get a porblem for PostgresSQL. I don't know how the data (table, users...) of oracle tranfer to PostgresSQL.I don't know Perl program. Are there any way (e.g SQL)to solve this problem? If anyone know, please tell me thank u for help P ---(end of

Re: [ADMIN] ODBC Call fail? (fwd)

1998-06-01 Thread Peter Mount
-- Forwarded message -- Date: Sun, 31 May 1998 18:52:53 +0530 From: Venugopal <[EMAIL PROTECTED]> To: Peter Mount <[EMAIL PROTECTED]> Subject: Re: [ADMIN] ODBC Call fail? Newsgroups: comp.databases.postgresql.admin Peter Mount wrote: > On Sat, 30 May 1998, Thom

Re: [ADMIN] PostgreSQL questions

1998-05-17 Thread Peter Mount
e -i flag, which enables TCP/IP networking. > 3. The \copy command. What do I use for the delimeter of each field? >I can't seem to find that in the documentation. It defaults to tab, but you can define your own. Try: \h copy -- Peter T Mount [EMAIL PROTECTED] or [EM

[ADMIN] Re: your mail

1998-05-17 Thread Peter Mount
t; > Are there any mistake? or something else? If you already have the postmaster running with -i then you don't have to kill it for the changes to pg_hba.conf to take affect. Also, I'd advise you tighten it up a little bit - giving everyone trust permissions means they can log i

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread Peter Mount
able to do the complete > install... I've installed it both ways: * As root, when installing under /usr/local * As postgres, when installing under /home/postgres The only thing I have yet to find how to setup without root, is starting the postmaster when the system boots. -- Peter

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread Peter Mount
On Sun, 17 May 1998, Brett W. McCoy wrote: > On Sun, 17 May 1998, Peter Mount wrote: > > > I've installed it both ways: > > > > * As root, when installing under /usr/local > > * As postgres, when installing under /home/postgres > > > > The onl

Re: [ADMIN] pg_ident.conf file?

1998-05-23 Thread Peter Mount
of your database, ie $(PGDATA) -- Peter T Mount [EMAIL PROTECTED] or [EMAIL PROTECTED] Main Homepage: http://www.retep.org.uk Someday I may rebuild this signature completely ;-) Work Homepage: http://www.maidstone.gov.uk Work EMail: [EMAIL PROTECTED]

Re: [ADMIN] "pg_guest" is not in "pg_shadow" error.

1998-05-27 Thread Peter Mount
ot in "pg_shadow" error? Did you create the user using createuser? (other than creating the entry in your passwd file) -- Peter T Mount [EMAIL PROTECTED] or [EMAIL PROTECTED] Main Homepage: http://www.retep.org.uk Someday I may rebuild this signature completely ;-) Work Homepage: http://www.maidstone.gov.uk Work EMail: [EMAIL PROTECTED]

Re: [ADMIN] "pg_guest" is not in "pg_shadow" error.

1998-05-30 Thread Peter Mount
158.152.22.37 255.255.255.255 crypt Here, I use crypt for any connection going over a cable, password when it says internal to the machine. > -Original Message- > From: Peter Mount <[EMAIL PROTECTED]> > To: Sejin Oh <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED

Re: [ADMIN] ODBC Call fail?

1998-05-30 Thread Peter Mount
an entry. Are you running the postmaster with the -i argument which enables TCP/IP communication? -- Peter T Mount [EMAIL PROTECTED] or [EMAIL PROTECTED] Main Homepage: http://www.retep.org.uk Someday I may rebuild this signature completely ;-) Work Homepage: http://www.ma

[ADMIN] Log, via triggers.

1999-01-02 Thread Vazsonyi Peter
Hello I tried create a small logging utility for postgresql (6.4, i use it on redhat-linux-5.2) I meand with triggers 'n SPI all database change can be hooked. But this have small problem: in an aborted transaction the triggers run on changes, but NOT run with the undos. 4xmpl.: -- my=> Begin;

Re: [ADMIN] int8 regression fails on Irix 6.4

1999-02-04 Thread Vazsonyi Peter
On Tue, 12 Jan 1999, Bruce Momjian wrote: > > postgres=> create table a (b int8); > > CREATE > > postgres=> create index c on a(b); > > ERROR: Can't find a default operator class for type 20. > > > > Any ideas on this problem? Many thanx in advance. > > We don't have indexes fo

Re: [ADMIN] How to replicate databases?

1999-06-10 Thread Peter Galbavy
e past but I can't find a clear answer. > > > > Thanks in advance. > > > > Simon. > > -- > ====== > "There are no kernel hackers in Ireland. They spend all their time in the pub" > Alan Cox > == > > > > -- Peter Galbavy Knowledge Matters Ltd http://www.knowledge.com/

[ADMIN] Blew away postgres user -- now can't connect

1999-07-06 Thread Peter Eisentraut
y the database and ran initdb again. It says 'postgres' not in pg_shadow. My pg_hba.conf has local all trust. Any clues out there? -- Peter Eisentraut PathWay Computing, Inc.

Re: [ADMIN] Blew away postgres user -- now can't connect

1999-07-07 Thread Peter Eisentraut
est' it was that came out of nowhere. I am not too sure about how I fixed it, but I am pretty sure it was the user IDs. -- Peter Eisentraut PathWay Computing, Inc.

[ADMIN] Authentication via PAM or NIS

1999-07-07 Thread Peter Eisentraut
sword "file"?) -- Peter Eisentraut PathWay Computing, Inc.

[ADMIN] Access problems on temp tables

1999-07-28 Thread Peter Eisentraut
have all access to it anyway. PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3 -- Peter Eisentraut PathWay Computing, Inc.

[ADMIN] Upgrading from 6.5.0 to 6.5.1

1999-07-30 Thread Peter Eisentraut
I just want to verify this: when I update between the said versions, can I just keep the data directory around (no need to dump/restore)? Would that eliminate the need to run initdb? It seems like this could be made slightly clearer in the documentation. -- Peter Eisentraut PathWay Computing

Re: [ADMIN] Password protected databases and automated backups

1999-08-02 Thread Peter Eisentraut
the $PGDATA/base directory using regular file backup methods. That wouldn't be a dump, so it depends on your particular needs. -- Peter Eisentraut PathWay Computing, Inc.

Re: [ADMIN] Password protected databases and automated backups

1999-08-02 Thread Peter Eisentraut
On Tue, 3 Aug 1999, Dmitry Morozovsky wrote: > On Mon, 2 Aug 1999, Peter Eisentraut wrote: > > PE> > How can I organize automated database dumping for passord protected > PE> > database? > PE> If you're implying something like "How do I get around en

Re: [ADMIN] psql -u

1999-10-17 Thread Peter Eisentraut
g_hba.conf(5)), otherwise the system will let you with any password. In that regard the -u switch is kind of flawed, because prompting for username and password are really two different things. But that will be fixed in the next version. -Peter -- Peter Eisentraut Sernanders

Re: [ADMIN] Rules and clustering

1999-10-25 Thread Peter Eisentraut
along the way with this as well (when the original table is dropped). There is no real work around other than recreating the rules. -Peter On Mon, 25 Oct 1999, Jacques B. Dimanche wrote: > Hello There, > > I noticed that if I have rules set on a table and if I do a clust

Re: [ADMIN] HSA (Highly Scalable Architecture) Distribution and replication

1999-10-28 Thread Peter Galbavy
a transaction log from a *single* central update server (writer) to update multiple readers, running in '-F' mode. Not yet tried it. Regards, -- Peter Galbavy Knowledge Matters Ltd http://www.knowledge.com/

Re: [ADMIN] To many clients

1999-10-28 Thread Peter Eisentraut
> > Best regards > > > > > -- Peter Eisentraut Sernanders vaeg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Database/table limits ??????

1999-11-23 Thread Peter Eisentraut
tem should take care of; PostgreSQL won't. Incidentally, I believe that most file systems won't do this, but something like XFS (SGI) will. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] When postgres will be faster?

1999-11-29 Thread Peter Eisentraut
od database, but its too slow... There is no such thing as a free lunch ... -- Peter Eisentraut Sernanders vaeg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Permissions on Database and some other questions!

1999-11-29 Thread Peter Eisentraut
and is it posible at all?! There's no really good way without making your users superusers. That is admittedly a deficiency. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] pgdump and large objects

1999-12-04 Thread Peter Eisentraut
ions can only read or write a file on the file sytem anyway, there is no COPY equivalent. pg_dump would need to export the objects to files that would need to be kept with the actual dump. That's actually feasible, I believe. As for an immediate solution, chances are you'd need to write

Re: [ADMIN] Database chages log to outside

1999-12-10 Thread Peter Eisentraut
On 1999-12-11, [EMAIL PROTECTED] mentioned: > I need a logging utility for postgresql server. This will (probably) be addressed in WAL (write-ahead logging(?)), due to appear eventually but, as we found out the other day, not so soon :( . -- Peter Eisentraut Sernanders väg

Re: [ADMIN] Number of connections

1999-12-10 Thread Peter Eisentraut
On 1999-12-11, lec mentioned: > How can I find out how many users/who are currently connected to a > database? The ps output on the server machine will help. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/p

Re: [ADMIN] Alternate database location

1999-12-11 Thread Peter Eisentraut
which you can't), you'll never be able to drop it cleanly either. I'll submitt a corrected version of this for the next release. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Vacuum script

1999-12-16 Thread Peter Eisentraut
's not in the RPMs though. (boo) -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Vacuum script

1999-12-17 Thread Peter Eisentraut
On 1999-12-16, [EMAIL PROTECTED] mentioned: > On Thu, 16 Dec 1999, Peter Eisentraut wrote: > > Actually such a script, called vacuumdb, with exactly those options is > > included in the distribution and should be installed in your bin dir right > > next to psql. > >

Re: [ADMIN] bugs?

2000-01-11 Thread Peter Eisentraut
o urla di sudore... che schifo... > -- > Michel Morelli [EMAIL PROTECTED] > http://www.ziobudda.net > Italian Linux FAQ http://faq.ziobudda.net/ > Italian Linux Press http://www.ziobudda.net/ILP/ > &g

Re: [ADMIN] Vacuum process.

2000-01-11 Thread Peter Eisentraut
rincipia PHONE: (314)-434-2100 > 13201 Clayton RoadFAX: (314)-275-3538 > St. Louis, MO 63131 INTERNET: [EMAIL PROTECTED] > > > > -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] postgresql configuration nits

2000-01-11 Thread Peter Eisentraut
7;-L$(exec_prefix)' to the link > line. I don't know the syntax for that, but you get the idea. In my view that's not reasonable, but anyway. I guess you'd have to do --with-tcl=/where/it/is -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Setting Transaction level doesn't work

2000-01-11 Thread Peter Eisentraut
"show > transaction isolation level" tells me that it is still "read commited". > Any Hints ? > > Is there a possibility to have transaction level setted to serializable > as default level? > > Many thanks in advance > > Norbert > > > &g

Re: [ADMIN] security

2000-01-16 Thread Peter Eisentraut
u are using ident "authentication" then you can do that by setting up a different mapping file for each database. See pg_hba.conf for details. If you're using password authentication you have to set up a different password file for each database. See again pg_hba.conf. -- Peter Eisent

[ADMIN] Attribute 'aggtransfn1' is repeated

2000-01-28 Thread Peter Vazsonyi
I installed postgresql-v6.5.3 on my sparc64-linux from source. When that was done, i tried to run initdb, and: [postgres@sun2 pgsql]$ PATH=$PATH:/usr/local/pgsql/bin [postgres@sun2 pgsql]$ initdb -r $PWD -l /usr/local/pgsql/lib/ We are initializing the database system with username postgres (uid=

Re: [ADMIN] changing privleges in pg_user/shadow

2000-02-10 Thread Peter Eisentraut
ome documention on this is greatly appreciated. > > thanks > -mike > > mike focosi > senior applications programmer > golden dome media > http://www.gdp.net > http://www.surfmichiana.com > http://www.wndu.com > > > > > --

Re: [ADMIN] Why idex scan not used?

2000-02-29 Thread Peter Eisentraut
On Tue, 29 Feb 2000, Andrei N.Sobchuck wrote: > Is it possible to make postgresql to use index scan when it calculate > MIN(id). Not currently, but it's on the todo list. -- Peter Eisentraut Sernanders vaeg 10:115 [EMAIL PROTECTED] 75262 U

Re: [ADMIN] Backup of db with large objects.

2000-02-19 Thread Peter Eisentraut
lo_import and lo_export functions. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] the beginners

2000-02-20 Thread Peter Vazsonyi
On Sat, 19 Feb 2000, Alberto Mainoni wrote: > I'd like know the difference between the Server Programming Interface > and libpq? When I will have to use libpq or SPI? In applications U can use libpq, in server side functions (4xmpl:triggers) SPI. > Can I have any linux C examples that list the ta

Re: [ADMIN] Can NOT dump db with 6.4.2's pg_dumpall

2000-02-20 Thread Peter Eisentraut
N command failed. Explanation from backend: 'ERROR: > parser: parse error at or near "transaction" > '. > pg_dump failed on cqn, exiting > ==== -- Peter Eisentraut Sernanders väg 10:

[ADMIN] more performance on some aggregates

2000-02-23 Thread Peter Vazsonyi
I've created a table, and index. Table= test +++---+ | Field| Type | Length| +++---+ | a | int4

Re: [ADMIN] migrating administrative pieces to new install

2000-01-29 Thread Peter Eisentraut
transferring them by hand rather than bothering too much with getting pg_dump[all] to work. Of course, temporarily disabling the password authentication would work as well. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Attribute 'aggtransfn1' is repeated

2000-01-31 Thread Peter Vazsonyi
Opps... that was simple bug. I don't understand why works on x86, why not on sparc (gcc?), but this small patch should correct the error. On Fri, 28 Jan 2000, Peter Vazsonyi wrote: > [postgres@sun2 pgsql]$ initdb -r $PWD -l /usr/local/pgsql/lib/ > > We are initializing the databa

Re: [ADMIN] Triggers on postgres

2000-01-31 Thread Peter Vazsonyi
On Sun, 30 Jan 2000, Mario Simeone wrote: > I'm using PostgreSQL 6.4.2 on SuSE. I' m trying to create a trigger... but there are available 6.5.2 rpm version, and 6.5.3 in source. > postgres says me : Triggers are non implemented yet. These word are also on > page 114 of Users guide. > Postgres d

Re: [ADMIN] Authentification problems with local connections

2000-03-02 Thread Peter Eisentraut
en I now try to access the database using: > > [postgres@10 bin]$ psql -u dpstatistics > username: dpstats > password: dpstats Spelling problems? -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED]

Re: [ADMIN] 'user' sql reserved word ?

2000-03-04 Thread Peter Eisentraut
Andre Antonio Parmeggiani writes: > => create table user (user text); > ERROR: parser: parse error at or near "user" USER is a reserved word in SQL92. To use it, enclose it in double quotes. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED]

Re: [ADMIN] Where to send patches?

2000-03-05 Thread Peter Eisentraut
o into the tree before the 7.0 release is cut. [EMAIL PROTECTED] If you don't want to receive messages on that list subscribe to [EMAIL PROTECTED] and you can post to any list without receiving traffic. Send mail to [EMAIL PROTECTED] to subscribe. ('subscribe' in body) -- Peter E

Re: [ADMIN] Is it possible...?...please...

2000-03-06 Thread Peter Eisentraut
terpan writes: > (Postgres doesn't work with NT4 no?) Sure it does. (With cygwin library.) -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Case insensitive

2000-03-11 Thread Peter Eisentraut
> select * from userdata wher name = 'John' > > select * from userdata wher name = 'joHN' > > will fetch me the same results. select * from userdata where lower(name) = 'john' -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PR

Re: [ADMIN] How to create a superuser ?

2000-03-11 Thread Peter Eisentraut
directory and pg_pwd file are not world-readable, so that shouldn't be a problem. I agree that the stuff should be encrypted anyway but that's a bit of work for a variety of other reasons. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Tuning postgres for high volume applications

2000-03-15 Thread Peter Vazsonyi
On Wed, 15 Mar 2000, Brian Baquiran wrote: > > 3) Turn off flush to disk > > (option -F ) > > (very little risk) If this parameter is set, increase much the speed of fast periodic inserts, updates. Because if postgres run without -F, every single statement generate a sync() syscall. > I'd rather

Re: [ADMIN] Any user can create table in any database?

2000-03-16 Thread Peter Eisentraut
default, users do not have write access to databases > they did not create." The documentation is wrong. You can currently create anything in any database you have access to. We're currently discussing a way to improve that in 7.1. Care to share your ideas? -- Peter Eisentraut

Re: [ADMIN] User permissions

2000-03-17 Thread Peter Eisentraut
that.) > can I restrict access with read-write vs. read-only privledges? Read and write privileges are done on a per table basis via grant and revoke. See manual entries. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] lower/upper case

2000-03-18 Thread Peter Eisentraut
same registers... what i doing? select * from books where lower(titulo) like '%perl%'; -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Case insensitive

2000-03-19 Thread Peter Eisentraut
ut, depending on your application. Alternatively you could try to implement your own data type based on text but make the = operator case insensitive, but that will probably create all sorts of extra trouble (indexes come to mind). > > select * from userdata where lower(name) = 'j

Re: [ADMIN] query length

2000-03-29 Thread Peter Eisentraut
On Tue, 28 Mar 2000, Walter M. Yuan wrote: > >PQsendQuery() -- query is too long. Maximum length is 16382 > >query buffer max length of 16384 exceeded > > Can anyone give me some quick advice on how to change this setting? Upgrade to 7.0. There isn't a way to change it

Re: [ADMIN] changing the owner of a db

2000-04-07 Thread Peter Eisentraut
On Thu, 6 Apr 2000, Tressens Lionel wrote: > Is it possible to change the owner of a db after having created it ? Update the pg_database table in accordance with the user ids listed in pg_users. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTEC

Re: [ADMIN] Emergency questions for new bie

2000-04-12 Thread Peter Eisentraut
27;timestamp' column, I got > this error and creating failed: 'Cannot find a default operator class > for type 1296.' Indexes don't work for timestamp in 6.5. Use datetime, or better yet upgrade to 7.0 which should be out in a few weeks. (jinx) -- Pe

Re: [ADMIN] pg_sorttemp files

2000-05-03 Thread Peter Eisentraut
On Wed, 3 May 2000, brianb wrote: > Ok, thanks. But why are they there in the first place, then? A backend crash during sorting -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] postgres types

2000-05-08 Thread Peter Eisentraut
's going on; don't rely on the particulars of the implementation. Anyway ... peter=# create table foo (a oid, b text); CREATE peter=# insert into foo values (-1, 'zzz'); INSERT 18730 1 peter=# select * from foo; a | b +- -1 | zzz (1 row) > > Can I have UNSIGN

[ADMIN] postgres instability?

2000-05-23 Thread Peter Vazsonyi
Hi! We use postgresql-6.5.2, on i386-linux (Rh.6.1), from 4-5 Xterminal, the apllications, and postgres runs on the same machine. there are approximately 30-40 inserts|updates /min. The performance is pertty well... but there are many backend crash (~10/day) ;( And after a crash some dust remains

[ADMIN] Re: [PORTS] Re: [BUGS] port v7.0 to SGI-IRIX-6.5.7/64

2000-05-24 Thread Peter Eisentraut
> > Again, a suggested change? This is probably what you want: http://research.cys.de/autoconf-archive/Miscellaneous/ac_func_accept_argtypes.html I've been meaning to clean up the autoconf mess soon anyway, so I can take a look at integrating this. -- Peter Eisentraut

Re: [ADMIN] A few misc. questions.

2000-05-26 Thread Peter Eisentraut
eferred, backing up the PG files or doing some sort of sync? For backup use pg_dump, for synchronization you're currently out of luck. > 4. Does anyone have any advice on how often to run VACUUM? Any rules of > thumb, etc? If there's a lot of write activity in your dat

Re: [ADMIN] few securiry questions

2000-05-30 Thread Peter Eisentraut
trust > host all0.0.0.0 0.0.0.0 reject > host all192.168.200.0255.255.255.0 password Because a mask of 0.0.0.0 matches every host, so the reject kicks in. The logic here is that ({host entry} XOR {actual host}) AND {mask entry} must be 0 for a r

[ADMIN] Re: few more securiry questions :-)

2000-05-31 Thread Peter Eisentraut
> 3.Are there any plans in making security system more > flexible? Sure. I'm planning some work on that very soon. Any suggestions you might want to contribute? -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] create view security

2000-05-31 Thread Peter Eisentraut
Wallingford, Ted writes: > I am using 6.3 in this case. I'm sorry but that is pre-historic era around here and no one really remembers what the problems might have been back then (other than that they were surely plenty). Upgrading might be your best bet on all fronts. -- Peter Ei

Re: [ADMIN] Re: few more securiry questions :-)

2000-06-01 Thread Peter Eisentraut
get in a repair things. It also looks like a race condition waiting to happen. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] table size limit under Linux

2000-06-01 Thread Peter Eisentraut
Giving more details on "failure" might help though. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] pgaccess use wrong password

2000-06-01 Thread Peter Eisentraut
ess still use the password in clear in pg_shadow . Is there an > option , i've not set correctly ? Perhaps pgaccess is not connecting via `local', but through TCP/IP localhost? -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Re: few more securiry questions :-)

2000-06-02 Thread Peter Eisentraut
you use some authentication mechanism. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] change is gewd

2000-06-03 Thread Peter Eisentraut
Hassanuri Bin Shah writes: > does anyone knows how to change the currency symbol in 'money' type ? > > from '$' to 'RM' `Money' has been deprecated for quite a while now. (The data type, not the concept :) Use numeric for storage and to_char

Re: [ADMIN] accent marks

2000-06-08 Thread Peter Eisentraut
HENAFF Mari-mai FTRD/DMI/LAN writes: > Is it possible to configure PostgreSQL, so that it is not accent mark > sensitive when making conditions upon strings on the queries ? No, you'll have to do that yourself. A simple tr 'âàáéÿ' 'aaaey' etc. could possibly do

Re: [ADMIN] multi processor

2000-06-12 Thread Peter Eisentraut
on per processor. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

[ADMIN] Re: case senesitive

2000-06-12 Thread Peter Eisentraut
HENAFF Mari-mai FTRD/DMI/LAN writes: > And is it possible to make a query containing an ORDER BY that is not case > sensitive ? Option 1: SELECT * FROM table ORDER BY upper(field); Option 2: Build with --enable-locale. Most locales sort a, A, b, B, etc. -- Peter Eise

Re: [ADMIN] multi processor

2000-06-12 Thread Peter Eisentraut
is one processor per process, that is, connection. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] Money Data type

2000-06-14 Thread Peter Eisentraut
On Tue, 13 Jun 2000, Meibell Contreras wrote: > Anyone knows if postgres has a bigger data type than money... when you > use this; (not with dollar definition); the money data type is not > enough... `numeric'. And use to_char() for formatting if you like. -- Pe

Re: [ADMIN] Database replication ?

2000-06-18 Thread Peter Eisentraut
Haroldo Stenger writes: > Besides this, I wonder if db replication could be done by reaplying > backend logs. Yup, if we only had backend logs... -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/p

Re: [ADMIN] users & groups

2000-06-18 Thread Peter Eisentraut
t; How can I remove a user from some group? ALTER GROUP foo DROP USER bar; RTFM :) -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

[ADMIN] RE: users & groups

2000-06-19 Thread Peter Eisentraut
On Mon, 19 Jun 2000, Nicolas Huillard wrote: > I think all that works in 7.0, not 6.5 ? Correct. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

Re: [ADMIN] users & groups

2000-06-19 Thread Peter Eisentraut
gt; their privileges on it. That could be a problem. Assume you delete all users from that table. How do you get back in and add any? But something like this is clearly needed, it just can't be in the database -- probably pg_hba.conf. -- Peter Eisentraut

Re: [ADMIN] PGresult

2000-06-19 Thread Peter Eisentraut
PGresult* res2 = PQexec (...); > // Process res2. > PQclear (res2); > // return back to res1 > } res1 and res2 are completely independent, you can use both as long and often as you want. Not sure how you want to "include" one in the other though. -- Peter Eisentraut

Re: [ADMIN] Unable to get psql compiled

2000-06-24 Thread Peter Eisentraut
mplete.o(.text+0x74): undefined reference to > `rl_completion_append_character' > tab-complete.o(.text+0x2654): undefined reference to > `rl_completion_append_character' > tab-complete.o(.text+0x2658): undefined reference to > `rl_completion_append_character' > gmake: *** [ps

Re: [ADMIN] Mergin a old dir with current system

2000-07-02 Thread Peter Eisentraut
't see the old table. There's no way to "plug-in" tables files like that. You are more or less out of luck. (The reason is that the table file only contains half the truth. The other half is in the pg_log file that used to belong to it, but it seems you don

Re: [ADMIN] Firewall setup

2000-07-07 Thread Peter Galbavy
tering bridge is a great backfill for filtering, as it requires no change to the "shape" of your network. Peter

Re: [ADMIN] Perl Procedural Language Install

2000-07-13 Thread Peter Eisentraut
; plperl.c:327: (Each undeclared identifier is reported only > once > plperl.c:327: for each function it appears in.) > plperl.c:333: 'na' undeclared (first use in this function) > > Has anyone seen this before? I can fix the C code if I can find out > w

Re: [ADMIN] Authenticating some users and trusting others

2000-08-20 Thread Peter Eisentraut
ux system to access PG as > root. Perhaps you are confused. There is nothing wrong with having a database user called "root". This user does not automatically have special privileges and is unrelated to any Unix root user. > Is it possible to mix two auth modes ? Not from

Re: [ADMIN] libpq errors when makeing postgres 7.0.2...

2000-09-17 Thread Peter Eisentraut
Dronamraju Rajesh writes: > /bin/sh: lorder: not found > /bin/sh: tsort: not found > /bin/sh: ar: not found It seems you need to install a few more things. Not sure what Sun calls this package, perhaps "binary utilities" or "compiler support". -- Peter Eis

Re: [ADMIN] pg_log deleted - what to do?

2000-10-01 Thread Peter Eisentraut
ting pg_log is almost like deleting the data itself. You make backups, don't you? -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [ADMIN] pg_log deleted - what to do?

2000-10-01 Thread Peter Eisentraut
which is inferred what tuples are valid. So theoretically you could set "all transactions have committed" in pg_log and pick out the tuples you like from the tables (after having gotten past the horribly corrupted indexes). But that seems like a pretty complicated undertaking in any case. -

Re: [ADMIN] What is a foo.1 file?

2000-10-06 Thread Peter Eisentraut
tbl_voters_full > -rw---1 postgres postgres 144687104 Oct 5 00:09 tbl_voters_full.1 The table "tbl_voters" exceeded 1 GB in size and was thus split up into two physical files. You will get .2, .3, etc. each time you grow another GB. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [ADMIN] ssh problem ?

2000-10-06 Thread Peter Eisentraut
tmaster running at 'localhost' > and accepting connections on Unix socket '5432'? Check that there's a socket file /tmp/.s.PSQL.5432. Maybe it got deleted accidentally. Restart the postmaster to create a new one. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [ADMIN] ERROR: ORDER BY is not allowed in INSERT/SELECT

2000-10-12 Thread Peter Eisentraut
Loïc TREGOUËT writes: > insert into tempo select id, name from topics order by name; > ERROR: ORDER BY is not allowed in INSERT/SELECT What's the point of this command? The values in "tempo" are going to end up in random order anyway. -- Peter Eisentraut [EMAIL

Re: [ADMIN] control on table creation

2000-10-14 Thread Peter Eisentraut
R D writes: > In the TODO list is mentioned that in PG-7.1 you will have "More > access control over who can create tables and use locks". The TODO list is wrong. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

[ADMIN] binding to a specific IP address

2000-10-19 Thread Peter Galbavy
ilar for a server. In case it is relevant, this is an OpenBSD server. rgds, -- Peter Galbavy Knowledge Matters Ltd. http://www.knowledge.com/

Re: [ADMIN] pg7.0.2 on Sol8

2000-10-19 Thread Peter Eisentraut
bly failed for you. You can read the file config.log to check why. I'd be interested to know. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

  1   2   3   4   5   6   7   8   9   >