What's the advantage of using pg_dumpall over tar/gzip for backup?
postgres
create database cpos;
\connect cpos postgres
I don't know why it stopped there. The size of the database is about
350MB. I allocated about 6 hours for the backup and it still fails.Is
there a limit to the size of the database for pg_dumpall or is it because it
takes much longer time than 6 hours for 350MB?
Regards,
Thomas.
Anyone knows of any good web hosting that support PostgreSQL?
Regards,
Thomas.
Also what is the entry?
Thanks,
Thomas
==
|[EMAIL PROTECTED] | Thomas Lester |
| http://www.iakom.com | System Administrator |
| | Iakom |
==
That worked for me... I made the change in my hba file for the host that
needs to connect and it works. I wish I had enough experience in that
matter to help you out, but I don't...
Good luck,
Thomas
==
|[EMAIL PROT
-)
Cheers,
Tom
--- Sisters of Charity Medical Center --
Department of Psychiatry
Thomas Good, System Administrator<[EMAIL PROTECTED]>
North Richmond CMHC/Residential Services Phone: 718-354-5528
7
d at run time as you would expect. Fixing this behavior would
seem to be a good project for someone (maybe me :) for v6.6...
- Tom
--
Thomas Lockhart [EMAIL PROTECTED]
South Pasadena, California
- Tom
--
Thomas Lockhart [EMAIL PROTECTED]
South Pasadena, California
tory
> `/disk3/pgsql/postgresql-6.4.2/src/interfaces/ecpg'
> gmake[1]: *** [all] Error 2
> gmake[1]: Leaving directory
> `/disk3/pgsql/postgresql-6.4.2/src/interfaces'
> gmake: *** [all] Error 2
>
>
North Richmond Community Mental Health Center
Thomas Good Information Systems Coordinator
E-Mail: tomg@ { admin | q8 } .nrnet.org
Phone:718-354-5528
Fax: 718-354-5056
Empowered by PostgreSQL 6.3.2
you tell me what this cryptic message means?
Thanks alot,
Tom
--- North Richmond Community Mental Health Center ---
Thomas Good MIS Coordinator, Senior DBA
Vital Signs: tomg@ { admin | q8 } .nrnet.org
stale lock...forcing a dump and reload.
Ouch (and thanks!),
Tom
--- North Richmond Community Mental Health Center ---
Thomas Good MIS Coordinator
Vital Signs: tomg@ { admin | q8 } .nrnet.org
> So it seems the 6.5.1 changes are not listed in the INSTALL file,
> though there was some attempt to add them. Thomas, does this make
> sense?
Oops. Sorry, I must have forgotten a section :(
- Thomas
--
Thomas Lockhart [EMAIL PROTECT
RROR: cannot read block 1630 of
pg_log.
Every time I get an error I have to kill the postmaster process or stop
& start postgres.
Can I
- somehow repair pg_log?
- dump the database without access to pg_log?
- delete pg_log?
- restore pg_log from my last backup?
Any suggestions?
Thanks
--
Tho
I was running version 6.4.2 when I lost all the binaries. I still
have all the data/* and data/base/* files.
The port for FreeBSD is 6.5.3. I have it installed, now. The disk
file formats changed between version 6.4.2 and 6.5.3.
Is there a tool or mechanism to translate these files into a for
If I understand your question correctly, createuser will do this.
'man createuser'
...
-D Does not allow the user to create databases.
I just completed a lot of recovery from losing all the bin/* part of
psql version 6.4.2, and had to install 6.5.3. The disk file format
changed, so, I had to translate the disk files into sql commands.`
Most of the tables I had were text, char, etc. So, I used the
standatd unix tools, like stri
values (" + i +
> ")")
> print " inserted"
> except TypeError,e:
> print '\nerror ', e, 'undefined'
> #conn.query( "update test_blob_s set filename = '" + name + "')
modules.
Good hunting,
Tom
SVCMC - Center for Behavioral Health
----
Thomas Good tomg@ { admin | q8 } .nrnet.org
IS Coordinator / DBA Phone: 718-354-5528
ly starting the service with
-B 256
-i
-N 48
-o '-F -S 512'
This seems NOT to be the right value but I don't know it what way I can
experiment with them?
If somebody has some tips handy i'd like to hear them.
Thanks,
Thomas
se indexes where needed and everything is vacuumed up to 8 times a day. But
the load is not affected by it. I can't seem to find "what" is pressing the
db.
Does query optimization help a lot or does it only affect the performance in
a little manner? Most queries look for rows with a specific primary id and
return parts/the whole row.
Any optimizations hints?
Thanks,
Thomas
se my disk
access speed on my server and it's help.
hopefully this suggestion will help..
Regards,
Thomas wong
Karla Peralta wrote:
>
>
> Hi,
>
> I have some problems with the perfomance when I run my program
> and I'm just testing in two machines.
>
> I hav
and my machine starts
swapping a lot. (1gig RAM). When I shutdown the DB and restart it each
process is small again but they are growing ... through that the db gets
slower and slower and I wonder how i can get by this high mem usage?
Im running on Redhat 6.2 (p3-800 + 1gig ram).
thnx,
Thomas
any advices how I can dump or vacuum my db again?
thanks in advance,
thomas
Hi there,
i have a little problem with one of my tables. can someone explain me how to
find that record?
vacuum says:
NOTICE: Rel mxaccounts: TID 226/18: OID IS INVALID. TUPGONE 0.
VACUUM
mxaccounts is my table, but how do i find the record causing this notice?
thanks in advance,
thomas
i hope this list is somewhat the right one for this ...
i did some small tests with postgresql-71.beta4 on various
filesystems (ext2, reiserfs, xfs) on two machines: 1 single
cpu and one 2 cpu smp and was a bit surprised to see the tps
results of the smp case to be lower than the one of the up ca
er numbers)
may this be the reason for the missing improvement in the numbers
in the smp case?
again - a lot of thanks in advance
t
Thomas Graichen <[EMAIL PROTECTED]> wrote:
> i hope this list is somewhat the right one for this ...
> i did some small tests with postgresql-71.beta4 on
Tom Lane <[EMAIL PROTECTED]> wrote:
> Thomas Graichen <[EMAIL PROTECTED]> writes:
>> i hope this list is somewhat the right one for this ...
>> i did some small tests with postgresql-71.beta4 on various
>> filesystems (ext2, reiserfs, xfs) on two machines: 1 si
> ... See included png file.
What kind of machine was this run on?
- Thomas
> Thanks for the help, in fact that is Exactly what is wrong. The
pg_shadow
> table has duplicated entries in it, I think I'm going to create a
unique
> index on it.
Forgive me if I'm wrong about this, but doesn't the SQL Standard
prohibit duplicate rows in a table, unique index or not?
--
x27;/NULL/g" < informix.dump > pg.dump
- Thomas
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Where can I find debian packages for PostgreSQL 7.1 ??
Thomas
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
1gig ram + uw scsi drives running
redhat6.2
thanks cu,
thomas
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
t_timeout = 300
i would really be interested in using 7.1 cause i set it up for a new
project (running a dual-p3-1ghz + 2 gig ram) and this machine really needs
good performance and i use (binary &|) which wheren't available in <7.1
afaik.
thanks,
thomas
---(end
No change in php conf ... the only change is the upgrade to 7.1.
hmpf (i hope the next dual p3-1ghz won't break with 7.1, i need it there
...)
cu
thomas
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appr
Hi,
hmm I don't know if I'm right but I think when I run the postmaster with
default values configured it should run at least in a acceptable manner. But
it does not. Also it does not respond to any minor tweaks like increasing
wal-buffers, wal-files, sort-mem, etc. ... Its just doing his weird a
ny help?
thank,
thomas
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
.. enhance?
Thanks in advance.
--
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
| Shaun M. ThomasINN Database Programmer |
| Phone: (309) 743-0812 Fax : (309) 743-0830|
| Email: [EMAIL PROTECTED]AIM : trifthen
Oops. That's right. I was relying on memory, which is less reliable
than man. Fortunately, I always consult man before killing... :P
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Av
I've seen an announcement of this sort regarding
PostgreSQL, and I'm just curious about the release mechanism for it.
I doubt if anyone is spoofing Tom, but in an era of phishing and
spoofing, one can't be too sure, especially if one is concerned about
security...
-tfo
--
Th
vulnerability.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
---(end of broadcast)---
Database recovery from write ahead logs is only supported in PostgreSQL
8.0.0 and later.
---
hi
I have to setup some backup policies for our postgres server.
I had a few queries regarding corruption of database.
what are the ste
.
there's a Perl script in the PostgreSQL contrib/oracle directory, that does a
good job after some tweaking.
Ciao,
Thomas Pundt
--
Dr. Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 5: don&
Did you build from source? Did you explicitly enable PL/Perl during configuration?You need to specify --with-perl to configure to get it to build:http://www.postgresql.org/docs/8.0/static/install-procedure.html --Thomas F. O'ConnellCo-Founder, Information ArchitectSitening, LLCStrategic
Johnson Zhao wrote:
Hi,
I use Postgresql 8.03/ 8.04 on windows xp with sp2, all have same problems.
run the windows cmd by:
runas /user:postgres cmd
and run the initdb program like:
initdb --locale=C --username=postgres -W -A md5 -E UNICODE -D ../data
then it says:
creating directory ../d
orted that database with 8.0 as Inserts to a text file and tried
to fix it using iconv, but that fails as well:
# iconv -f UTF-8 -t UTF-8 dump.sql > dump-fixed.sql
iconv: illegal input sequence at position 252
How can I fix the sql script to import it?
I have Debian Linux 3.1.
Thanks
Is postgres actually running? And is your pg_hba.conf file configured
to allow local UNIX socket connections?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On M
some options!
But I'm hopeful that autovacuum will be integrated into 8.1, thereby
laying this issue to rest.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nas
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Mar 3, 2005, at 3:56 PM, Ken Reid wrote:
I am new to postgres and was wondering if table partitioning
is supported in Pos
Dear,
I was wondering if they were a set of stored procs like the Log4PLSQL
available for PostgreSQL ... ?
Tx,
\T,
--
Thomas Lionel SMETS
rue J. Wytsmanstraat 62
1050 Brussels
T : +32 (0)2 742 05 94
M : +32 (0)497 44 68 12
@ : [EMAIL PROTECTED]
Do you skype (callto://tsmets
remove
_
Because e-mail on your cell phone should be easy: Try Windows Live Mail for
Mobile beta
http://www2.imagine-msn.com/minisites/mail/Default.aspx?locale=en-us
---(end of broadcast)--
delete
_
Because e-mail on your cell phone should be easy: Try Windows Live Mail for
Mobile beta
http://www2.imagine-msn.com/minisites/mail/Default.aspx?locale=en-us
---(end of broadcast)--
remove
> Subject: Re: [ADMIN] Database wont start anyway
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: [email protected]
> Date: Thu, 8 Jun 2006 18:12:55 +0200
>
> Am Donnerstag, den 08.06.2006, 11:44 +0200 schrieb Fourat Zouari:
> >
I did not find anything similar in postgresql.
Is there any chance to monitor the current transactions and abort them,
in case of need?
Thanks,
Thomas Mack
TU Braunschweig, Institut für Informationssysteme
---(end of broadcast)---
TIP 4: Have y
emote client
for some magic reason (select * from t1, t2 with 250,000 and 512,000 rows).
I think, I can live with it for now, as I will upgrade later this year.
Thanks,
Thomas Mack
TU Braunschweig, Institut für Informationssysteme
---(end of broadcast)---
Am Dienstag, 27. Juni 2006 15:47 schrieb Tom Lane:
> Thomas Mack <[EMAIL PROTECTED]> writes:
> > Am Montag, 26. Juni 2006 22:15 schrieb Tom Lane:
> >> What platform is that? If it's Solaris, see our doc/FAQ_Solaris
> >> about getting more useful info f
on configure. And you have to
run them on a different port. This works for us back since a 6.5
version of postgres.
Thomas Mack
TU Braunschweig, Institut für Informationssysteme
---(end of broadcast)---
TIP 4: Have you searched our l
to 8.1
>>soon (hopefully)
>>
>>
>
>Before upgrading read the Release Notes for all newer versions to
>see what changes you'll be getting. See also "If You Are Upgrading"
>in the Installation Instructions and read the Backup and Restore
>chapte
On Monday 31 July 2006 10:06, Aaron Bono wrote:
| Is there a way I can tell PostgreSQL to give session a low priority so even
| if it does take the full CPU, it only does so if it would otherwise be
| idle?
the "nice" command might do what you want...
Ciao,
Thomas
--
Thomas Pun
Hello,
my configuration exists of 2 db-nodes, 2 replication
nodes and 1 loadbalancer.
Is it able to replicate only some tables (not all) to
a third db node.
Has someone experiences with cascaded reolication.
Can anyone post a sample conf for cascading?
Best regards
Tom :)
s it
> fails to log to the log file as directed and just "doesn't look right",
> like it does on Linux.
>
I have a rather old one, which originally started and stopped a 6.5.2
postgres on Solaris 5.6 . Now it does its
When I try to install silently on windows xp the error message is
Internal account lookup failure. No mapping between account names and
security IDs was done.
I have deleted existing accounts and rebooted the os before.
I have read a workaround would be creating the users manually. This is a
pr
I have tried creating the service account manually before starting the
installer.
Nevertheless the installer says "User account .潰瑳牧獥瀀偧獡睳牯d\潰瑳
牧獥瀀偧獡睳牯d does not exist".
The batch file is
msiexec /i postgresql-8.1-int.msi /qn INTERNALLAUNCH=1 DOSERVICE=1
DOINITDB=1 CREATESERVICEUSER=0
S
nd them to postgres from
| the shell?
yes; the following should work:
#!/bin/bash
psql <<_EOT_
ALTER USER foo with encrypted password 'bar';
CREATE USER foo;
CREATE DATABASE bar owner foo;
_EOT_
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
Hello everyone,Actually i'm working in a java project which attemps to storage oid data types in a postgres7.4.Anyway, when my application tries to store an oid, it throws a sqlexception that says:ERROR: the column «doc_cidt» is of type oid but yhe _expression_ is of type bytea
i'll give you my tha
oesn't work to a
| random user account
| and set on .bashrc
|
| LD_LIBRARY_PATH=:/usr/local/pgsql/lib:/usr/local/pgsql/lib
|
| PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/local/pgsql/
|b in:/usr/local/pgsql/bin
|
you want to repeat this step for other users required to run
--
Med venlig hilsen/Kind regards
Thomas Damgaard Nielsen
http://thomasdamgaard.dk
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
When connection to the server with pgadmin3 there is a warning:
"The server lacks instrumentation functions ..."
There may be something wrong with my installation.
The server is version 8.1.4, it is the version for sles9 downloaded as
rpms from suse.
---(end of broadcast
50117
(prerelease) (SUSE Linux)"
Any idea what's going wrong? Did the wxWidgets include "structure" change
recently?
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
make all-recursive
make[1]: Entering directory `/home/pundt/projects/pgadmin3&
sorry, wrong list!
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
i cant
restore (out of memory error or corrupt tar header at ...)
how can i backup (and restore) such a db?
kr
Thomas
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Hi,
logfile content see http://www.rafb.net/paste/results/cvD7uk33.html
- cat /proc/sys/kernel/shmmax is 2013265920
- ulimit is unlimited
kernel is 2.6.15-1-em64t-p4-smp, pg version is 8.1.0 32bit
postmaster process usage is 1.8gb ram atm
thx
Thomas
Shoaib Mir schrieb:
Can you please show
Hi,
free diskspace is 34gb (underlying xfs) (complete db dump is 9gb). free
-tm says 6gb free ram and 6gb unused swap space.
can i decrease shared buffers without pg restart?
thx
Thomas
Shoaib Mir schrieb:
Looks like with 1.8 GB usage not much left for dump to get the
required chunk from
insert statements, maybe directly dbblocks)?
Marcelo Costa schrieb:
To decrease shared buffers you need restart your pgsql.
If do you make on df -h command what is the result, please send.
2006/12/15, Thomas Markus < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>:
Hi,
fr
I would like to hear about any issues related to erserver. I was a
little concerned about its use of Java. Java is a great tool for
creating application frameworks for the payroll department, but using it
for back-end system-level application programming is a bit unnerving.
Java is generally s
Has anyone any experience with PGSQL 7.x and implenting the FTC
do-not-call list - which is about 50 million 10 digit N. American phone
numbers? If so what structures have you used and what have you done
interms of performance tweaks? Is there an equivalent to Oracle's IOT
(index organized tabl
Hi,
I actually try to insert varchar which length is higher than 32 in a column
which type is varchar(32). I can't change the type of the column, and I
want to trunc the data. I know it's possible ! I have seen this !
Example : "j'aime les saucisses avec du beurre dedans" will be "j'aime les
sauc
I want to index my table using the year of the date. So I create the
following function.
create function to_year(date) returns varchar as '
declare
str varchar;
begin
str := to_char($1, "");
return str;
end;
' language 'plpgsql' with (iscachable, isstrict);
But I face the problem as
Hi,
I'm having a really stupid problem -- it seems to be impossible to
download postgre. All of the US mirrors timeout. Is this normal?
There are no apparent problems with my connection.
Thomas E. Burns
Founder, jGuru and knowspam.net
http://www.knowspam.net -- Enjoy Email with knowspa
I ran into a problem compiling 7.4.2 on Sun Solaris. The details are as
follows. Thanks
SunOS 5.8 Generic_108528-29 sun4u sparc SUNW,Ultra-1
Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/specs
Configured with: ../configure --with-as=/usr/ccs/bin/as
-
Can someone suggest an E-R tool that will read a _PG_ database and
create an E-R diagram - crows feet and all? Are there any that are
available for free?
Thanks
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister c
While compiling 7.4.3 on Solaris 8 (sparc) I got:
rm -f thread.c && ln -s ../../../src/port/thread.c .
gcc -pthreads -O3 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declar
ations -fPIC -I. -I../../../src/include -I/usr/local/include
-I/usr/local/ssl/incl
ude -D_REENTRANT -D_POSIX_PT
ution on the net or forums.
Anybody has an idea ?
Thanks.
Bruno Thomas
PS: postresql version is 7.2.1
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
(like pg_ctl) to shutdown postgres.
Sending a kill signal does not work under windows.
Can I shutdown postgres via a command per TCP/IP or direct with a sql-builtin command?
The postgres docu describes only the shutdown functions via pg_ctl.
Thanks a lot for any hints,
Regards,
Thomas Wabner
Why are tablespaces not supported under Win32?
-
Thomas Wegner
Cabrio Meter - The Weather Plugin for Trillian
http://trillian.wegner24.de/cabriometer
---(end of broadcast)---
TIP 1: subscribe and
I use the version fro pgInstaller project. Ok, i must wait
for a new release.
-
Thomas Wegner
Cabrio Meter - The Weather Plugin for Trillian
http://trillian.wegner24.de/cabriometer
"Gaetano Mendola" <[EMAIL PROTECTED]> schrieb im Newsbei
So the question(s)
is:
What can I do to reclaim the wasted TOAST diskspace?
Can I find and eliminate the lost TOAST tuples
somehow?
Thanks!
Best
regards,
Thomas M.
Madsen.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
> Sent: 13. august 2004 21:02
> To: Thomas Madsen
> Cc: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] TOAST tables keeps growing!
>
>
> "Thomas Madsen"
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Stephan Szabo
> Sent: 13. august 2004 19:36
> To: Thomas Madsen
> Cc: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] TOAST tables keeps growing!
>
>
> On Thu, 12 Aug 2004,
Hello where can i found the Log files from this Version?
-
Thomas Wegner
Cabrio Meter - The Weather Plugin for Trillian
http://trillian.wegner24.de/cabriometer
---(end of broadcast)---
TIP 7: don&#
Hello All,
We have a server in our datacentre running PostgreSQL 7.2 with about 50
databases set up (for different customers). We have just commissioned a
much better specified server which is running PostgreSQL 7.4.
We need to migrate the databases from 7.2 to 7.4. The smallest database
contains
l database.
Somebody have a cooking recipe about to test if my
backup is working fine, and will help if I need
sometime?
Are you using pg_dump or pg_dumpall? I just use pg_dump on individual
databases (pg_dumpall works on the whole cluster) and can restore that to
any database.
HTH
--
P
Hello,
where i must place the .pgpass file under win32???
-
Thomas Wegner
Cabrio Meter - The Weather Plugin for Trillian
http://trillian.wegner24.de/cabriometer
---(end of broadcast)---
TIP 8: explain
I use EMS PostgreSQL Manager. They has a graphical
Design Tool and many more.
-
Thomas Wegner
Cabrio Meter - The Weather Plugin for Trillian
http://trillian.wegner24.de/cabriometer
"Sanjay Arora" <[EMAIL PROTECTED]> schrieb im Newsbei
ce, and raised wal_files further
from 24 to 46. Ran "VACUUM FULL" once more.
Those 2 gigs was
also used up pretty quickly...
So this is where i
am now... desperate! Any suggestions will be greatly
appriciated!!!
What can i do to fix
this mess??
Regards,
Thomas.
Tom Lane wrote:
[EMAIL PROTECTED] writes:
2) As i had a very large pg_largeogject, i deleted rows e now i have a
clean, small table.
The table is empty but its index pg_largeogject_loid_pn_index lasts
to retain a lot of bytes.
REINDEX should fix this.
Is REI
smime.p7m
Description: S/MIME encrypted message
I have a postgresql ( psql (PostgreSQL) 7.2.1 ) database where i have a
problem deleting 1 off the tables
Im logged in locally and access it with root
In the database there is among more, 2 tables with similar names:
infected
infected_
When i try to delete the "infected_" ( drop tabl
smime.p7m
Description: S/MIME encrypted message
e;
logname= uid=26 euid=26 tty= ruser= rhost= user=leduc
% psql -U leduc -W
Mot de passe :
psql: FATAL: PAM authentication échouée pour l'utilisateur "leduc"
... IT DOESN'T WORK !!!
% tail -f /var/log/messages
Jan 5 17:42:11 tage postgresql(pam_
00: PAM authentication
échouée pour l'utilisateur "leduc"
Jan 6 10:14:09 tage postgres[21451]: [2-2] EMPLACEMENT : auth_failed,
auth.c:395
=> "User account has expired" seems not to be true !
--
Thomas LEDUC
CNRS UMR 1563 - Laboratoire CERMA - Ecole d'
1 - 100 of 334 matches
Mail list logo
