Re: [ADMIN] can not start the postgresql, i use gentoo

# PostgreSQL's Database Directory PGDATA=/var/lib/postgresql/data Is this all you have in the postgresql.conf file??? That file is usually full with settings(most of them optional) but still... Are u sure? Andy. - Original Message - From: "guo weidong" <[EMAIL PROT

[ADMIN] writer process hangs???

Hi,   These are my process lists for postgresql. I use 8.0.3.   The time for writer process seems a little big(928:49 >> that is around 15 H). Is this a thread? Is it normal to be running that long? Best regards, Andy.   postgres  2967  0.0  0.7 544504 8120 ?   S    May30 

[ADMIN] Re: [ADMIN] Error: No se pudo localizar un registro de checkpoint valido ¿ Como soluciono ?

Is it possible to write in english?? Please!? - Original Message - From: "Fabio C. Bon" <[EMAIL PROTECTED]> To: Sent: Friday, July 22, 2005 2:59 PM Subject: [ADMIN] Error: No se pudo localizar un registro de checkpoint valido ¿ Como soluciono ? Tengo una instalación de PostgreSQL

Re: [ADMIN] PostgreSQL configuration problem

Title: Message Do you vacuum the database? It is very important if you insert and delete lot of rows. I think this is your problem.   Best regards, Andy. - Original Message - From: Gandeed Phanibhushan Rao-A18356 To: pgsql-admin@postgresql.org Sent: Monday

[ADMIN] Postgres: writer process !? Time of process not to long???

127.0.0.1(32779) idlepostgres  3066  0.0  3.3 551168 34348 ?  S    Oct12   0:05 postgres: slony mps_kd 127.0.0.1(32780) idlepostgres  3072  0.0  2.3 550056 24276 ?  S    Oct12   0:13 postgres: slony mps 127.0.0.1(32783) idle       Regards, Andy.

[ADMIN] Database LATIN1 to UFT-8 (unicode) converting problem

).   Please advise.   Thank you, Andy.  

Re: [ADMIN] Database LATIN1 to UFT-8 (unicode) converting problem SOLVED

I found a solution: I re-run initdb with Unicode encoding and now seems to work fine.   I cannot figure out why did this happen, or does the initdb encoding affects all the databases or the db encoding is not enough to be specified?   Andy.   - Original Message - From: Andy

Re: [ADMIN] WAL recovery question - 0000001.history

and causing errors when PG tries to read it.This will also remove as much human intervention as possible from the whole process.AndyTom Lane <[EMAIL PROTECTED]> wrote:> "Andy Shellam" <[EMAIL PROTECTED]> writes:> > Basically I've taken a dump of my live database direc

Re: [ADMIN] connection refused 274D/10061

