[ADMIN] GetAvailableLocales aborting installation

The FAQ says it might be necessary to uninstall my antivirus/firewall software, but I won't do that. Would appreciate hints to get around this, thanks.     erik     === Verbose logging started: 05-05-2005  20:22:43  Build type: SHIP UNICODE 2.00.2600.1106  Calling process: C:\WINDOW

Re: [ADMIN] GetAvailableLocales aborting installation [SOLVED]

inAVR directory fixed the pgsql installation problem.   cheers,   erik   - Original Message - From: Magnus Hagander To: erik ; pgsql-admin@postgresql.org Sent: Friday, May 06, 2005 04:44 Subject: SV: [ADMIN] GetAvailableLocales aborting installation Fisrt of al

[ADMIN] Error starting Postmaster

Hi my name is Erik, I have some problems running Postmaster. I use Solaris 2.7 Intel and Postgres 6.5 When i try to start the Postmaster I get the following Errormessage: IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=1063936, permission=600 FATAL 1: ShmemCreate: cannot

[ADMIN] crypt'ed passwords not functioning properly

rl5; both have similar results. i've restarted postmaster, etc.) has anyone seen this and/or fixed it? tia, erik p.s. the only thing that i can think of, (and i thought of it as i was typing the last paragraph) is that ldd claims that the postgres binaries are linked against libc

Re: [ADMIN] crypt'ed passwords not functioning properly

that clear password are also stored in the pg_pwd file, which is by >default -rw-rw-rw-. You have to be sure to protect you Postgres directory with "chmod >700" > > Yours, > > Nicolas Huillard > > -Message d'origine- > De: erik cam

[ADMIN] Case Sensitive problem

Hi, I have got problems with case sensitive sort. I need my Postgre DB to be case insensitive, but I don't know how or where  to set it.   Could anyone help me, please.   Erik Ferencz

[ADMIN] ODBC connection problem

this application from my local computer (via File Shareing(SMB)) I can't connect to PostgreDB. I heve temporally stoped firewall,but it does not helped.    Could anyone help me please. I will be gratful.   Thank you   Erik Ferencz

Re: [GENERAL] Array assignment behavior (was Re: [ADMIN] Stored procedure

tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match . -- erik jones <[EMAIL PROTECTED]> software d

Re: [GENERAL] Array assignment behavior (was Re: [ADMIN] Stored procedure

ink we'd better do that, now that we can. regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings -- erik jones <[EMAIL PROTECTED]> software developmen

Re: [ADMIN] [GENERAL] Can I backup/restore a database in a sql script?

se with a lot of careful work it may be possible. See the chapter on Backup and Restore in the manual for the details of how PITR works (http://www.postgresql.org/docs/8.2/interactive/ backup.html). Erik Jones Software Developer | Emma® [EMAIL PROTECTED] 800.595.4401 or 615.292.5888 615.

[ADMIN] alter table serial->int

for some odd reason when i try to change a table fromserial to just plain "int with a default" postgres seems to ignore me. when i dump the schema i get ... CREATE TABLE custom ( id serial NOT NULL, name text, email text, ); then i run... alter table custom alter id type int; alter

Re: [ADMIN] alter table serial->int

> "Erik Aronesty" <[EMAIL PROTECTED]> writes: > > for some odd reason when i try to change a table from serial to just > > plain "int with a default" postgres seems to ignore me. > > What PG version? (PostgreSQL) 8.1.10 > The fact that you

Re: [ADMIN] alter table serial->int

-- Simpler example for you CREATE TABLE x ( id serial NOT NULL ); ALTER TABLE x alter id type int; -- Under 8.1.10, a call to pg_dump will reveal the change has not happened On Nov 8, 2007 11:13 AM, Erik Aronesty <[EMAIL PROTECTED]> wrote: > n Nov 7, 2007 12:11 AM, Tom Lan

Re: [ADMIN] alter table serial->int

CREATE TABLE x ( a serial NOT NULL ); alter table x alter a drop default; alter table x alter a set default 999; still doesn't help. i supposed i can dump the whole table and rebuild it but that's going to be a bit slow. ---(end of broadcast)-

Re: [ADMIN] query to find out # of buffer hits vs. # of disk reads ?

On Jan 14, 2009, at 8:47 AM, Kevin Kempter wrote: Hi all; Anyone know what system catalogs I need to query to find out # of disk reads and # of memory / buffercache reads ? See blks_hit and blks_read on the pg_stat_database view. Erik Jones, Database Administrator Engine Yard Support

[ADMIN] select based on date range

Is there a quick way to select based on a date range. For example I want all records that have a date greater than the current date but go out only as far as 1 week. Sync Consulting, LLC Erik B. Flitman Vice President

[ADMIN] Statement duration reporting

se odd and contradictory times? Thanks, Erik G. Burrows ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[ADMIN] Recover data from crashed HD

Hello! One of my harddrives crashed two day ago. Only the /lib och /usr directories was on one of my other hd's. The old hd can no longer be detected by the bios. I have reinstalled everything now. The data directory in the old /lib contains what I would guess is postgresqls table data. Can I re

Re: [ADMIN] Recover data from crashed HD

SOLVED!! I tried a tip of a earlier post - I wiped the new disk clean of all postgres packages. - I moved the old postgres lib dir to /var/lib/postgresql - did a apt-get install postgresql which installed postgres and all packages needed. During the installation process a message appeared the pac