* tuanhoanganh wrote:
My PITR work well from 01/01/2011 to 06/01/2011. At 06/01/2011
postgresql log have issue
2011-01-06 08:27:54 ICT LOG: archive command failed with exit code 1
2011-01-06 08:27:54 ICT DETAIL: The failed archive command was: copy
pg_xlog\00010004005E
D:/3SDATA
* tuanhoanganh wrote:
I have checked your solution.
- Target disk full : No
- PostgreSQL user does not have write privilege for the target directory
: No
- Target file exists already (then you have a bigger problem) : Last
file in D:/3SDATABACKUP/PITR/WAL is 00010004005D
- Post
Hello all,
the PostgreSQL manual, section 24.3.1, has an example archive_command
for Windows. It is
copy "%p" "C:\\server\\archivedir\\%f"
. The next sentence disclaims this as "an example, not a
recommendation". I just had occasion to do some tests with that, and it
appears to me t
* Magnus Hagander wrote:
On Wed, Jan 19, 2011 at 19:20, Christian Ullrich wrote:
So when PostgreSQL runs "copy 000...5E D:\...", it fails, and when you do
the same thing as the PostgreSQL user, it works. Interesting. Try increasing
the log level in postgresql.conf to see if i
* tuanhoanganh wrote:
I download postgresql from Enterprise DB
On Thu, Jan 20, 2011 at 6:06 AM, Christian Ullrich mailto:ch...@chrullrich.net>> wrote:
We cannot assume that the one-click installer was used, but if it
was, the service account it creates will be a member of the
* tuanhoanganh wrote:
Here is procmon i thinks error
[some procmon events]
No, that is all OK. The event at 2:39:55.7588651 is where Postgres
starts cmd.exe to perform the copy. The really interesting data would be
from cmd.exe itself, which implements the copy command.
Please send the eve
* tuanhoanganh wrote:
I have changed archive_command to
archive_command = 'copy %p D:\\3SDATABACKUP\\PITR\\WAL\\%f'
and it work again.
Argh. How could I not have seen that?
But why old archive_command work from 01/01 to 05/01
archive_command = 'copy %p D:/3SDATABACKUP/PITR/WAL/%f'
It works
* Harald Armin Massa wrote:
Should PostgreSQL maybe provide its own file-copy utility for
Windows that meets the requirements for safe WAL archiving?
Microsoft does provide an enterprise-ready webscale copy program ... it
is called robocopy and part of the Windows Server Resource Kit T
* Alessandro Candini wrote:
Il 14/02/2011 21:00, Allan Kamau ha scritto:
On Mon, Feb 14, 2011 at 10:38 AM, Alessandro Candini wrote:
No, this database is on a single machine, but a very powerful one.
Processors with 16 cores each and ssd disks.
I already use partitioning and tablespaces for
* Yan Cheng CHEOK wrote:
I was wondering, is there any good way to drop a constraint? Currently, I am
making assumption on the check constraint name.
ALTER TABLE backup_table ADD CHECK (fk_lot_id = 99);
If I want to drop the above CHECK constraint, I will do
ALTER TABLE backup_table DROP C
* dhaval257 wrote:
No It is not using .NET framework. I tried with libpq but ended up with
error that "Application can not run because SSLEAY32.dll is missing"
(something like this). So I left that thing. Have you used libpq?
ssleay32.dll is part of the PostgreSQL distribution, and is installe
* Stephen Frost wrote:
* Brian Crowell (br...@fluggo.com) wrote:
However, the eventual goal was to connect to this same server from a
.NET app running on Windows, and here I've run into a snag. The Npgsql
library does not support GSSAPI—it only supports SSPI, which is
nearly-but-not-enough-like
* Stephen Frost wrote:
* Christian Ullrich (ch...@chrullrich.net) wrote:
I tried to fix it using the reverse of they one-line fix that worked
in both JDBC and libpq. There, the problem was that they only
supported GSSAPI and had no clue about SSPI (except libpq on
Windows). The fix was to
* Francisco Figueiredo Jr. wrote:
On Tue, Nov 5, 2013 at 2:35 PM, Christian Ullrich mailto:ch...@chrullrich.net>> wrote:
* Stephen Frost wrote:
* Brian Crowell (br...@fluggo.com <mailto:br...@fluggo.com>) wrote:
However, the eventual goal was to connect
* Christian Ullrich wrote:
Nov 1 10:31:50 infra1 postgres[25277]: [7-1] FATAL: accepting GSS
security context failed
Nov 1 10:31:50 infra1 postgres[25277]: [7-2] DETAIL: An unsupported
mechanism was requested: Unknown error
Nov 1 10:39:31 infra1 postgres[25587]: [7-1] FATAL: accepting GSS
* From: Brian Crowell
> On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell wrote:
> > I think I'm getting closer though. I have psql on Windows successfully
> > authenticating, so I can't be too far off.
>
> Got it.
Great!
> The NpgsqlPasswordPacket class has a bug: a utility function it calls
>
* From: Brian Crowell
> On Mon, Nov 11, 2013 at 11:56 PM, Christian Ullrich
> wrote:
> >> On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell
> wrote:
> >> * If I don't specify my username, Npgsql sends it in lowercase
> "bcrowell"
> >
> > Hm
* Adarsh Sharma wrote:
Today I am facing a simple problem that I fail to solve after 2 day try.
I have a places table in database whose structure is as :
CREATE TABLE places
(
woe_id character varying(15) NOT NULL,
iso character varying(6),
"name" text,
"language" character varying(6),
place_t
* Adarsh Sharma wrote:
Christian Ullrich wrote:
Write a set of functions to get the higher-level structures (country
for states, etc.) for any given record, and put a trigger on the table
that populates the fields on insert and update.
All the world data is populated in the places
* Condor wrote:
Problem was when I start: pg_dump dbname | split -b 1G - filenameI
unable to restore it correct. When I start restore DB i got error from
sql he did not like one line. I make investigation and the problem was
in last line of first file value field was something like '"This is a '
* Adarsh Sharma wrote:
In the evening, by mistake I issued a *drop database globedatabase* command.
Is it possible to get the data back till the state before drop database
command.
My pglog files is in the E:/data directory & Binary log is also enabled.
You do not mention that you have a f
* Adarsh Sharma wrote:
I have following files in my pg_xlog directory :
000100070091
[...]
000100070098
I think I issued the drop database command 1 month ago.
From the manual, I understand that my segment files are recycled to
newer ones :
PostgreSQL always writes
* Adarsh Sharma wrote:
2. I installed Postgresql-8.3 in new server and trying to use the data
directory but it faces the below error :-
Existing data directory is not empty and it cannot able to use it .
First, be very, very careful. initdb already saved your data from
destruction once, but
* AI Rumman wrote:
I am using database with UTF8 and LC_CTYPE set as default value in
Postgresql 9.1.
But I cannot insert bengali character in a column.
Query Failed:INSERT into tracker (user_id, module_name, item_id,
item_summary) values ('1','Leads','353','বাংলা টেস্��...')::ADODB
error::->ER
* Abraham, Danny wrote:
FATAL : could not read directory base": Invalid argument
8.2.4 on Windows. Service will not start. Any idea
The data directory path should be quoted, but yours only has the
closing quote. The parameter should look like
-D "S:\ome\path\goes\here"
, so add
* GOO Creations wrote:
This is what I have until now to insert data
char *query = "insert into table1 (bytes) values ($1)";
QByteArray chip = ;
const char *data = chip->data();
const char* params[]={data};
const int params_length[]={chip->length()};
const int params_format[]={1};
result = PQexe
* Dave Page wrote:
Thats very odd, but it explains why things are going wrong -
essentially, the prerequisites are being unpacked to:
C:\Users\Administrator\AppData\Local
But the installer expects to find them in:
C:\Users\Administrator\Lokale Einstellungen\
Which is a link to the first fold
* Andrew E. Tegenkamp wrote:
I have two tables and want to attach and return the most recent data from
the second table.
Table 1 has a counter ID and name. Table 2 has a counter ID, Reference (to
Table 1 ID), Date, and Like. I want to do a query that gets each name and
their most recent like. I
#x27;m not very pleased with having to run PostgreSQL on NT, but these
are the facts I can't change. So, keep up the good work!
Yours,
--
Christian UllrichRegistrierter Linux-User #125183
"Sie können nach R'ed'mond fliegen -- aber Sie werden sterben"
*** e
* Tom Lane wrote on Monday, 2000-12-04:
> Christian Ullrich <[EMAIL PROTECTED]> writes:
> > I've just gotten PostgreSQL 7.0.3 to build and actually run under
> > WinNT 4.0, and the regression tests show two problems: one probably
> > minor in horology (I s
30 matches
Mail list logo