If you're running Windows XP Service Pack 2 - you'll need to either turn off the Windows Firewall completely (not recommended) or tell it to create an exception for port 5432.You can do this through Control Panel > Windows Firewall.This is the same on Windows Server 2003.Andy[EM

[ADMIN] Problem Setting DateStyle

database test5 SET DateStyle='SQL, DMY';   none of these worked.   If I run in a session SET DateStyle='SQL, DMY' then it is ok for that session.   How can I make it default for the whole system or at least for some databases?   OS: Suse 10, pgsql 8.0.3.   Regards,   Andy.

Re: [ADMIN] Problem Setting DateStyle

the configuration. I attach the postgres.conf. Best regards, Andy. - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Andy" <[EMAIL PROTECTED]> Cc: Sent: Monday, June 26, 2006 5:50 PM Subject: Re: [ADMIN] Problem Setting DateStyle

Re: [ADMIN][SOLVED] Problem Setting DateStyle

Ups, sorry folks,   I use pgadmin3 for database access and it seems that it executes SET DateStyle=ISO; every time it connects. Same with phppgadmin4. If i connect with psql then it works fine.   Anyway good to know.   Best regards, Andy.   - Original Message - From

Re: [ADMIN] Vacuum error on database postgres

ebsite for a developer to download. Please contact me privately for a link: [EMAIL PROTECTED] ...Oh, also, this box has locked up on me a few times, so its not the most stable thing in the world. It did not lock up during import of this data, but there is flaky hardware in there someplace, so it co

[ADMIN] Compiling with Perl Support

out the perl support compiled in. I don't quite understand this one and I have read thru the docs as well as scanned the mailing list archives. Thanks in advance! Andy

[ADMIN] Compiling with Perl Support [Solved]

I have fixed this problem. The docs should say that: --prefix=BASEDIR must be specified in order for the --with-perl directive to work. Otherwise it will fail. Sorry Andy

[ADMIN] Problem getting postgres running.

Andy Doerr [EMAIL PROTECTED] FreeBSD 2.2.2 FreeBSD AtlantisPublishing.COM 2.2.2-RELEASE FreeBSD 2.2.2-RELEASE #0: Thu Apr 9 15:22:39 CDT 1998 [EMAIL PROTECTED]:/usr/src/sys/compile/ATLANTIS i386 CPU: Pentium Pro (199.44-MHz 686-class CPU) Origin = "GenuineIntel" Id = 0x619

Re: [ADMIN] postgresql-6.3.2 question

I'm not totall sure but, I wouldn't think that user postgres has enough system rights to install. Andy On Sat, 16 May 1998, The Hermit Hacker wrote: > >Hello, > >My question is this: > >Do I have to be user progres to install? Can I not use an existing user? If >

[ADMIN] Authentication Problem

I'm running PHP 3.05 on a remote machine trying to make a connection to our Postgres 6.1 machine. Here's the error that I'm getting: - Warning: Unable to connect to PostgresSQL server: Failed to authenticate client as Postgres us

Re: [ADMIN] Enormous pg_sorttemp~ files when using "OR"

ed as serial and having duplicate oid's. It happens on 3 of my 4 machines on a monthly basis. This really needs to be fixed because vacuum won't run without the serial fields being unique. All of the above running 6.5.3 Andy On Sat, 18 Dec 1999, Robin's Postgres List Archive w

[ADMIN] Strange error

I have a problem. First I had a drive error that I corrected and when I do a vacuum, I get the following: mydb=> vacuum; ERROR: OperatorObjectIdFillScanKeyEntry: unknown operator 93 Anyone know what I am susposted to do? I haven't the slightest idea of how to correct this one. Thanks Andy

[ADMIN] sqlstate 02000 while declaring cursor/freeing statement

I'm new to the PostgreSQL community so please pardon what is probably a silly question ... I'm in the process of porting Informix ESQL to PostgreSQL. I occasionally get sqlcode = 100 and sqlstate = 02000 when declaring cursors or freeing prepared statements. Is this normal? For example:

Re: [ADMIN] sqlstate 02000 while declaring cursor/freeing statement

Just so that we can snip this thread, we've confirmed that free cursor and free statement do not affect sqlca structure elements sqlcode and sqlstate. Michael Fuhr wrote: On Tue, Aug 30, 2005 at 09:01:36AM -0500, Thomas F. O'Connell wrote: On Aug 29, 2005, at 2:19 PM, andy

[ADMIN] WAL archive stopping too early

WAL LOCATION: 9/1AC3DCF8 (file 00010009001A) CHECKPOINT LOCATION: 9/1935C2F4 START TIME: 2006-02-16 11:39:57 GMT LABEL: /perth/backup/db/base_20060216.tar.gz STOP TIME: 2006-02-16 12:13:49 GMT Can anyone shed any light? Many thanks Andy Shellam the mail network - server support

Re: [ADMIN] WAL archive stopping too early

e again and see what happens. As for digging through xlog.c, I'm not a C programmer so I'll stay right out of the way - leave that to you guys!! Regards Andy Tom Lane wrote: Andy Shellam <[EMAIL PROTECTED]> writes: Note there are plenty more files ready to run in the ar

Re: [ADMIN] Installation Postgres 8.1.3 on Linux Suse 9.1

takes about a minute to compile depending on your system spec. Regards Andy Moritz Bayer wrote: Hello list,   I've got a problem installing postgres on my Linux machine. The Linux Version is Suse 9.1 and had a 7.4 postgres-version installed. Now I wanted to update to 8.1.3 using the so

Re: [ADMIN] Installation Postgres 8.1.3 on Linux Suse 9.1

/configure && make && make install Then try re-configuring pgSQL 8.1.3. Regards Andy

[ADMIN] WAL recovery

Is this scenario possible - that you can keep rolling forward over log files as long as necessary, or do you always have to start from a base backup?  Nothing is changing on the spare, it's literally a sitting duck. Thanks Andy

Re: [ADMIN] WAL recovery

rver DNS to the standby server. Sounds good!?! Cheers for the idea Simon, now to get coding...! Andy Simon Riggs wrote: On Wed, 2006-02-22 at 16:26 +, Andy Shellam wrote: Is this scenario possible - that you can keep rolling forward over log files as long as necessary, or do you

Re: [ADMIN] Deinstallation

replace apt-get with yum) - one of the above should work. Make sure BEFORE YOU CONFIRM the uninstall that it is only removing the 7.4 PGSQL binaries and nothing else. Regards Andy Moritz Bayer wrote: Hello again,   I've installed Postgres Version 8.1.3 on my Linux machine from sourc

