Re: Help. Pg not running

Thank's

I have trying to restarting pg and copying xlogs file from the last backup. 
Until some trial and error, it working.

DEBUG: database system was interrupted at 2003-06-28 02:41:38 JAVT
DEBUG: CheckPoint record at (0, 12369592)
DEBUG: Redo record at (0, 12369592); Undo record at (0, 0); Shutdown FALSE
DEBUG: NextTransactionId: 14017; NextOid: 32252
DEBUG: database system was not properly shut down; automatic recovery in 
progress...
DEBUG: ReadRecord: record with zero len at (0, 12369656)
DEBUG: redo is not required
DEBUG: database system is in production state

And now i can backup all db. I will upgrade my last 7.12 version to 7.3. 
Maybe i need to use extended 3 for my linux filesystem and installing UPS 
for protecting my PG server.

Thank's Sam Barnet & Scott Marlowe for your guid.

Asidha Luhwidyanto
--------------------
http://dijogja.com/  
for information of Jogja-Java-Indonesia

> On Mon, 30 Jun 2003, Asidha Luhwidyanto wrote:
> 
>> Dear All,
>>

Re: postgreSQL users = LDAP users?

On Monday 30 June 2003 23:39, Hans Spaans wrote:
> On Sun, Jun 29, 2003 at 07:44:50PM +0200, Daniel Seichter wrote:
> > Hello,
> > is it possible, to create all users of the databaseserver through LDAP?
> > An schema extension is maybe required, but is it possible, yes or no?!
> > If yes, where to find more information?
>
> We have pg using pam and pam uses ldap. It's just all standard
> pam/ldap stuff so it shouldn't be any problem. And there are plenty
> manuals about pam and ldap.

	In that case can somone surgest some good documentation on ldap and pam. As 
I've been try to set it up for months unsucsessfully.....
	All the web sites I've seen are a little uncomprohensable. 
	Sorry this is a little off topic.

Peter Childs

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Re: big tables with lots-o-rows

_Could_ it be that you're hitting a filesystem limit here? I am not 100% 
certain, but I believe ext2 by default supports only files of 2.? GB at 
most... Yet I am not certain if this is really what's wrong, but I would 
look in that direction.

Michiel

At 11:48 30-6-2003 -0700, Chris G. Nicholas wrote:
>hmmm - I built/installed the latest/greatest postgresql-7.3.3 sources with 
>the "--enable-largefile" flag, and am trying to load a few million rows 
>into a fairly healthy box. But after a certain point in loading, I hit 
>the: "no space left on device" error.
>
>Resultant Makefiles have things like:
>#define _FILE_OFFSET_BITS 64
>#define _LARGEFILE_SOURCE 1
>
>I fire up postgres with:
>
>/usr/local/pgsql/bin/pg_ctl start -D /data/postgres/gextest -l 
>/var/log/postgres/gextest -o -i
>
>suggestions/comments/flames/rtfms welcomed!
>
>thanks -
>Chris Nicholas
>GlobeXplorer
>
>----------------------------------------------------------------------
>

Displaying kind of triggers on tables.

Hi,

It would be nice if \d command displayes the
trigger details . Currently we use 
pg_dump -s -t table_name  to get the details.

For many users the communication between server
and client is not ver fast so pg_dump takes ages
other option is to login to the remote db server
and excute pg_dump local that is what i do anyway.

Details means name of procedure getting executed +
when , [ before|after]  [update | insert ] 

if this feature is worth shall i try writing a patch 

regds
Mallah.

--

-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

---------------------------(end of broadcast)---------------------------

cannot read block 319 - Input/output Error

Re: Help. Pg not running

On Mon, 30 Jun 2003, Asidha Luhwidyanto wrote:

> And now i can backup all db. I will upgrade my last 7.12 version to 7.3.
> Maybe i need to use extended 3 for my linux filesystem and installing UPS
> for protecting my PG server.

Don't forget that the database has to be re-inited between versions -
best to do a dump, backup the data dir just in case, and then start with
a fresh empty data dir to import to.