Re: [ADMIN] PGPASSWORD

Look at your pg_hba.conf file - your old configuration might have had a "trust" authentication set somewhere for your local machine/network IPs, rendering any password unnecessary. Andy Mr. Dan wrote: Hi, When I was running 8.0.X on linux, I didn't have to include the postg

Re: [ADMIN] Deinstallation

've confirmed on Redhat Fedora the package is called "postgresql" - which is v7.4. Regards Andy Moritz Bayer wrote: Hi Andy, I guess I can call you my teacher pretty soon :-) Yes, the installation worked fine, the configuration isn't done yet. I've the feeling,

Re: [ADMIN] Priviliges and Roles

Hi Dayo, This is how I understand it, but I might be wrong: I believe the user who is has permission to execute the function also needs permissions to perform the table writes. Regards Andy Dayo Johnson <[EMAIL PROTECTED]> wrote: > Hello, > > Is it possible to do the follow

Re: [ADMIN] pg_hba.conf

Have you also changed your pg_ident.conf to map the user gowri to a database user, and does that database user exist in pgSQL? By default 127.0.0.1 is set up as trust authentication, so if you haven't changed this, it will always let you through no matter what username/password you give.

[Fwd: [ADMIN] Restricting the access to a database]

from browsing that schema? Andy Original Message Subject:[ADMIN] Restricting the access to a database Date: Thu, 23 Feb 2006 15:07:05 -0600 From: KyLiE <[EMAIL PROTECTED]> To: pgsql-admin@postgresql.org Hi all, im new in this and my question can sound

Re: [ADMIN] PostgreSQL on Windows 2003

Hi Vishal, Yes I have PG 8.1.3 running on Windows 2003 Standard Edition on my development server. I've had no problems whatsoever with it, from installation of 8.0 about 3 months ago to upgrading to the latest version. What in particular were you looking for info on? Cheers

Re: [ADMIN] PITR as Online Backup Solution

slave will not be propagated back to your master. Regards Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas F. O'Connell Sent: Thursday, 02 March, 2006 10:39 PM To: PGSQL Admin Subject: [ADMIN] PITR as Online Backup Solution I'm

Re: [ADMIN] PostgreSQL on Windows 2003

I have used PostgreSQL on XP, and there's very little (if any) operational difference. Since XP and 2003 are essentially the same base OS, I'm pretty confident you won't run into any problems. Regards Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTE

Re: [ADMIN] pg_hba.conf + all + trust = Ident authentication failed for user "postgres"

Does your pg_ident.conf contain anything with reference to testusr? As it seems to be trying Ident authentication over everything else and failing. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ow Sent: Monday, 06 March, 2006 1:02 PM To: pgsql

Re: [ADMIN] pg_hba.conf + all + trust = Ident authentication failed for user "postgres"

lso check your postgresql.conf file is not forcing pgSQL to look elsewhere for your config files. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ow Sent: Monday, 06 March, 2006 1:21 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_

Re: [ADMIN] pg_hba.conf + all + trust = Ident authentication failed for user "postgres"

t files to the ones you're editing. Might be worth running "find / -name pg_hba.conf" and "find / -name postgresql.conf" to see where all the instances of your config files lie. Something's not quite right... Andy -Original Message- From: [EMAIL PROTECTED] [ma

Re: [ADMIN] [SOLVED] pg_hba.conf + all + trust = Ident authentication failed

You could always symlink the debian config files to your correct ones. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ow Sent: Monday, 06 March, 2006 3:46 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] [SOLVED] pg_hba.conf + all + trust

Re: [ADMIN] VACUUM Error?

If you do "ps auxwww|grep postgres" on your console command line - you should find processes with a status of "IDLE IN TRANSACTION" or similar, and use that data and the PG server status to identify where it came from, and submit a COMMIT or ROLLBACK command on that connection. From: [EMAI

Re: [ADMIN] postgresql-8.0.1/Solaris 9/Readline-5.1

You also need termcap 1.3.1 installed alongside readline 5.1. Search the mailing lists for termcap-1.3.1 and find my other post which has a download link, or search for termcap in Google. Andy On Wed, 08 Mar 2006 01:26:59 -0500, Louis Gonzales <[EMAIL PROTECTED]> wrote: > Hello

Re: [ADMIN] PITR as Online Backup Solution

If you do symlink your configs (like I do), check the symlinks on your recovery box are still valid. Regards Andy ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] reg:conninfo

Ps your server is listening on, and your application is trying to connect to. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of sandhya Sent: Monday, 20 March, 2006 9:49 AM To: Robin Iddon Cc: Postgres Subject: Re: [ADMIN] reg:conninfo Thanks Robin

Re: [ADMIN] reg:conninfo

opposed to an IP address? Using localhost (or 127.0.0.1) saves you a slight network overhead than connecting on your network interface's IP. Andy -Original Message- From: sandhya [mailto:[EMAIL PROTECTED] Sent: Monday, 20 March, 2006 10:13 AM To: [EMAIL PROTECTED] Cc: Postgres Subjec

FW: [ADMIN] reg:conninfo

d not listen_interfaces=127.0.0.1. This will bind it to any available network adapter on your system. Then reload PGSQL and try connecting on 10.0.0.205 again. Andy ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] reg:conninfo

Robin, I believe this is on a Windows machine (judging by the screenshot I was sent of the error message.) I think it's that PGSQL is set to only listen on the localhost IP. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robin Iddon Sent: M

Re: [ADMIN] reg:conninfo