> > On Mon, 30 Jun 2003, Asidha Luhwidyanto wrote:
> >
> >> Dear All,
> >>
> >> I'm sorry, I'm a beginer in PostgreSQL.
> >>
> >> I have problem with my PostgreSQL after my server un complete
> >> shutdown. When i want to run postmaster there some error massage and
> >> postmaster can't run.
> >>
> >> this is the massage :
> >>
> > <SNIP ERRORS>
> >>
> >> What i must to do to fixing this problem ?
> >
> > This is exactly what happened to me before - the WAL (write-ahead-logs)
> > or xlogs have become corrupt, or more like;ythe pg_control file got
> > wiped. What you need to do is:
> >
> > 1) backup your xlogs and pg_control, just in case.
> >
> > 2) touch to make an empty pg_control
> >
> > 3) read the manpage on pg_resetxlog - figure out the correct
> > transaction id and other values, and run the program. Possibly backup
> > the entire DB directory structure, just in case.
> >
> > 4) Trial and error (possibly) until you get the server to start again.
> > Then do *nothing* until you have dumped the db to a file, and cleanly
> > resotred from it. You should also manually check for inconsistencies,
> > although if you have correctly used contraints it should barf on input
> > if there are any. Assuming your DB is fully normalised.
> >
> > Hope that helps
> >
> > --
> >
> > Sam Barnett-Cormack
> > Software Developer                           |  Student of Physics &
> > Maths UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster
> > University
> >
> > ---------------------------(end of
> > broadcast)--------------------------- TIP 1: subscribe and unsubscribe
> > commands go to majordomo <at> postgresql.org
>
>

--

-- 

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Re: big tables with lots-o-rows

On Tue, 1 Jul 2003, Michiel Lange wrote:

> _Could_ it be that you're hitting a filesystem limit here? I am not 100%
> certain, but I believe ext2 by default supports only files of 2.? GB at
> most... Yet I am not certain if this is really what's wrong, but I would
> look in that direction.

IT's a kernel-level limit, for single files. A kernel recompile with
large file support will eliminate that, if it is the problem.