hen set listen_interfaces to one of those IPs and try connecting directly to that IP. Andy -Original Message- From: sandhya [mailto:[EMAIL PROTECTED] Sent: Monday, 20 March, 2006 11:21 AM To: [EMAIL PROTECTED] Subject: Re: [ADMIN] reg:conninfo I have changed listen_interfaces =*. and gav

Re: [ADMIN] Renaming a sequence?

You also need to alter your column's default value to point to your new sequence (nextval('public.watchlist_id_seq'::text)). I'm not certain of the SQL to do this but must be along the order of "ALTER COLUMN . DEFAULT nextval('public.watchlist_id_seq':

Re: [ADMIN] WAL file naming convention

As PostgreSQL numbers WALs sequentially, as long as your ls command by default orders listings by filename, then Yes.  Or you could list by the last modified date/time should give the same effect.   Andy From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sriram DandapaniSent

Re: [ADMIN] reg:create database

> In the document they mentioned that . is used as a seperator for a > table/column name I would say for this very reason the answer would be No, but I might be wrong... Andy ---(end of broadcast)--- TIP 9: In versions below 8.0, the p

Re: [ADMIN] reg:create database

sistent you want to use a dot? Can't you use underscores instead? Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of sandhya Sent: Monday, 27 March, 2006 12:27 PM To: Jim C. Nasby Cc: Michael Fuhr; Postgres Subject: Re: [ADMIN] reg:create database o

Re: [ADMIN] Bloated pg_shdepend_depender_index

in PGSQL you can just re-dump your data and revert back to the previous version providing you're not using any features the previous version doesn't understand - it gives much more flexibility and more confidence in the upgrade. Andy -Original Message- From: [EMAIL PROTECTED] [ma

FW: [ADMIN] Setting up of PITR system.

directory? Regds Rajesh Kumar Mallah.    !DSPAM:14,44293ed135042000516834! Regards   Andy Shellam

Re: [ADMIN] Bloated pg_shdepend_depender_index

This is true, but you could run the new version on the same server/different port to the current version, and do a simultaneous dump/restore without having to use extra disk space, or taking your production database offline - then you can schedule a time to kill the old one, re-assign the port on t

Re: FW: [ADMIN] Setting up of PITR system.

er archive utility you're using, if a file is being changed at the time of reading, it won't be archived correctly. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rajesh Kumar Mallah Sent: Tuesday, 28 March, 2006 5:27 PM To: Tom Lane

FW: [ADMIN] Ubuntu: Start and Stop

At risk of going off the original subject: To re-enable root access in Ubuntu, login as your first created user, and type "sudo passwd root" - type in a new root password, confirm it and bingo, your root account is ready for direct login, should you need it. Andy -Original Message

Re: FW: [ADMIN] Setting up of PITR system.

as you've got all the WAL logs available AFTER the dump is done, then it'll fix any inconsistencies in the data when you do the restore. Hope this helps Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sriram Dandapani Sent: Friday, 31 March, 20

[ADMIN] Show tables query

ation parameter TABLES."   Any ideas?   Thanks   Andy

FW: [ADMIN] Show tables query

Hi Grega, That's perfect thanks. I needed the SQL as it will be running in a web application, and I need to use the resulting list for processing within the application. Many thanks Andy -Original Message- From: Grega Bremec [mailto:[EMAIL PROTECTED] Sent: Sunday, 02 April, 20

Re: [ADMIN] Show tables query

> After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] ("Andy Shellam") belched out: >> Is there an SQL command supported by Postgres to return a list of tables in a database? Sorry, did I say something wrong? I thought it was a perfectly valid question actually.

Re: [ADMIN] Show tables query

Thanks Rajesh, That's always a risk anyway with anything - hence where upgrade testing comes in ;-) I'll probably go this way if I do indeed have this need still - it was only a preliminary thought process, I just thought I'd ask the question. Thanks Andy -Original Me

Re: [ADMIN] PITR Based replication ...

te rsync'd data directory. Andy > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-admin- > [EMAIL PROTECTED] On Behalf Of Robin Iddon > Sent: 05 April 2006 9:10 am > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] PITR Based replication ... > >

Re: [ADMIN] I have a question?

Hmm,   Not sure about an easy way to do this using Postgres's built-in tools - try www.sqlmanager.net - they have lots of export tools to export data from one system to another, and they do 30-day trials of most of them.   Andy From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On B

Re: [ADMIN] I have a question?

other. www.sqlmanager.net has some useful tools like that, and for a one-off job most of them come as 30-day trials. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] org] On Behalf Of Milen Dzhumerov Sent: Sunday, 09 April, 2006 10:37 pm To: pgsql-admin@postgresql.org Subjec

Re: [ADMIN] Autovacuum ideas

The problem is the PG team are looking at making autovac compulsory (ie. You can't turn it off). I don't know when, might be in 8.2, but I know the issue has been discussed on the lists before. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

Re: [ADMIN] [SQL] Thoughts on a Isolation/Security problem.

PGSQL I’m sure has a global variable for the current user that you can use in an SQL statement – e.g. “SELECT * FROM TABLE WHERE CompanyUser = ‘%CURRENTUSER%’”   You’ll have to substitute %CURRENTUSER% with the correct global variable as I can’t think what it is at the moment.   Andy

Re: [ADMIN] downward dump compatibility

Nothing to do with file size limitations is there? What are your system specs? > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-admin- > [EMAIL PROTECTED] On Behalf Of tony > Sent: 18 April 2006 2:16 pm > To: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] downward dump comp

Re: [ADMIN] downward dump compatibility

ersion? If you're using the 7.3 pg_dump, try telling the 8.1 to connect to your public server - that way you'll have an 8.1-compatible dump anyway. If you're using your 8.1 already, try the 7.3, to rule out the possibility of anything in your DB causing a problem to the 8.1 pg_dum

Re: [ADMIN] IDLE IN TRANSACTION

No problem really, all it means is the application has issued a start of transaction command, it just isn’t doing anything at the moment. Transactions allow any data added during the application’s running to be rolled back should, for example, the application crash – it’ll prevent half-wr

Re: [ADMIN] Is it a bug ?

Hi Pascal,   7.3 is now quite out-dated – have you tried the latest release, 8.1.3, to see if the problem is still present?   Andy   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pascal Tufenkji Sent: 25 April 2006 10:02 am To: pgsql-admin@postgresql.org

Re: [ADMIN] Is it a bug ?

to 7.3.8 or something), and it wouldn’t cause you much downtime.   Andy   From: Pascal Tufenkji [mailto:[EMAIL PROTECTED] Sent: 25 April 2006 10:51 am To: [EMAIL PROTECTED] Subject: RE: [ADMIN] Is it a bug ?   Hi Andy   Actually no… I just tried it on Postgres 8.0.4 and there is

[ADMIN] WAL recovery question - 0000001.history

o it's not going to be harmful to the recovery if these files are empty? Thanks Andy ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] Backing up large databases

  Andy   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Burrows Sent: 28 April 2006 4:58 pm To: pgsql-admin@postgresql.org Subject: [ADMIN] Backing up large databases   I am struggling to find an acceptable way of backing up a PostgreSQL 7.4 database. The

Re: [ADMIN] connection refused 274D/10061

PostgreSQL service if you've had to change it. Also check your pg_hba.conf, for the "ipv4" lines. Andy ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] Locallhost Windows installation

time as you install Postgres, it’ll add a connection to PgAdmin for the local server.   The latest version manual can be found on the documentation website – that’ll give you any information you need regarding config files etc.   Andy   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

Re: [ADMIN] Locallhost Windows installation

network for obvious security reasons).  However md5 states that a valid password must be required to connect.  I believe you can use crypt as well.   Well done on choosing PostgreSQL!  I’m sure when you get up and running to know the system you’ll be glad of the choice you made.   Andy PS.  Don’t

Re: [ADMIN] Locallhost Windows installation