> At 11:48 30-6-2003 -0700, Chris G. Nicholas wrote:
> >hmmm - I built/installed the latest/greatest postgresql-7.3.3 sources with
> >the "--enable-largefile" flag, and am trying to load a few million rows
> >into a fairly healthy box. But after a certain point in loading, I hit
> >the: "no space left on device" error.
> >
> >Resultant Makefiles have things like:
> >#define _FILE_OFFSET_BITS 64
> >#define _LARGEFILE_SOURCE 1
> >
> >I fire up postgres with:
> >
> >/usr/local/pgsql/bin/pg_ctl start -D /data/postgres/gextest -l
> >/var/log/postgres/gextest -o -i
> >
> >suggestions/comments/flames/rtfms welcomed!
> >
> >thanks -
> >Chris Nicholas
> >GlobeXplorer
> >
> >----------------------------------------------------------------------
> >
> >#uname -a
> >Linux pogo 2.4.20-8smp #1 SMP Thu Mar 13 17:45:54 EST 2003 i686 i686 i386
> >GNU/Linux
> >
> >#vmstat
> >    procs                      memory      swap          io     system
> >   cpu
> >  r  b  w   swpd   free   buff  cache   si   so    bi    bo   in    cs us
> > sy id
> >  0  0  0  23996  14348  97416 1853848    0    0     6    26   78    42
> > 10  2  3
> >
> >
> >#more /etc/fstab
> >LABEL=/                 /                       ext3    defaults        1 1
> >none                    /dev/pts                devpts  gid=5,mode=620  0 0
> >LABEL=/extra            /extra                  ext3    defaults        1 2
> >none                    /proc                   proc    defaults        0 0
> >none                    /dev/shm                tmpfs   defaults        0 0
> >/dev/hda5               swap                    swap    defaults        0 0
> >/dev/hda8               swap                    swap    defaults        0 0
> >/dev/sda1               /data                   ext2    defaults        1 3
> >/dev/hda2               /extra2                 ext2    defaults        1 3
> >#
> >#
> >boss:/big2              /big2                   nfs     defaults        0 0
> >
> >
> >
> >#df -k
> >Filesystem           1K-blocks      Used Available Use% Mounted on
> >/dev/hda1              6048320   3250992   2490088  57% /
> >/dev/hda6              4411616     32828   4154684   1% /extra
> >none                   1032252         0   1032252   0% /dev/shm
> >/dev/sda1            481590296 268914636 188212284  59% /data
> >/dev/hda2             70557084   2220916  64752068   4% /extra2
> >boss:/big2           279914496 205316700  71798652  75% /big2
> >
> >
> >---------------------------------------------------------
> >
> >[postgres <at> pogo postgres]$ cd gextest
> >[postgres <at> pogo gextest]$ ls -lR
> >.:
> >total 44
> >drwx------    5 postgres postgres     4096 Jun 29 11:44 base
> >drwx------    2 postgres postgres     4096 Jun 30 08:15 global
> >drwx------    2 postgres postgres     4096 Jun 29 11:43 pg_clog
> >-rw-------    1 postgres postgres     2329 Jun 29 11:43 pg_hba.conf
> >-rw-------    1 postgres postgres     1441 Jun 29 11:43 pg_ident.conf
> >-rw-------    1 postgres postgres        4 Jun 29 11:43 PG_VERSION
> >drwx------    2 postgres postgres     4096 Jun 30 03:04 pg_xlog
> >-rw-------    1 postgres postgres     5218 Jun 29 11:43 postgresql.conf
> >-rw-------    1 postgres postgres       37 Jun 29 23:25 postmaster.opts
> >-rw-------    1 postgres postgres       49 Jun 29 23:25 postmaster.pid
> >
> >./base:
> >total 12
> >drwx------    2 postgres postgres     4096 Jun 29 11:44 1
> >drwx------    2 postgres postgres     4096 Jun 29 11:43 16975
> >drwx------    2 postgres postgres     4096 Jun 30 08:15 16976
> >
> >./base/1:
> >total 3652
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 1247
> >-rw-------    1 postgres postgres   114688 Jun 29 11:43 1249
> >-rw-------    1 postgres postgres   475136 Jun 29 11:43 1255
> >-rw-------    1 postgres postgres    24576 Jun 29 11:43 1259
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16384
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16386
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16388
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16390
> >-rw-------    1 postgres postgres   106496 Jun 29 11:43 16392
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16394
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16396
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16398
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16400
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16402
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16404
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16406
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16408
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16410
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16412
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16414
> >-rw-------    1 postgres postgres    98304 Jun 29 11:43 16416
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16418
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16594
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16596
> >-rw-------    1 postgres postgres   163840 Jun 29 11:43 16598
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16600
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16601
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16602
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16603
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16604
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16605
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16606
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16607
> >-rw-------    1 postgres postgres   122880 Jun 29 11:43 16608
> >-rw-------    1 postgres postgres    40960 Jun 29 11:43 16609
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16610
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16611
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16612
> >-rw-------    1 postgres postgres    40960 Jun 29 11:43 16613
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16614
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16615
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16616
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16617
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16618
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16619
> >-rw-------    1 postgres postgres   114688 Jun 29 11:43 16622
> >-rw-------    1 postgres postgres   139264 Jun 29 11:43 16623
> >-rw-------    1 postgres postgres    65536 Jun 29 11:43 16624
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16627
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16628
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16629
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16630
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16631
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16632
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16633
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16634
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16635
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16636
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16637
> >-rw-------    1 postgres postgres    90112 Jun 29 11:43 16638
> >-rw-------    1 postgres postgres    90112 Jun 29 11:43 16639
> >-rw-------    1 postgres postgres  1024000 Jun 29 11:43 16640
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16641
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16642
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16645
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16646
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16647
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16648
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16649
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16650
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16651
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16654
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16656
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16657
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16659
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16663
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16665
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16669
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16671
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16672
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16674
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16678
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16680
> >-rw-------    1 postgres postgres    65776 Jun 29 11:44 pg_internal.init
> >-rw-------    1 postgres postgres        4 Jun 29 11:43 PG_VERSION
> >
> >./base/16975:
> >total 3652
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 1247
> >-rw-------    1 postgres postgres   114688 Jun 29 11:43 1249
> >-rw-------    1 postgres postgres   475136 Jun 29 11:43 1255
> >-rw-------    1 postgres postgres    24576 Jun 29 11:43 1259
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16384
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16386
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16388
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16390
> >-rw-------    1 postgres postgres   106496 Jun 29 11:43 16392
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16394
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16396
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16398
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16400
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16402
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16404
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16406
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16408
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16410
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16412
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16414
> >-rw-------    1 postgres postgres    98304 Jun 29 11:43 16416
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16418
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16594
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16596
> >-rw-------    1 postgres postgres   163840 Jun 29 11:43 16598
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16600
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16601
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16602
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16603
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16604
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16605
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16606
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16607
> >-rw-------    1 postgres postgres   122880 Jun 29 11:43 16608
> >-rw-------    1 postgres postgres    40960 Jun 29 11:43 16609
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16610
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16611
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16612
> >-rw-------    1 postgres postgres    40960 Jun 29 11:43 16613
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16614
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16615
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16616
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16617
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16618
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16619
> >-rw-------    1 postgres postgres   114688 Jun 29 11:43 16622
> >-rw-------    1 postgres postgres   139264 Jun 29 11:43 16623
> >-rw-------    1 postgres postgres    65536 Jun 29 11:43 16624
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16627
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16628
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16629
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16630
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16631
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16632
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16633
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16634
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16635
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16636
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16637
> >-rw-------    1 postgres postgres    90112 Jun 29 11:43 16638
> >-rw-------    1 postgres postgres    90112 Jun 29 11:43 16639
> >-rw-------    1 postgres postgres  1024000 Jun 29 11:43 16640
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16641
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16642
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16645
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16646
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16647
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16648
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16649
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16650
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16651
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16654
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16656
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16657
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16659
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16663
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16665
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16669
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16671
> >-rw-------    1 postgres postgres    32768 Jun 29 11:43 16672
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16674
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16678
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16680
> >-rw-------    1 postgres postgres    65776 Jun 29 11:43 pg_internal.init
> >-rw-------    1 postgres postgres        4 Jun 29 11:43 PG_VERSION
> >
> >
> >./base/16976:
> >total 11088460
> >-rw-------    1 postgres postgres    40960 Jun 29 23:28 1247
> >-rw-------    1 postgres postgres   196608 Jun 30 08:15 1249
> >-rw-------    1 postgres postgres   524288 Jun 29 23:16 1255
> >-rw-------    1 postgres postgres    57344 Jun 30 08:15 1259
> >-rw-------    1 postgres postgres        0 Jun 29 11:44 16384
> >-rw-------    1 postgres postgres    32768 Jun 29 23:30 16386
> >-rw-------    1 postgres postgres        0 Jun 29 11:44 16388
> >-rw-------    1 postgres postgres    24576 Jun 30 08:15 16390
> >-rw-------    1 postgres postgres   106496 Jun 29 18:37 16392
> >-rw-------    1 postgres postgres     8192 Jun 29 18:37 16394
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16396
> >-rw-------    1 postgres postgres     8192 Jun 29 18:37 16398
> >-rw-------    1 postgres postgres     8192 Jun 29 18:37 16400
> >-rw-------    1 postgres postgres     8192 Jun 29 11:45 16402
> >-rw-------    1 postgres postgres        0 Jun 29 11:44 16404
> >-rw-------    1 postgres postgres     8192 Jun 29 11:45 16406
> >-rw-------    1 postgres postgres    32768 Jun 29 11:44 16408
> >-rw-------    1 postgres postgres    32768 Jun 29 11:44 16410
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16412
> >-rw-------    1 postgres postgres        0 Jun 29 11:44 16414
> >-rw-------    1 postgres postgres    98304 Jun 29 11:44 16416
> >-rw-------    1 postgres postgres    16384 Jun 29 11:48 16418
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16594
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16596
> >-rw-------    1 postgres postgres   204800 Jun 30 08:15 16598
> >-rw-------    1 postgres postgres    16384 Jun 29 11:45 16600
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16601
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16602
> >-rw-------    1 postgres postgres    16384 Jun 29 11:45 16603
> >-rw-------    1 postgres postgres    16384 Jun 29 11:45 16604
> >-rw-------    1 postgres postgres    16384 Jun 29 11:45 16605
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16606
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16607
> >-rw-------    1 postgres postgres   196608 Jun 30 08:15 16608
> >-rw-------    1 postgres postgres    57344 Jun 30 08:15 16609
> >-rw-------    1 postgres postgres    16384 Jun 29 11:45 16610
> >-rw-------    1 postgres postgres    16384 Jun 29 11:45 16611
> >-rw-------    1 postgres postgres    16384 Jun 30 08:15 16612
> >-rw-------    1 postgres postgres    57344 Jun 30 08:15 16613
> >-rw-------    1 postgres postgres    16384 Jun 29 23:30 16614
> >-rw-------    1 postgres postgres    16384 Jun 29 23:30 16615
> >-rw-------    1 postgres postgres    16384 Jun 29 23:30 16616
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16617
> >-rw-------    1 postgres postgres    32768 Jun 29 11:44 16618
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16619
> >-rw-------    1 postgres postgres   139264 Jun 30 08:15 16622
> >-rw-------    1 postgres postgres   163840 Jun 30 08:15 16623
> >-rw-------    1 postgres postgres    65536 Jun 29 11:44 16624
> >-rw-------    1 postgres postgres    16384 Jun 30 08:15 16627
> >-rw-------    1 postgres postgres    16384 Jun 30 08:15 16628
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16629
> >-rw-------    1 postgres postgres    16384 Jun 29 11:45 16630
> >-rw-------    1 postgres postgres    16384 Jun 29 11:45 16631
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16632
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16633
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16634
> >-rw-------    1 postgres postgres    16384 Jun 29 11:45 16635
> >-rw-------    1 postgres postgres    16384 Jun 29 11:45 16636
> >-rw-------    1 postgres postgres    32768 Jun 29 11:45 16637
> >-rw-------    1 postgres postgres    90112 Jun 29 11:48 16638
> >-rw-------    1 postgres postgres    90112 Jun 29 11:45 16639
> >-rw-------    1 postgres postgres  1032192 Jun 29 11:45 16640
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16641
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16642
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16645
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16646
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16647
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16648
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16649
> >-rw-------    1 postgres postgres    16384 Jun 29 23:28 16650
> >-rw-------    1 postgres postgres    40960 Jun 29 23:28 16651
> >-rw-------    1 postgres postgres        0 Jun 29 11:44 16654
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16656
> >-rw-------    1 postgres postgres        0 Jun 29 11:44 16657
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16659
> >-rw-------    1 postgres postgres        0 Jun 29 11:44 16663
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16665
> >-rw-------    1 postgres postgres        0 Jun 29 11:44 16669
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16671
> >-rw-------    1 postgres postgres    32768 Jun 29 11:44 16672
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16674
> >-rw-------    1 postgres postgres        0 Jun 29 11:44 16678
> >-rw-------    1 postgres postgres     8192 Jun 29 11:44 16680
> >-rw-------    1 postgres postgres   991232 Jun 29 11:48 17004
> >-rw-------    1 postgres postgres        0 Jun 29 11:45 17006
> >-rw-------    1 postgres postgres     8192 Jun 29 11:45 17008
> >-rw-------    1 postgres postgres    65536 Jun 29 11:48 17009
> >-rw-------    1 postgres postgres    24576 Jun 29 23:30 17011
> >-rw-------    1 postgres postgres        0 Jun 29 11:45 17013
> >-rw-------    1 postgres postgres     8192 Jun 29 11:45 17015
> >-rw-------    1 postgres postgres    32768 Jun 29 23:30 17016
> >-rw-------    1 postgres postgres  4481024 Jun 29 19:18 18949
> >-rw-------    1 postgres postgres  5455872 Jun 29 16:47 18951
> >-rw-------    1 postgres postgres   122880 Jun 29 16:47 18953
> >-rw-------    1 postgres postgres 13639680 Jun 29 19:41 18986
> >-rw-------    1 postgres postgres        0 Jun 29 11:48 18988
> >-rw-------    1 postgres postgres     8192 Jun 29 11:48 18990
> >-rw-------    1 postgres postgres 83116032 Jun 29 19:33 19697
> >-rw-------    1 postgres postgres        0 Jun 29 11:48 19699
> >-rw-------    1 postgres postgres     8192 Jun 29 11:48 19701
> >-rw-------    1 postgres postgres 33046528 Jun 29 19:31 20278
> >-rw-------    1 postgres postgres 20996096 Jun 29 16:47 20280
> >-rw-------    1 postgres postgres   483328 Jun 29 16:47 20282
> >-rw-------    1 postgres postgres  7929856 Jun 29 19:34 21315
> >-rw-------    1 postgres postgres 201695232 Jun 29 16:48 21317
> >-rw-------    1 postgres postgres  3194880 Jun 29 16:48 21319
> >-rw-------    1 postgres postgres 28385280 Jun 29 19:35 21380
> >-rw-------    1 postgres postgres 59555840 Jun 29 16:48 21382
> >-rw-------    1 postgres postgres  1064960 Jun 29 16:48 21384
> >-rw-------    1 postgres postgres  7077888 Jun 29 19:34 21715
> >-rw-------    1 postgres postgres        0 Jun 29 11:48 21717
> >-rw-------    1 postgres postgres     8192 Jun 29 11:48 21719
> >-rw-------    1 postgres postgres 375799808 Jun 29 19:41 21725
> >-rw-------    1 postgres postgres     8192 Jun 29 16:36 21727
> >-rw-------    1 postgres postgres    16384 Jun 29 16:36 21729
> >-rw-------    1 postgres postgres   335872 Jun 29 19:18 22716135
> >-rw-------    1 postgres postgres  3670016 Jun 29 19:31 23310229
> >-rw-------    1 postgres postgres 22331392 Jun 29 19:33 23322481
> >-rw-------    1 postgres postgres   958464 Jun 29 19:34 23378102
> >-rw-------    1 postgres postgres  1695744 Jun 29 19:34 23425245
> >-rw-------    1 postgres postgres  2727936 Jun 29 19:35 23428750
> >-rw-------    1 postgres postgres 82231296 Jun 29 19:41 23446892
> >-rw-------    1 postgres postgres   344064 Jun 29 19:41 23663666
> >-rw-------    1 postgres postgres    90112 Jun 29 19:41 23664258
> >-rw-------    1 postgres postgres   106496 Jun 29 19:41 23664413
> >-rw-------    1 postgres postgres  3719168 Jun 29 19:41 23664657
> >-rw-------    1 postgres postgres  6127616 Jun 29 19:45 23671656
> >-rw-------    1 postgres postgres  1253376 Jun 29 19:41 27165
> >-rw-------    1 postgres postgres        0 Jun 29 11:48 27167
> >-rw-------    1 postgres postgres     8192 Jun 29 11:48 27169
> >-rw-------    1 postgres postgres   311296 Jun 29 19:41 27195
> >-rw-------    1 postgres postgres        0 Jun 29 11:48 27197
> >-rw-------    1 postgres postgres     8192 Jun 29 11:48 27199
> >-rw-------    1 postgres postgres   335872 Jun 29 19:41 292903
> >-rw-------    1 postgres postgres        0 Jun 29 11:52 292905
> >-rw-------    1 postgres postgres     8192 Jun 29 11:52 292907
> >-rw-------    1 postgres postgres 76627968 Jun 29 19:45 292919
> >-rw-------    1 postgres postgres 557547520 Jun 29 16:48 292921
> >-rw-------    1 postgres postgres  8978432 Jun 29 16:48 292923
> >-rw-------    1 postgres postgres 1073741824 Jun 29 12:58 293131
> >-rw-------    1 postgres postgres 1073741824 Jun 29 14:15 293131.1
> >-rw-------    1 postgres postgres 1073741824 Jun 29 15:20 293131.2
> >-rw-------    1 postgres postgres 1073741824 Jun 29 16:48 293131.3
> >-rw-------    1 postgres postgres        0 Jun 29 16:48 293131.4
> >-rw-------    1 postgres postgres 52191232 Jun 29 16:48 293133
> >-rw-------    1 postgres postgres  1302528 Jun 29 16:48 293135
> >-rw-------    1 postgres postgres 1073741824 Jun 30 00:11 35623486
> >-rw-------    1 postgres postgres 1073741824 Jun 30 00:51 35623486.1
> >-rw-------    1 postgres postgres 1073741824 Jun 30 01:32 35623486.2
> >-rw-------    1 postgres postgres 1073741824 Jun 30 02:13 35623486.3
> >-rw-------    1 postgres postgres 1073741824 Jun 30 02:54 35623486.4
> >-rw-------    1 postgres postgres     8192 Jun 30 08:15 35623486.5
> >-rw-------    1 postgres postgres  5120000 Jun 30 04:57 35623488
> >-rw-------    1 postgres postgres   147456 Jun 30 04:57 35623490
> >-rw-------    1 postgres postgres    65776 Jun 29 11:44 pg_internal.init
> >-rw-------    1 postgres postgres        4 Jun 29 11:44 PG_VERSION
> >
> >
> >./global:
> >total 132
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 1260
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 1261
> >-rw-------    1 postgres postgres     8192 Jun 29 11:45 1262
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16620
> >-rw-------    1 postgres postgres    16384 Jun 29 11:44 16621
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16625
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16626
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16643
> >-rw-------    1 postgres postgres    16384 Jun 29 11:43 16644
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16660
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16662
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16666
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16668
> >-rw-------    1 postgres postgres        0 Jun 29 11:43 16675
> >-rw-------    1 postgres postgres     8192 Jun 29 11:43 16677
> >-rw-------    1 postgres postgres     8192 Jun 30 08:15 pg_control
> >-rw-------    1 postgres postgres       64 Jun 30 08:15 pgstat.stat
> >
> >./pg_clog:
> >total 140
> >-rw-------    1 postgres postgres   139264 Jun 30 08:15 0000
> >
> >./pg_xlog:
> >total 114828
> >-rw-------    1 postgres postgres 16777216 Jun 30 08:15 000000050000004C
> >-rw-------    1 postgres postgres 16777216 Jun 30 02:51 000000050000004D
> >-rw-------    1 postgres postgres 16777216 Jun 30 02:51 000000050000004E
> >-rw-------    1 postgres postgres 16777216 Jun 30 02:54 000000050000004F
> >-rw-------    1 postgres postgres 16777216 Jun 30 02:52 0000000500000050
> >-rw-------    1 postgres postgres 16777216 Jun 30 02:53 0000000500000051
> >-rw-------    1 postgres postgres 16777216 Jun 30 02:54 0000000500000052
> >[postgres <at> pogo gextest]$
> >
> >
> >
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 6: Have you searched our list archives?
> >
> >                http://archives.postgresql.org
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