machines, or the ODBC connector (depending on what your java app uses.)  You only need to install PostgreSQL itself on the server.   Andy   From: System Consult [mailto:[EMAIL PROTECTED] Sent: 09 May 2006 2:02 pm To: [EMAIL PROTECTED] Subject: Re: [ADMIN] Locallhost Windows

Re: [ADMIN] Query - creating of Database in local machine

The easiest way would be to download the MSI package (on Windows) or the binaries for your flavour of Linux.  It only takes a few minutes to get up and running.   Best thing would be to read through the latest (v8.1) manual, there’s an installation section in there. Andy

Re: [ADMIN] Query

(Linux.)   Andy   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 09 May 2006 5:45 am To: pgsql-admin@postgresql.org Subject: [ADMIN] Query   Hi ,     Is it possible to create a local copy of PostgreSQL database that is present in server even

Re: [ADMIN] Terminating Idle Connections

than try and patch it.   A “ps auxwww|grep postgres” will show you the host of the connection, the DB it’s connect to and the user (as long as this is enabled in your PG config.) Andy   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Hoover Sent: 10 May 2006 12:30

Re: [ADMIN] Newbie question on pdAdminIII tool

found it's best to keep it all lower-case. Andy > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-admin- > [EMAIL PROTECTED] On Behalf Of Paul J. & Melinda Savoy > Sent: 11 May 2006 12:56 am > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Newb

Re: [ADMIN] regarding image files in DB

I would think a data type with the likes of “binary” (bytea?) would be more appropriate.  It’s like trying to upload an image via FTP in ASCII format – it never comes out the same the other end.     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of sandhya Sent: 11

Re: [ADMIN] trobles in importing dbf file

You can create a column in your destination table with a data type of "serial" which will be an auto-incrementing number with every inserted row. Or if you create the table with "WITH OIDS", PostgreSQL will add an internal object ID. The above will take care of your uniqu

Re: [ADMIN] install postgre on windows XP, service failed to start.

is set anyway - run services.msc and have a browse for the local policy "Log on as a service". Your postgres service user should be added to it. Andy Jaime Casanova wrote: On 5/13/06, Jeff Zhong <[EMAIL PROTECTED]> wrote: I installing postgre SQL on Windowx XP Product: PostgreSQL 8.

Re: [ADMIN] install postgre on windows XP, service failed to start.

Sorry, you need to run "secpol.msc" to check the local policy, NOT "services.msc" - my mistake. Andy Andy Shellam wrote: Make sure that the account under which you've installed it (i.e your user account) has full Administrator priveledges on the machine - other

Re: [ADMIN] Fw: reg:logon failure

& Groups MMC (lusrmgr.msc) and open up the user account for your postgres service - you can set "Password never expires" to get around this for this user only. Andy > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-admin- > [EMAIL PROTECTED] On Behalf Of sand

Re: [ADMIN] Error in MS Access

Title: Error in MS Access I take it you’ve checked your server?  i.e. disk space, available memory, state of the postgresql service?   If you provide some more info, such as the platform you’re running the server on, server version, ODBC driver version etc, we could help more.   Andy

Re: [ADMIN] reg:Query

SELECT ….. LIMIT 1   Will get the first row in the dataset.  Then to fetch the next row, you can do SELECT …… LIMIT 1 OFFSET 1 (will get the 2nd record) and so on. (replace ….. with your conditions, LIMIT must come at the end of the query)   Andy   From: [EMAIL PROTECTED

FW: [ADMIN] reg:Query

Actually, just realized, this depends on your PGSQL version.    The older format (pre-8.0 I believe) is SELECT ….. LIMIT x, y  (where x is the number of rows to fetch, and y is the offset (ie. Select x number of rows, starting from row y.)   Andy   From: [EMAIL PROTECTED

Re: [ADMIN] reg:Query

, 1; Note LIMIT 1, 0 (and LIMIT 1 OFFSET 0) is the same as LIMIT 1 Andy From: sandhya [mailto:[EMAIL PROTECTED] Sent: 16 May 2006 2:28 pm To: [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] reg:Query yes..I got it. SELECT

Re: [ADMIN] reg:Query

application queries rewritten. Ref: section 7.6 in the 8.1-series manual. I'm sure you could use both pre-8.0 - it's just that the LIMIT X,Y format was withdrawn after 8.0. Andy > > Curious; I've never seen this format. I've been using the first for > some time now wit

Re: [ADMIN] reg:Query

> Your earlier messages in the thread seemed to imply that LIMIT X,Y was > the ONLY format that would work pre-8.0. I had 2 applications that used the LIMIT X,Y format, and having started out with Postgres on 8.0.0 (only touching base with 7.4), plus coming from a mySQL background (which did use L

Re: [ADMIN] Error in Access

w what happened since - whether he got it sorted. Regards Andy Jim C. Nasby wrote: On Mon, May 15, 2006 at 10:09:25AM -0500, Xu, Xiaoyi (Rocky) FSM wrote: Hi, My database users are getting following error: ODBC-call failed Error while executing query Error: ItsWriteBlock: failed to w

Re: [ADMIN] \i running on windows

cript" option to read it from file) - I haven't used PgAdmin, I use SQL Manager's PostgreSQL Manager Lite - it's much more intuitive. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jerome Sent: Friday, 26 May, 2006 7:20 pm To: p

Re: [ADMIN] \i running on windows

Have you tried running your script in PgAdmin (or similar GUI)? e.g. copy and paste your script into a new query? jerome wrote: > Andy Shellam a écrit : > > >> Where are you trying to run your scripts, in PgAdmin, or from the psql >> client? In psql you should specify

Re: [ADMIN] Problem building initdb on sparc10

Title: Problem building initdb on sparc10 Should you need to add –lgcc to the linker path?  (e.g. –L/usr/lib –lgcc) or –lgcc_s?   I had a similar thing with readline.  Just a guess!   Andy   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Averbukh Stella Sent

Re: [ADMIN] Problem building initdb on sparc10

EMAIL PROTECTED] Sent: 30 May 2006 3:00 pm To: [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Subject: RE: [ADMIN] Problem building initdb on sparc10   Andy,   thank you very much for the idea.   I tried what you suggested even though -lgcc flag is usually used with -nostdlib and -node

Re: [ADMIN] Problem building initdb on sparc10

Title: RE: [ADMIN] Problem building initdb on sparc10 Although I did actually find this library on my system: find / -name "libgcc_s.so.1" /lib/libgcc_s.so.1 _ From: Averbukh Stella [mailto:[EMAIL PROTECTED]] Sent: 30 May 2006 3:45 p

  1   2   3   >