--

-- 

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

---------------------------(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

postgre Databases

Hi!
Postgre is running but have I forget my database name and now i can not
connect to the database.Is it possible to get all database names.
____________________________________________________________________________
Nur bei WEB.DE Testsieger FreeMail testen und damit 1 qm Regenwald
schuetzen. Jetzt anmelden und mithelfen! http://user.web.de/Regenwald

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Re: postgre Databases

Hi,

On Tue, 1 Jul 2003, Haydar Haydar wrote:

> Postgre is running but have I forget my database name and now i can not
> connect to the database.Is it possible to get all database names.

Connect to PostgreSQL with psql

psql template1 -U postgres

Then enter \l command:

proftpd=# \l
           List of databases
      Name       |  Owner   | Encoding
-----------------+----------+-----------
 ankara2003      | postgres | SQL_ASCII
....

\l will list all databases.

Regards,
--
Devrim GUNDUZ
devrim <at> gunduz.org				devrim.gunduz <at> linux.org.tr 
			http://www.tdmsoft.com
			http://www.gunduz.org

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org

Re: postgre Databases

Hi!
Thanks for your help.
Is there also a way to get the database schema with all tables and attributes?
Devrim GUNDUZ <devrim <at> gunduz.org> schrieb am 01.07.03 09:57:22:
> 
> 
> Hi,
> 
> On Tue, 1 Jul 2003, Haydar Haydar wrote:
> 
> > Postgre is running but have I forget my database name and now i can not
> > connect to the database.Is it possible to get all database names.
> 
> Connect to PostgreSQL with psql
> 
> psql template1 -U postgres
> 
> Then enter \l command:
> 
> proftpd=# \l
>            List of databases
>       Name       |  Owner   | Encoding
> -----------------+----------+-----------
>  ankara2003      | postgres | SQL_ASCII
> ....
> 
> \l will list all databases.
> 
> Regards,
> --
> Devrim GUNDUZ
> devrim <at> gunduz.org				devrim.gunduz <at> linux.org.tr 
> 			http://www.tdmsoft.com
> 			http://www.gunduz.org
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org

______________________________________________________________________________
UNICEF bittet um Spenden fur die Kinder im Irak! Hier online an
UNICEF spenden: https://spenden.web.de/unicef/special/?mc=021101

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster